skrontz
Computer
- Mar 5, 2002
- 1
I recently restored a SQL 7 db (an SMS db). Everything appears to function correctly in Query Analyzer and Enterprise Manager. However, when I try to view a collection in SMS 2.0, I get the following SQL error:
Description: SQL Err>> #208 Sev 16: Invalid object name 'vCollectToSubCollect'. NEXT: SQL Err>> #10007 Sev 5: General SQL Server error: Check messages from the SQL Server. (null)
Error : WBEM_E_FAILED
Operation: ExecQuery
ParameterInfo: select coll.* from SMS_Collection as coll join SMS_CollectToSubCollect as assoc on coll.CollectionID=assoc.subCollectionID where assoc.parentCollectionID="COLLROOT"
There is nothing in the SQL error log. Any suggestions?
Description: SQL Err>> #208 Sev 16: Invalid object name 'vCollectToSubCollect'. NEXT: SQL Err>> #10007 Sev 5: General SQL Server error: Check messages from the SQL Server. (null)
Error : WBEM_E_FAILED
Operation: ExecQuery
ParameterInfo: select coll.* from SMS_Collection as coll join SMS_CollectToSubCollect as assoc on coll.CollectionID=assoc.subCollectionID where assoc.parentCollectionID="COLLROOT"
There is nothing in the SQL error log. Any suggestions?