you should be able to embed it in a script task

yes, you can retain the virtual name in your current instance.

yes, you will need another set of disks and another IP address. get your disks set up on the box and then run sql server setup to add another instance.

I found the problem. After installing most recent service packs, DMMM still wasn't working properly. I went to manage server instance connections and removed them all and added them back...

I'll give that a try. I tried manually launching both, and still had the same problem. I'll try the latest service packs and see if that helps. Also, I am...

well, it does it in both my 2005 (90.0.3042.00) and my 2008 clients(10.0.1600.22)

well, when I right click a database, it doesn't give the the option to unregister the database. it only gives an option to register a database, manage server instance connections,...

Mine is set to standard, not 2000. Must be a setting though. When I did the install, I chose to import the 2005 settings. When I went to options/environment/keyboard and...

Cigarretts is mine. I try to quit about 2 times a year and always fail.

you can right click the table name in SSMS and choose view dependencies. This should show you any views that use that table.

you need to register the instance in SSMS

good catch, I was under the assumption it used a new connection, which is obviously wrong. Generally when I see these errors (object not found on a temp table) I...

I take it you are trying to execute the SQL String using sp_execute or simply the EXECUTE() command? In this case I believe it opens a new connection and therefore...

not sure about NetBackup, I have not used that product, so I couldn't tell you if either product will integrate, but I can tell you I have run comparisons of...

you could put the database in single user mode, but I'm not sure if it would work from an SSIS package. Worth a try I suppose