Kalvin,

I think there is a mixed environment out there. Lots of people are excited about 2005 and many companies will move because they have software assurance, they don't want to...

Please post this in the appropriate thread or forum for the question, like the admin forum. This forum is for the Question of the Day only.

Please post in the appropriate thread for the day. The main board is not for posting messages.

I guess I'd argue that MS is subtlely been anti-open with their products, but that's me.

I think you should use the platform that works best and if it claims to...

They better get some tents then.

We're selling and moving to a place with less bedrooms.

It's not that kept up

Need to mow some grass. That horse won't eat it fast enough

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.