Checking object references and permissions in stored procedure 1

[SamGarland]

Hi all.

Does anyone know an <<easy>> way to check that at a given point in time, object references in a stored procedure can be resolved and are accessible without actually executing the stored procedure?

Sam

 

[JamesLean]

You can use the SET SHOWPLAN_TEXT statement. This is used to display the execution plan without actually executing the statement(s). If your SP references objects that don't exist, or objects that the user doesn't have permissions on, then an error will be returned.

create proc test
as

select * from NonExistentTable
go

set showplan_text on
go
exec test
go
set showplan_text off
go

--James

 

[SamGarland]

That's what I was looking for,
Thanks