how do i get the sp_helprotect resluts in a query

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

how do i get the sp_helprotect resluts in a query

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-02-24 : 16:04:55

something like this:
select * from sp_helprotect
but that gives me an error
Thanks

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-02-24 : 16:19:54

[code]

create table #HelpProtect(
[Owner] [sysname] NULL ,
[Object] [sysname] NULL ,
[Grantee] [sysname] NULL ,
[Grantor] [sysname] NULL ,
[ProtectType] [char] (20) NULL ,
[Action] [varchar] (20) NULL ,
[Column] [sysname] NULL )

insert into #HelpProtect exec sp_helprotect

select * from #HelpProtect

drop table #HelpProtect

[/code]

CODO ERGO SUM

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-02-25 : 09:53:16

Thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources