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 |
|
n0rr15
Starting Member
3 Posts |
 Posted - 2012-01-04 : 13:19:09
|
| can anyone help me with this? I cannot for the life of me find why this is erroring out...I assume it's a spacing issue?SQL 2005Use Masterselect spid, blocked, hostname, program_name, nt_username, cmd from sysprocesses where blocked = 0and spid in (select distinct blocked from sysprocesses where blocked <> 0 )I'm, pretty new to stretching my sql muscles but will be doing so a LOT in the future...below is the error..Msg 102, Level 15, State 1, Line 2Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 3Incorrect syntax near ' '.Rick Norris |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-04 : 13:22:41
|
| not sure error is in posted code as its compiling fine for me------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
n0rr15
Starting Member
3 Posts |
Posted - 2012-01-04 : 13:35:50
|
| Much appreciated... thanks alot I have it working fine nowRick Norris |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
msg 102, level 15