Never mind.  It threw me off when the color of the sp_reassign_dtspackageowner did not change in Query Analyzer.  Since you pointed out that it is on MSDB database, would there...

This must be for SQL 2005, is there a SQL 2000 way to do it?

Thanks Greg!

Andy I think you are on to something.  All updates, deletes, inserts are done with SPs throught the application.  It will take some testing to make sure it works.  Thanks...

Let me backup a little.  The users connect to the database through an ODBC connection.  (Not my design but a pre-purchased application that MUST have the ODBC connection to operate). ...

Thanks Holger.  I guessed at that option too but the wrinkle here is within Query Analyzer the user has the option to connect using their Window's Account or a SQL...

Nevermind, I got it.  I didn't realize that I could use the @Parameter in my dataset.  Maybe there is another way but this...

I am a believer that you should always work as hard as you can to make the work that you've done easy to be handed off to someone else.  Working...

Rodrigo,

Doesn't the restore try to recreate the database as a new publisher?

Tom,

Thanks for your reply.  Unfortunately in our environment, there is no such thing as "off-hours".

I have fixed the mess that I created by making a backup of Northwinds and...

Ok, now I really have things messed up.  I have stopped the restore job - took about 3 hours to stop.  Now I have a development database that thinks it...