Looking for sproc location

• latingntlman

  SSCarpal Tunnel

  Points: 4348

  More actions

  September 29, 2008 at 12:31 pm

  #198670

  Is there a way to locate any stored proc in any Db within a server from SQL Server Management Studio?

  Or,

  Where or how would I find Shared Datasources within a server from SQL Server Management Studio?

  Is any of this possible?

  thx,

  john

• Chris_P

  SSCommitted

  Points: 1753

  More actions

  September 29, 2008 at 1:58 pm

  #878595

  As far as I can tell you can't search for objects from SSMS, but you could in Query Analyzer. (Press F4 when in QA to bring it up)

  However you can run a script like this:

  sp_msforeachdb @command1='select ''(?)'' as [dbname] , [name] as [ObjectFoundName]from sysobjects where [name] like ''sysfiles1'''

  just change sysfiles1 to the object you're searching for. This will search every database on the server and will work for any object.

  Hope that helps.

  Chris.

  Chris.