That was fun. Thanks.

Thanks to both of you.

Long ago I started using COUNT(0). It always works for me. As someone else pointed out if I want a distinct list of some field then I'll do COUNT(distinct columnname).

I guess too.

Checked out the datasheet. It looks pretty good. I like the idea of always on encryption without a major rewrite of our apps. This will help us with our HIPAA...

Thanks for the script.

Some of it made sense but some I'm going to have to do some research on. Thanks for the opportunity to learn something today.

Very good question, thanks.

I've never heard that term before. But I try to always create my deployment scripts so that they can be rerun over and over. In fact I put the text...

Thanks for the script. I'll give it a try.

I use cursors once in a while. Thanks for the retraining to make sure I use the proper options.

Nice script, thanks.

Had a lot of fun with this one. We found one particular table we are now going to trim out the old history.

Nice little script. Thank you.

We do this so the script will be helpful. Thanks.