Thanks for the article. I use WITH EXECUTE AS quite a bit in our environment but gained an appreciation for using it to secure encrypted resources.

I do have...

This might help you.

http://technet.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx

Are these statblobs created with CREATE STATISTICS recommendations from the DTA auto updated like index statistics?

Out of personal curiosity, would the PIVOT command, available in SQL 2005 onwards, be of help in this situation?

http://technet.microsoft.com/en-us/library/ms177410%28v=SQL.105%29.aspx

Andre Ranieri

Thanks for the link.

As I think about this, using OPTION (RECOMPILE) on the statement makes a lot of sense. You've got me thinking that this is perhaps not...

The object is using the deprecated Text datatype, and reading the string directly from the database shows a text header like ÿØÿá6ªExif, which looks a lot like the EXIF headers...

Thanks for the pointers! I will try these both tonight.

Attempting to do this in CLR or .NET shouldn't be too difficult.

This is my first attempt to...

I kept looking for the trick question here.

Since statement #4 either works OR it doesn't, a false answer would be impossible.

That's just my boolean mind at work.

Thanks for the question, and the nice use of CASE.

Andre Ranieri

+1, I'm rather curious about that restriction and didn't find anything enlightening in BOL, which states:

The WITH LOGIN clause enables the remapping of a user to a different login. Users...

Have you had any luck with this yet?

exec sp_addrolemember 'db_datareader',YourLogin should do the trick.

Andre Ranieri

+1 on the semi-colon being illegal after GO

Thanks Lokesh for the explanation.

Andre Ranieri

Thanks for the nice question!

Andre Ranieri

+1 - thanks for the question. I got it wrong (guessed) but learned something.

Cheers,

Andre Ranieri