master..xp_cmdshell errors

Question

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

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

SwePeso SSC-Dedicated Points: 39758 More actions · Answer 1

Also asked here

N 56°04'39.16"
E 12°55'05.25"

smorty44 SSC Enthusiast Points: 104 More actions · Answer 2

Yes, and still not working properly, but thank you for research

smorty44 SSC Enthusiast Points: 104 More actions · Answer 3

It is working now for any of those that might run into this problem. I need to add + '''' to the end of the xp_cmdshell statement.

SwePeso SSC-Dedicated Points: 39758 More actions · Answer 4

That's why you always need to PRINT the statement when using dynamic sql.

Then you will see what is wrong.

N 56°04'39.16"
E 12°55'05.25"