Yukon-Katmai Discussion
Search This Blog
Tuesday, October 14, 2008
To wihch database does the object belongs
You know the object name but you do not know to which database does it belongs :) ..
Try msforeacdb
:
sp_msforeachdb 'use ?;print "?";select name from sys.sysobjects where name=''
'''
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment