Look at the site of SQL Server MVP Erland Sommarkog at http://www.sommarskog.se. The articles there will tell almost everything you need to know about dynamic sql.

Thanks for that in depth explanation, Mike.

Hey, you're showing your age, when you know what a floppy is

Aah, so that is your understanding of being busy...

Aha, may I ask what the difference to the Best Practice Analyser is?

Hi Stefan,

http://www.sommarskog.se/error-handling-II.html

and

http://www.sommarskog.se/error-handling-I.html

might be worth reading.

If not already, get marreid and have children. So that way you don't have that much fun with your bike.

Enjoy your ride and...

Mike,

is there a specific reason why you state

"In the UK get ..." ?

Just curious, why not elsewhere.

I knew it couldn't have been the weather that let's you rather motorcycle than work

Uhoh, we're on a cheap way to increase post-count...

Please avoid cross posts, they make things hard to follow!

See my answer here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=128329

In any case look for a CYA strategy

Why are you still well below 1,000 posts?

Another popular mistake is to remove the sqldebugger-user from the domain which will result in

EXECUTE permission denied on object 'sp_sdidebug', database 'master'

error message.

To get around this you need to...

Another alternative would be to make the developers aware of the issues mentioned in the kb articles, write a nice protocol on this meeting and wait for their app to...

Try this one as a starter.

It's the most comprehensive discussion on BLOB's I've found so far. If there are any questions left after reading it, come back again.

Never heard of this before, so consider this only an educated guess.

I don't think you can use the usual DEFAULT on such a column. I guess you have to...

Hey, that's my usual link

Interestingly this article http://www.sommarskog.se/dyn-search.html on Erland's site gives additional information when to consider the use of dynamic sql and when...