Experts Exchange Search Results

Hi Experts, I am planning to change the 'computer name' of my SQL 2000 server. What is the efficient way of changing the server name used by SQL ?(Without re-running the setup or without creatin...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20190313.html

Zones: MS SQL ServerDate Answered: 10/16/2001 Grade: B Views: 0

(250 pts.) SQL 2000 Re-Index Script

Tags: sql, 2000

Does anyone have a good script I can use to re-index all of the tables in a database?

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20703354.html

Zones: MS SQL ServerDate Answered: 08/07/2003 Grade: A Views: 0

sql 2000 sp3 configuration

Tags: sql, 2000

2003 Server, SQL 2000 sp3 My Windows time format small date : 19/11/2003 and SQL use : 11/19/2003 How can I configure SQL server For wanted format (19/11/2003) I tried change in windo...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20802592.html

Zones: MS SQL ServerDate Answered: 11/22/2003 Grade: B Views: 0

Updates fail from VB application to SQL 2000

Tags: sql, 2000

We are running a Visual Basic 6 application with SQL Server 2000 as the backend. In various areas of our program we are having problems doing updates to the database. The updates are accomplished...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20824045.html

Zones: MS SQL ServerDate Answered: 12/12/2003 Grade: A Views: 0

How to use the In Keyword in a stored procedure

Tags: sql, 2000

I trying to run a stored procedure in SQL 2000 with the following code: @sCustomerID nvarchar(50), @sProductClass nvarchar(50) AS Select lRowID, sItemID, sShortTitle, sLongTitle, sLong...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20970014.html

Zones: MS SQL ServerDate Answered: 04/28/2004 Grade: A Views: 0

Memory Problem with SQL 2000

Tags: sql, 2000

Hello everyone I am sorry to bother you all but I am running into a problem with SQL 2000 using a lot of CPU in idle state. Is this common issue going on? And if so how do I fix it? sorry not meany...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21035380.html

Zones: MS SQL ServerDate Answered: 06/23/2004 Grade: A Views: 0

To control uniqueness of a column for certain conditions....

Tags: sql, 2000

In my table gl_vchrdetail the behaviour of the column vd_ref will be this. From July 1 2004 when vd_dr_amt > 0 and when vd_vchr_type ='SALE' then vd_ref column should contain ...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21261040.html

Zones: MS SQL ServerDate Answered: 01/04/2005 Grade: A Views: 0

i need sql 2000

Tags: sql, 2000

I think that by now sql 2000 is free but where can i get it. can u give a link for dowloading sql2000 thanks

http://www.experts-exchange.com/Database/Miscellaneous/Q_21729973.html

Zones: DatabasesDate Answered: 02/22/2006 Grade: B Views: 0

SQL 2000 finding the staus of jobs via T-SQL

Tags: sql, 2000

I know how to check if a job is successful (e.g. backup) via enterprise manager. How do I get the status of jobs and the associated details via raw sql? Cheers Si

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21871183.html

Zones: MS SQL ServerDate Answered: 06/01/2006 Grade: A Views: 0

WAYS to Configure SQL 2000 to run efficiently

Tags: sql, 2000

Want ideas on how to configure SQL 2000 to run efficiently.

http://www.experts-exchange.com/Database/Miscellaneous/Q_21902442.html

Zones: DatabasesDate Answered: 08/11/2006 Grade: B Views: 0