Arthur Fuller
fuller.artful at gmail.com
Wed Sep 17 13:42:22 CDT 2008
Does the editor in Management Studio recognize logical or physical line numbers? Given this code... <sql> CREATE TABLE #TempCash_Consideration ( PPersonContactType_ID int , Currency_ID int , CashValue decimal(18,2) , CashValue_FXH decimal(18,2) , Withdrawals decimal(18,2) , Contributions decimal(18,2)) </sql> ... does the editor regard this as one logical line? The reason I'm asking is that I have an error trapping routine that reports the procedure name and line number, but the line reported doesn't make sense. It's an occasional problem with a deadlock, but the line reported to be the problem is the above, which doesn't make sense. The lines after this one do an INSERT | SELECT. Could that be the problem? Arthur