Search This Blog

Saturday, February 21, 2009

To Which Database Does The Object Belong

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: