Woo-hoo!!!

You are welcome, and glad things are working for you.

Steve

Lynn Pettis (7/3/2012)

---

Steve, I apologize for my latest rant to Mr Celko. I have tried to restrain myself since you asked me to, but I just had to respond...

Job history isn't detailed logging. You can enable logging inside the package to a text file.

Except that if you are space bound, you can move new data to the new file this way. And if space is your issue, not performance, this can work.

Depending on...

One benefit of the clustering on a VM is hardware abstraction. This can be handy for DR, and also for not worrying about HCL parts on the list. If you...

Elliott Whitlow (7/3/2012)

---

Yes, I use sprocs, but you pass in a value that is then hashed and then the hashed value is used to select the right key. So...

I don't think it's possible. Usually a sproc has a known result set, even for a report, so you would have the values being returned.

You cannot have two default instances. You cannot have two different versions alternating as the same instance.

Your post doesn't explain which is a default instance and which is a named...

That's great, Elliot. Extra keys. Hadn't thought about that. Do you use procs then for encryption/decryption? If so, doesn't that defeat the purpose of the extra keys?

I think this will work fine, just be sure that you have all the log backups with the copy only backup. The one thing I'd be worried about is the...

Don't think so. The first error is an I/O subsystem error, surfaced when the I/O system doesn't respond correctly.

The backup error would surface differently as a failure to read from...

Or enable detailed logging.

You can't change a default instance to a named instance. You can install another instance and transfer your databases, logins, linked servers, etc. to the new instance.

Why does the table have to be created on the fly? You know the output of the proc already, so create the temp table using that basis.

If you say you...