It certainly took awhile for someone to point out the use of IsNull(). Sloan definitely hit the target.

Here's a snippet of some code from a stored proc that extracts contact data to a file. I first insert and format my output within a staging table.

CREATE PROCEDURE...

I haven't had a problem connecting to a named instance on SQL Server 2000 when using an ODBC DNS. We do have an app that uses a BDE connection...

You may also want to change your NOT IN with NOT EXISTS and have your sub-select be SELECT 1 FROM tablen tn WHERE tn.field1 = field1).

I never heard that referencing a temp table created outside a stored proc causes the proc to recompile evertime the proc is called. That's a new one for me.

Personally...

To follow on Chris's comments, my DB was thrown on a separate instance because I need SA permissions, something the DBAs don't like to hand out on a shared box....

If everyone has their own login use system_user. You also can check out user_name() and suser_name(). I tend to use system_user with SQL Server and suser_name() with Sybase.

...

I'd agree with Phill. Put your web site into maintenance mode during a slow traffic time and detach and attach.

What we often do is set up shadow tables, tables that mirror the production tables plus a column for shdw_dt, shdw_action (D,U) and shdw_user (system_user). Then put a trigger...

Error handling in DTS is better. You could break it up there with e-mails generated and paths followed depending upon success or failure. Then just schedule it as...

One note. Whenever you do an EXISTS or NOT EXISTS change your subquery to "SELECT 1" instead of referencing cells. May not be a huge gain but results...

Steve,

Again thanks for the help. This did work in DTS, as I pretty much expected. Found the problem to be related to the connection tool used by the...

Thanks Steve. Good thoughts. I'll follow-up Monday cause I'm outta here!

Sorry, I should have first stated:

If the user has Enterprise Manager I would do as andoi states and simply make a backup and have the user do a restore.

Sriram,

I'd go along the lines of what mdamera states. Either stop the services on your DB or detach the database (sp_detach_db @dbname = 'database_name').

Then zip and e-mail, post... the...