You can also use something like this:http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

ms_foreachdb works well with one server. When you move to multiple servers, it's a little more complex.

I tihnk banks are a good place to start, but until they get sued, and the INSURANCE companies start raising rates, they won't do much. I don't like fingerprints or...

I'm wordy, but not that wordy

At least I hope not.

Sorry, all the mason jars are full of male cow pies that will be used to power our US Gov't approved and installed generator

Interesting discussions. I've actually solicited some guest editorials next week on this, so keep an eye out and I'd love to see the discussion continued.

I'd like to think it should degrade gracefully and put up some message that things are not available now.

Phil,

If you can't connect, I'd contact MS immediately. You could try running SQLDiag, but that might fail as well.

The CD is the old data. It's been updated to work with a trace flag.

This sounds like something that DTS/SSIS would be perfect for. Have some process copy the file to both servers and then have a package to upload it.

I think that still requires the space for the log to be created.

The * in "select *" actually gets resolved to particular columns when the view is created. It is not then bound to the table. Any changes to the table will...

Passport has other problems. Namely it's run by Microsoft, a software company, not a bank, and it didn't hide your information unless you gave it to Microsoft.

What I think would...

One good thing is I have seen that Google and Amazon have offered to help fund the search and send bodies to help. They also have people trying to analyze...

When you change the system clock, it's within a moment that SQL Server makes the change internally. I'm not sure about users being unable to connect. I know I've done...

Jereme,

Thanks and yes. It's been corrected.

Also, the CG is calling off the search. A sad day.