Thursday, October 3, 2013

get schema of sp

select OBJECT_SCHEMA_NAME([object_id]),OBJECT_NAME(object_id)  from sys.sql_modules

No comments:

Post a Comment