Or check with

if object_id('tablename') is null

begin

--table name not found create it

end

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q287932

And forceing a lot of rows down to the client can have side effects on memory resources. Not saying Client Side cursor are bad and again they are preferred, but...

From "Transaction Log Backups" in SQL 2000 BOL

quote:

---

Truncating the Transaction Log

When SQL Server finishes backing up the transaction log, it automatically truncates...

Using EM drill to one of the failing jobs. Right click the job, select tasks and do generate script. Oputput to a file and do a search of the file...

No, if the regirsty entries are not backedup regularly then you would not be able to get the server going immediately anyway.

Sorry, there are some items that are not customized as far as installation path. And you cannot force them.

select @@version

output will look like this

Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)

Apr 9 2002 14:18:16

Copyright (c) 1988-2002 Microsoft Corporation

Standard Edition on Windows NT 5.0 (Build...

If you are using a SQL Login account then use -U SQLAccountName -P Password. If you did not set a password on the account when created the just leave the...

Actualy look at CPU, Duration, Reads, and Writes. The higher the combined values the more costly the query is in relation to other items. Reads and Writes being have the...

Is is the preferred method to use Command Object of adCmdStoredProc instead of a .Execute on the Connection object, the .Open of a Recordset Object or as adCmdText in a...

What type of connection are you trying to make, a SQL Login based connection or NT Authentication using your NT account. If the later make sure you use the -E...

I seem to recall that happened in early SPs for SQL 7 and no mention of the same in SQL 2000. However, I usually delete the files in the temp...

I think this is related to the SQL Version, I do it with xp_cmdshell and the count does not return in SQL 2K but does with SQL 7. I do...

It will clean up everything except Jobs, views and processes in other DBs that referece the dropped DB and DTS packages. If you have anything in those areas you will...