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: