how to serch for an object in a server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to serch for an object in a server

Hi Any table in master DB store info ,about all object in the database. eg:Can i query master DB to find if a procedure pro1 exist in the server ? i believe it is not possible. Rajiv
SQL-DBA
use YourDatabase select * from sysobjects where name = ‘your_sp’ Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
is it possible anywy queryin Master DB ? Rajiv
SQL-DBA
http://www.sql-server-performance.com/ak_find_sql_server_database_objects.asp for your joy. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
again you. thanks Rajiv
SQL-DBA
]]>