阅读背景:

是否有T-SQL命令检查同义词所引用的对象是否存在且有效?

来源:互联网 

I'm trying to test if all synonyms on a database refer to valid objects, using the SQL batch script below, as part of a clean-up effort on our databases. This script just performs a query against the synonym, and printing out any errors it encounters. This works fine on views and tables, but not on sprocs. I'm trying to test if all synonyms on a databas




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: