Ben,

I think you've misunderstood me.

I agree that running the above query against INFORMATION_SCHEMA.TABLES is likely to suffer performance, because INFORMATION_SCHEMA.TABLES returns only user-defined objects so that

where OBJECTPROPERTY(OBJECT_ID(Table_Name), N'IsTable') =...

What about utilizing the *.PROPERTY stuff?

Hey, yesterday evening there was an empty message!

Well, after your editing, I must review my answer to NO. This can't be turned off.

The alternative (IMHO also the better one)...

Umpf... too quick.

Here's another one by Randy Dyess

http://www.transactsql.com/Articles/temptabl.html

Interesting is also the link list he provided

Hard to tell without seeing the code and knowing your environment.

Have you tried

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=100&messageid=19589

I'd say that it is not unlikely, that Joseph himself will respond.

http://www.google.com/search?hl=de&ie=ISO-8859-1&domains=www.sqlservercentral.com&q=decrypt&sitesearch=www.sqlservercentral.com

http://www.sqlservercentral.com/columnists/jgama/

Please avoid cross post!

As this is more security related, we should continue there

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=99000

Not a direct answer to your question, but maybe it helps anyway.  This is an answer from Paul Randal DBCC Technical Lead, Microsoft SQL...

Best bet is to use a third party app like Lumigent Log Explorer.

If you want to do this on your own, you can use the undocumented DBCC LOG('your_db_name',-1) command.

Please post...

As I doubt you'll find a book especially on subquery, I would have a look at

• The Guru's Guide to Transact SQL by Ken Henderson
• Advanced T-SQL by Tom Moreau, Itzak Ben...

As long as the amount of data you store is less than 32 kb, the text root structure will take 84 bytes. Not sure what happens when no value is...

The answer is YES!

EM uses something called 'firehose' cursor, IIRC.

The term "firehose" reflects the way that the server blasts rows to the...

Hi Andrew,

look at projects -> references or components. There you should find  Microsoft Internet Controls and/or Microsoft Internet Transfer Controls. I don't know how to use them, but I'm sure...

Sorry, no harm meant!

More of a little after work joking, as here in my place it is already 9 PM.