Finding out if an object esists using SQL Server SMO

[Patrick Hill]

Is there a way using SMO to find out if an object exists?

I want to find out if this sp exists on the server

[dbo].[spGetActiveEmps]

I know I would have to use something like:

theserver.Databases.Item(DBName).StoredProcedures. Item([dbo].[spGetActiveEmps])

[=?Utf-8?B?SmFrb2IgQ2hyaXN0ZW5zZW4=?=]

theserver.Databases("DBName").StoredProcedures.Con tains("spGetActiveEmps")

HTH, Jakob.

--
http://www.dotninjas.dk

"Patrick Hill" wrote:

>
Is there a way using SMO to find out if an object exists?

I want to find out if this sp exists on the server

[dbo].[spGetActiveEmps]

I know I would have to use something like:

theserver.Databases.Item(DBName).StoredProcedures. Item([dbo].[spGetActiveEmps])