I know most of this is possible today, but it's not easily integrated. Nor does it work with most phones or cars. Yet I think it's an easy one.

To me,...

There are some third party product, Protegrity, Netlib, application secrurity, etc. Use the site search as we have a few reviews posted.

Even this: http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp

Be careful when you do this and...

You can use create a table and then run a "dir" or some other mechanism to get a list of files and load into the table. you'd need to then...

Pls don't cross post.

You can

Merry Christmas and enjoy the holiday!

I usually put the update and select inside the transaction.

Am I the only one with kids here? I thought I'd be low man on the totem pole with this one!

I tend to agree that I rarely decorated anything until...

Except someone else will be in charge of it and they'll be bugging you for CPU counts, which is in which class, what the multipliers are, etc.

Plus it's not...

Bill,

no idea, but I pinged Brian Kelley. He's probably got an answer for this.

If someone activates the role, then they are treated the same. I believe you'd need to disconnect and reconnect to change this.

If someone does steal the pwd, then they could...

Backups: Native SQL works great and is bulletproof. If you have lots of data, however, then you might want to look at Red Gate, Quest, Idera for a compression utility

Log...

You could probably backtrack using a log reader (Apex, Lumignt, LogPI), but not sure it would be an easy answer. Might need to run reports from their products and then...

You cannot assign a rowset to a variable. They are different structures internally and it won't work. I believe that you are assigning the return value from sp_executesql to your...

Perhaps the UDF call takes precendence over the funciton call, so it's not a datetime when it's passed ?

Not sure