[dba-SQLServer] Line Numbers

For what it is worth, I know that in Management Studio I can never really rely on the error message to 'point' to the correct line of code, it is usually the one below the 'line' I'm given in the message.
Nancy Lytle N_Lytle at terpalum.umd.edu



 EMAILING FOR THE GREATER GOODJoin me

> Date: Wed, 17 Sep 2008 15:42:22 -0300> From: fuller.artful at gmail.com> To: dba-sqlserver at databaseadvisors.com> Subject: [dba-SQLServer] Line Numbers> > 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> _______________________________________________> dba-SQLServer mailing list> dba-SQLServer at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> http://www.databaseadvisors.com>