>>>WTF?
>>>I know I changed Database context, I CHANGED IT!!!
>>>Is there a way to suspend such a message.
>>>
>>>:-)
>>>But that raise error in my SPT commands with this message.
>>>I tried SET ANSI_WARNING OFF w/o any luck.
>>
>>Found this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1705709&SiteID=1, not sure if helpful.
>
>Know what.
>I read that message today AND I didn't saw anything useful.
>NOW I read it again AND voila - SQLCMDERRORLEVEL (maybe the beer says its words:-))
>Yes, that is for SQLCMD, but who knows MAYBE SQLSETPROP(,"DispWarnings", .f.) could help?
>Thank you Naomi. I'll try it first thing in monday.
Good luck!
BTW, the funny thing - yesterday I was using IF EXISTS option for scripting. And even if I changed something in the string and executed, it didn't seem to remember (unless I was too stupid and pressed wrong button - happened to me as well).
Today I switched to disable that option and finally got my SP working and the person inserted.
Now I need just one little thing to fix, hopefully Paul is here already...
If it's not broken, fix it until it is.
My Blog