Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
8022421
Starting Member
45 Posts |
 Posted - 2011-01-21 : 07:25:22
|
| We are migrating Sybase to SQL server,In sysprocess table in Sybase they getting tge Line number which is defined as below. LineNum in sybase is defined as -> The line number of the current statement within the running stored procedure (or the line number of the current SQL batch statement if no procedure is running). Is there any equivalent in SQL server 2008 for the same.Please do help me in this.Thanks |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-21 : 07:31:35
|
This sounds similar to a log file which I have seen in SAS programs or mainframe. There are ways to identify which processes are running, and/or which statement in a batch is running in SQL using various DMV's, or SQL profiler...that is, you can see the exact SQL statement being passed. Processes (SPID) can be identified and related information can be pulled from SQL related to those SPIDS.If you can be more specific about what you need to do, we can probably point you in the right direction.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Linenum Column in SQL Server 2008 using Syscomands