SET IDENTITY_INSERT yourtablename ON

insert into yourtablename select * from oldserevrname.olddb.dbowner.yourtablename

You need to create linked server from new server to th old one. Or transfer tables to new server using DTS.

...

cliconfg.exe from c:\winnt\system32.

From BOL.

"How to run an unattended installation of SQL Server 2000 (Command Prompt)

You can run an unattended installation by using sample batch files and setup initialization files included on the...

Don't quite understand why you need a virtual ip for setting up a DSN?

You can create server alias using client network utility to your named instance and create DSN to...

DBCC SHOW_STATISTICS

quote:

---

From last few days the database is going very slow.

Can I achieve some performance benefits by moving certain related tables on...

If AWE is not enabled, SQL Server can use only up to 4GB memory.

Are your Web server and SQL Server in different machines? Can you ping to SQL Server from Web Server when you have the problem? Any error message in SQL Server...

Do you refer to SQL Server security audit level setting? I turned it on to audit 'failure' login for some servers only.

Wre are running Windows Datacenter that supports up to 64GB for SQL Server.

I have done few installations including cluster installation in active/active without problems.

Can you ping to SQL Server from IIS box? Any changes made to both servers? Make sure SQL Server is running.

Agreed with you.

The DBA may want to keep the databases small by shrinking them. If you don't have spaces issue, I would not suggest to shrink the database and don't think the...

SQL Server keeps statistics about the distribution of the key values in each index and uses these statistics to determine which index(es) to use in query processing. Users can create...