I'll give Oracle one thing. they seem to have found a way to convince management to pay more for DBAs on average!

Matt,

thanks for the note. I'll check that out.

Kambugu, if you have a question, please ask it in the appropriate forum, and state what you are looking for. Do not...

Thanks, Barry. It seems that schools here have started calling it President's Day, celebrating both Washington and Lincoln, but it's listed as Washington's Birthday in the federal calendar. 🙁

The holiday...

you might need to better define exactly what you need and for how many instances. that will help you determine things.

the quest tools work well, but for real time monitoring...

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.