- 论坛徽章:
- 0
|
IF EXISTS (select * from syscomments where (status = 0 or status is null) and id = object_id('dbo.Spt_zx'))
BEGIN
DROP PROCEDURE dbo.Spt_zx
IF OBJECT_ID('dbo.Spt_zx') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dbo.Spt_zx >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dbo.Spt_zx >>>'
END
go
-- PROCEDURE 'dbo.Spt_zx' is encrypted
go
IF OBJECT_ID('dbo.Spt_zx') IS NOT NULL
PRINT '<<< CREATED PROCEDURE dbo.Spt_zx >>>'
ELSE
PRINT '<<< FAILED CREATING PROCEDURE dbo.Spt_zx >>>'
go
EXEC sp_procxmode 'dbo.Spt_zx','unchained'
go
GRANT EXECUTE ON dbo.Spt_zx TO public
go
REVOKE EXECUTE ON dbo.Spt_zx FROM syother
go |
|