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 |
|
wendy
Starting Member
19 Posts |
 Posted - 2005-09-01 : 15:50:32
|
| Hi,I have been trying running the following at SQL 2000 server,EXEC sp_helprotect 'tables name' orEXEC sp_helprotect NULL, 'User name'Always get the error messages as below:“Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346There are no matching rows on which to report.”Does anyone have the ideas what may be the issues? ThanksWendy |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-09-01 : 17:07:53
|
| EXEC sp_helprotect 'tables name'I think it just means that no privs were explicitly granted to anyone on that TableEXEC sp_helprotect NULL, 'User name'and no privs were explicitly granted to that userIf that user is a member of a role that has been granted privs then try the role name instead of the user name.Be One with the OptimizerTG |
 |
|
|
|
|
|
sp_helprotect error