Thanks, Guys.

One of my coworkers found the issue by pulling the fields into a XML datatype variable. It was a hidden character with some bizarre value that...

And that might be true, but the OP might have meant something different too. So, I'd like to hear from him regarding what he's trying to accomplish to make...

Ed,

Let me guess. Readers were asking him how much the resource cost. @=)

I'm glad I started this thread. I've been enjoying everyone's quotes. @=)

You don't need to make the login owner of the database in order to view the database. Not unless you're wanting that user to be able to alter database...

Practice, practice, practice with SSMS. Explore the GUI and figure out how to do everything. Right click every menu item, examine every available option, test every possible thing...

John,

Have you checked your desktop for bits of wings, legs, antenna? Sounds like there's a 'bug' in the system to me. @=)

Configuration Manager sets encryption so you can use...

And if your System Admin try to request DB access, you need to point out to your boss the concept of "Separation of duties" and all those wonderful data breaches...

Wow, this is quite a thread.

Check the references section on the question and you'll see where I got the idea for it. I suppose I should have checked up...

Wow, guys, you've been a big help.

I have another table in which I keep triangulated totals (not the same as a triangular join). I have to basically add the...

David, I hate to break the news, but there are no drugs for what people like you & I have.

But they are working on a vacine to prevent future...

But check any confidentially agreements you might have signed on the previous job before you do...

You make a decent point, Andrew. And Admin accounts should always be heavily audited. We have S.A.M. on our servers which actually makes us enter reasons we logged...

Thanks, Matt. I appreciate the clarification.

Looks interesting. I'm going to have to test this one and see if it does any better or quicker than what I eventually...

DOH! Found my error. I had t2.CalMonth - 1 and should have had t2.CalMonth + 1.

I feel sooooo stupid.

Thanks, guys. I appreciate it. As far as...