DataSource Controls :: Enable - Disable Indexes On Table In Sql Server 2000?

Mar 25, 2010

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


Similar Messages:

DataSource Controls :: Import A Table From Sql Server 2000 To Another Server Qsl Server 2005?

Feb 9, 2010

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 Replies

DataSource Controls :: Implementing A BLL / Contacts Table, The Select Method Is A Sql Query Against A Sql Server 2000 Database?

Feb 17, 2010

I'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]....

View 4 Replies

DataSource :: How To Select Data Into Temp Table From Another Database In Sql Server 2000

Jun 9, 2010

how can i select data into temp table from another database in sql server 2000

View 2 Replies

DataSource Controls :: Work With Indexes In Sql Server To Make Application Performacnce Good?

Apr 26, 2010

can you let me any links which explains about using indexes in sqlserver.

View 2 Replies

SQL Server :: Copying Table And Indexes From One DB To Another?

Feb 4, 2011

Is there an easy way to copy a table with indexes from one database to another (without data) through .NET code?

View 2 Replies

DataSource Controls :: LDF File Increasing When Move From SQL Server 2000 To SQL Server 2008

Apr 2, 2010

I 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 Replies

DataSource Controls :: Convert DTS Package From SQL Server 2000 To SQL Server 2005?

Jul 1, 2010

How can convert DTS package from SQL Server 2000 to SQL Server 2005

View 2 Replies

DataSource Controls :: SQL Server - What Is Difference Between SQL Server 2000 - 2005 And 2008

Mar 24, 2010

Does anyone know, what is difference between SQL Server 2000, 2005 and 2008?

View 3 Replies

DataSource Controls :: Sql Server 2000 Using Packages?

May 6, 2010

Using sql server 2000,How to create the dts packages that runs the stored procedure to output the results in excel sheet?

View 3 Replies

DataSource Controls :: Difference Between Sql Server 2000 Sql Server 2005?

May 27, 2010

wt is the difference b/w sql server 2000 sql server 2005

View 4 Replies

DataSource Controls :: SQL Query Optimation For SQL Server 2000?

Jun 28, 2010

SQL query optimation for SQL Server 2000?

[Code]....

View 3 Replies

DataSource Controls :: Move MS SQL Server 2000 To 2008?

Mar 11, 2010

What is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.

View 4 Replies

DataSource Controls :: SQL Server 2000 - Event Log Error Id - 318

Jan 7, 2010

Unable 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 Replies

DataSource Controls :: Database Synchronisation Between MS Sql Server 2000 And Mysql?

Mar 27, 2010

I 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 Replies

DataSource Controls :: Find And Replace Within Field, Sql Server 2000?

Jun 30, 2010

I 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 Replies

DataSource Controls :: Algorithm For Simple Encryption And Decryption Of Field In Sql Server 2000?

Jan 2, 2010

I 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 Replies

How To Move Stored Procedure From SQL Server 2000 To 2005, Multiple Table Insert

Jul 21, 2010

moving 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]...

View 3 Replies

Web Forms :: Enable Disable Required Field Validator From Server Side (Code Behind)

May 7, 2015

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] .....

View 1 Replies

Web Forms :: Enable / Disable User Controls In Master Page

Oct 7, 2010

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 Replies

How To Enable/disable Controls Against A User's Permission Via Type Casting

Jun 2, 2010

I 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]....

View 3 Replies

Forms Data Controls :: How To Enable / Disable Buttons In My Gridview

Jul 15, 2010

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]....

View 5 Replies

Forms Data Controls :: Enable And Disable Columns In Repeater?

Sep 30, 2010

how can i enable and disable columns in repeater in the code behind

View 1 Replies

Forms Data Controls :: Enable / Disable The Checkbox In Gridview?

Jul 9, 2010

Based on some condition, I need to enable and disable the checkbox in gridview and that would be on page_load event.

View 1 Replies

Forms Data Controls :: Enable And Disable Gridview Selecting?

Dec 20, 2010

I 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







Copyrights 2005-15 www.BigResource.com, All rights reserved