Sp_ExecuteSQL headache

Question

Sp_ExecuteSQL headache

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

steve-893342 SSCarpal Tunnel Points: 4439 More actions · Answer 1

You will need to put square brackets around your index and table names

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

Ness (8/26/2010)
...Execute Sp_executeSql stmt does not run the sql. The printed version looks right but it does not run against the db (verified via profiler). Any ideas?
...

What it returns to you? Error?

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

BTW, I've tried your script - it works for me.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Ness SSCarpal Tunnel Points: 4282 More actions · Answer 4

Many thanks for your responses - I am not in the office for a while but I will check as soon as I return.

SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk