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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2004-11-30 : 09:14:31
|
| Hi, I just ran this statement (Exec Sp_helprotect null,'UserID') to view Permissions and returns an error: "Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346 There are no matching rows on which to report". Why didn't sysprotects table have rows? Please let me know if any one has idea about this.Thanks,Rick |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-11-30 : 09:32:50
|
| That seems to be the response if it get's no rows. Are you sure that your "UserID" value is correct? I test with a correct one, and got a response, then an incorrect one, and got the same message as you.CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-11-30 : 10:12:02
|
| My mistake!!! I granted permissions to role. I was quering user. Thanks |
|
|
|
|
|
|
There are no matching rows on which to report