Does netstat -a show the port as open?

DMO could do it, but you have a rights issue. What I'd do is create a good process the sysadmin can use. Then setup a job to restore the db...

No script and I've never really felt the need to use them. Don't see them as that useful and changes occur way more often than I see benefits.

That might be an EM thing. Processadmin should have rights to kill processes, according to BOL. Have you tried using KILL through QA?

There isn't a good way. You could centralize the scripts and just have the DBA or admin run the scripts as DBO, which removes the rights issue, but adds work...

None I know of. How many databases are you talking about? Seems like even at 100 it would be easy by hand.

The other issue is what if you have two...

The backup process is extremely intolerant of any delays in writing data out. That means that if there is a hiccup in the network or a delay in getting packets...

There is a limited go live license, but you need to apply with Microsoft and be accepted or you will not get support and they will consider your installation unlicensed.

It comes in the newsletter everyday

The links are fixed, apologies!!

Ugh

If you were not aware of the code, you can contact PASS and let them know you pinged us here. I'll confirm emails that have been sent to me or...

Yes, apologies.

A SQL Server is a SQL Server instance. Having multiple instances means that you have multiple SQL Servers running on one Windows servers.

The answers state: each database has it's own...

Not mention anything!!?!!?

It's been in a few editorials and a few ads. Register with the source code of "SSC".