Or some $$ if this was production. You can get Log Explorer from Lumigent or Apex Log from Apex to undo the transaction from the log, if you are in...

You looking for more or less? We might be able to add a few variations.

Thanks, Lynn, hopefully we'll meet in person soon.

I have a BA with lots of BS on the side 😛

On one hand I know there are lots of people that work hard and haven't made bad decisions or been the reason that the banks are in trouble. Do they...

I'd agree. Go for 431, make sure you have used SSMS since it asks you to actually click on things and get them done.

Any company can have conservative or risky leadership, it's just in how it's applied. I think lots of investment banks have been very risky with derivatives. Hospitals can choose to...

You can insert..exec into a table.

insert MyTable exec xp_cmdshell ''

but you need to match up the result set with the schema correctly

Actually if you use mirroring, it can automatically flip over if your clients have the SNAC clients.

clustering will flip things over inside a minute, slower than mirroring.

corruption can get moved...

ultimately you have to work together. Departments will go outside the scope of what they should do and when they do, you have to negotiate what happens. IT really ends...

I'd recommend Bruce's approach, though keep in mind that you have a limit of 8kb to send through stuff in the batch.

Definitely specifically limit memory for each instance. The resource issues are your biggest ones. We did this here at SSC and it worked fine.

Also be aware that one of these...

If you explain what you want to do, we might have other ideas as well.

I'm sure he will. They don't call Grant "The Scary DBA" for nothing!

Clustering is expensive and it will handle the automatic failover, though it can be 10-60 seconds to move.

Mirroring is the best solution, but you have to be using the SNAC...