I want to know whether an index is disabled in SQL Server 2000. In SQL Server 2005 we can do this by querying sys.indexes. Is there a way to find disabled indexes in SQL Server 2000?
View 1 Replies
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is
[Code]....
The BLL method is built like so
[Code]....
When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview
[Code]....
Another item that is causing an error is in trying to update a record. Here is the DAL update method
[Code]....
And the BLL update method
[Code]....
The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource
[Code]....
how can i select data into temp table from another database in sql server 2000
View 2 Repliescan you let me any links which explains about using indexes in sqlserver.
View 2 RepliesIs there an easy way to copy a table with indexes from one database to another (without data) through .NET code?
View 2 RepliesI have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesHow can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesUsing sql server 2000,How to create the dts packages that runs the stored procedure to output the results in excel sheet?
View 3 Replieswt is the difference b/w sql server 2000 sql server 2005
View 4 RepliesSQL query optimation for SQL Server 2000?
[Code]....
What is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.
View 4 RepliesUnable to read local eventlog (reason: The data area passed to a system call is too small). This error is recorded in the event log every minute in the production server, and because of this the SQL Server 2000 performance is very slow and the box is also working slow. This indirectly affects my application and productivity.
View 2 RepliesI want to synchronise two databases from two different platforms i.e. MS Sql Server 2000 and MySql. I have two applications one is desktop application which uses Mysql and other is Web application which uses MSSql. When any changes made to MySql from Desktop application, then that changes should get reflected to MS Sql database and vice versa. I am novice for this kind of situation.
View 4 RepliesI have a table called 'products'. In each table there is a column named 'description' of type ntext (sql server 2000). The description conains a ton of text and within that text there is an ip address many times. I need to replace every instance of the ip address with the actual domain name, 123.45.678.990 with http://domain.com.
View 5 RepliesI have to Encrypt and Decrypt Back the Password field in sql server i have used the pwdencrypt and pwdCompare() but i dont have to compare but i have to display the password back using the Decrypt technique Is there any algorithm which i can use only for encryption and decryption of password field?
View 4 Repliesmoving some tables & stored procedures from SQL Server 2000, to SQL Server 2005.So far so good, but I've come across a problem with this stored procedure:
CREATE PROCEDURE [dbo].[user_insert]
@user_service_unit int,
@user_champion_1 varchar(50),
@user_champion_1_nt varchar(10),
@user_champion_2 varchar(50),
@user_champion_2_nt varchar(10),
@user_champion_3 varchar(50),
@user_champion_3_nt varchar(10),
@user_date_received datetime,
@user_requestor varchar(255),
@user_info_requested text,
@user_expiry_date datetime,
@user_10_days datetime,
@user_5_days datetime,
@user_2_days datetime
[code]...
In my web page I have a Checkbox (datatype = tinyint/boolean) and 2 Required field validator (whose visibility is false). I want that when I check(tick) the checkbox, then required field validator visible = true, else not.For this I tried this code on Page_Load as well as on save button click, but it is not working:
protected void Page_Load(object sender, EventArgs e) {
if (ChkComplexPass.Checked) {
Regex4.Visible = true;
Regex.Visible = true;
[Code] .....
I have a user control in my Master page and need to be able to Enable/Disable it from ANY page. How is this done? My user control has a few TextBox fields and a button. I was hoping to set a public property and simply Enable/Disable, but public properties seem to only work on the Master page code behind and not other pages.
View 4 RepliesI want to enable/disable controls of a asp.net page against a logged in user's permission. say 'admin' & 'hr' can change user's birth date text-box in a page but others will see the text-box as disabled.
so i wrote a function like this
[code]....
I'm trying to enable/disable buttons in my gridview according to a value in gridview's field.
But everytime when I try to run my page, it shows me below underlined error and point to my gvTimeSheet.DataBind() in page_load.
"Unable to cast object of type 'System.EventArgs' to type 'System.Web.UI.WebControls.GridViewRowEventArgs'."
I also tried to enable / disable button in HTML but it just against from what I need it to be.
Example, sheet_status = true, I do not need to enable the button.
[Code]....
how can i enable and disable columns in repeater in the code behind
View 1 RepliesBased on some condition, I need to enable and disable the checkbox in gridview and that would be on page_load event.
View 1 RepliesI have a gridview that is built based on my objectdatasource.. so at the moment, i have 1 gridview linked to 3 different objectdatasource resultsets.. my question is.. only 1 of the 3 do i want to allow or should i say enable the "GridView1_SelectedIndexChanged" ability. Is that possible, that when i bind the datasource to the gridview for that one, i can enable that?
View 4 Replies
