Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  SQLDMO.QueryResults

Author  Topic  mrkensr Starting Member 9 Posts Posted - 2009-03-03 : 14:34:06 Dim sql As New SQLDMO.SQLServer2 Dim db As New SQLDMO.Database2 Dim objstor As SQLDMO.StoredProcedure2 Dim objdependents As SQLDMO.QueryResults For Each db In sql.Databases For Each objstor In db.StoredProcedures If objstor.SystemObject = False Then objdependents = objstor.EnumDependencies(SQLDMODep_Parents) End If Next ' for each objstor Next ' database In the above code snippet I keep get RunTime 91 Error Object Variable not set on the EnumDependencies call What Am I missing? Thanks in advance