For e-comm, holidays don't make sense, and maybe not weekends. My point is more that the downtime is the time to do deployments, though often that doesn't match up with...

Craig is correct. Service Broker guarantees delivery, but not timing. The transactions in the other servers should still be there.

FWIW, to some extent I think that IT is the group that should work on holidays, and do deployments since this is downtime for many businesses. Of course I think...

Can you provide more information on what didn't work?

Back after a week gone, or most of a week. Somewhat refreshed, and ready to work.

Everyone has different ways to consume this and working with most of the world, the yyyymmdd is the most acceptable. The US prefers mmddyyyy, but that doesn't work in Europe.

I...

It's yours.

Your job ought to be well documented, ready for inspection, or more likely, ready for someone else in case you get hit by the proverbial bus.

There are definitely some military...

You've incorrectly built your command.

Basically you want to execute this:

INSERT #Serverproperties

SELECT 'MachineName', SERVERPROPERTY('MachineName')

To do this on a linked server, look at this: http://www.sqlservercentral.com/Forums/Topic584711-145-1.aspx

LutzM (11/26/2010)

---

Steve Jones - SSC Editor (11/26/2010)

---

Celko is Celko. He has written a lot, and very well, on SQL and standards. However he's an anachronism, a throwback to the past...

This is likely a security/config error for the service account of SQL Server, or the proxy for xp_cmdshell.

First get an account that makes this work. Not your account, but create...

The IO errors are hardware or driver issues, in all likelihood, so follow Gail's advice and make sure someone does full diagnostics as re-using this hardware as is will likely...

Good advice above. As long as you move all non-db stuff (logins, linked servers, jobs, alerts, etc.), and the mirroring sets up, you ought to be fine.

Note that log shipping,...

How large are the files? You should be able to delete them, but I wouldn't expect large files from setup.

If the dependency tree in SQL Server is up to date it works, but it isn't guaranteed. I'd agree with Grant, there isn't an easy way to do this. What...