If the process includes a linked server, and/or some other ODBC connectivity, you may not be able to remove it without restarting sql. restarting MSDTC may resolve it but not...

NoLock is not assumed.

You can add "set transaction isolation level read uncommitted" and all tables opened in that connection will be opened with nolock. Otherwise, use [with] (nolock) after each...

My current advice is also to not use the 3GB switch. Here is a recent, yesterday, comment from an engineer at Microsoft.

Unless you have the benchmarks, and dedication...

Its not true migration...but you can move the DTS packages, and then execute them using Execute DTS 2000 Package task in SSIS. This could be a temporary way to get...

Individual files were an option in 2000. Another lost featue! Also, you can not scrip drop and add at the same time, or preview the TSQL.

You will be upgraded. Resistance is...

Here too we use active/passive clustering for HA and log shipping (custom built) for DR

Terry

Sometimes when a db is marked as suspect, and all other attempts to get it back fail, the last resort is to bring it up in emergency and select out...

From a prior post...

Let's get something straight from the get-go. The First Amendment is sacrosanct. Freedom of speech, freedom of the press, freedom of thought, the whole ball of wax...

This may be a stupid comment, but you must be sure you are moving it to a clustered resource, not a local drive.

Terry.

Don't the 100+ ppl who go this wrong have access to Query Analyzer? A cut/paste/execution lasting 5 seconds and you have the answer.

No offense meant!

Terry

There are plenty of network monitoring tools you could use...

Here is TSQL I use to see what node is running. The first line of 'net statistics server' returns the...

Sam,

Often this is a way to let your developers, or you (shrug) put together a quick ACCESS application while the data remains in SQL, with all the backups etc concerns...

Agree with Adam. Backup locally, zip, and xcopy all from TSQL (if you have xp_cmdshell enabled).

If you don't have room on the local server, you can backup to UNC path....

ONe more advantage to TVs over temp tables is the optmizers ability to use the TV in determining an execution plan, where often it can not do so with a temp table....

TVs are not 100% memory objects...

http://support.microsoft.com/?kbid=305977

Q4: Are table variables memory-only structures that are assured better performance as compared to temporary or permanent tables, because they are maintained in a...