No, each instance needs it's own IP. Really own socket, so a separate port.

Please don't beat the horses on this site. Gets me in trouble with my wife 😉

Feel free to start a new thread for new issues.

As to why the log doesn't drop to zero, there are virtual log files inside the physical file and you cannot...

Greg's idea will work, though I'd still be way of support people being able to change packages. At the very least, they should edit the package in a dev server,...

I'm sure that NETAPP has thought this through, but freezing activity for a few minutes doesn't guarantee integrity. There could be changes in flight when they do that. Or potential...

I used to do something probably like what Scot does and I had hundreds of databases (actually over a hundred servers as well) to monitor. The report is generated for...

So the machine is not part of the domain. I'm not sure it's more or less secure than being on the domain. The same type of security is used to...

I agree with Grant. There's no way to know what works better. It really depends on how things are written and what the breakdown is of tasks in each SP.

I...

You can restore the 2000 db to 2005.

However this doens't move the logins you may need. On this site, you can search for sp_help_revlogin and use that to script...

Scott has good information, but also remember a full backup does NOT remove data from the log. You need to do a log backup to clear the space and allow...

http://www.sqldts.com

Please don't cross post:

answered here http://www.sqlservercentral.com/Forums/Topic493722-20-1.aspx?Update=1

Please don't cross post. Answered here: http://www.sqlservercentral.com/Forums/Topic493722-20-1.aspx?Update=1

You should be able to include the user/password in the DTS package connection.

Is there a question you have?