To find a SQL Server object, such as a user table, query the
sysobjects system table in the local database.
If the database name is unknown, use the following query:
Exec sp_MSforeachdb
'Select * From ?..sysobjects where name like 'objectname'''
The
? in the query is replaced with the database names, internally—or for example, you could do this for a table
license:
Exec sp_MSforeachdb
'if exists(select * from ?..sysobjects where name =
''license'') select * from ?..sysobjects where name = ''license'' '
This will return all the information in that table.
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
