Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql error from restore

Status
Not open for further replies.
skrontz

skrontz

IS-IT--Management
Jan 24, 2001
18
US
I restored a SQL 7 db. I can view all of the tables and run queries in query analyzer, however, when I try to run my SMS collection, I get the following 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"

Any idea where to start troubleshooting?

Thanks in advance.

Sarah
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
357
Chriss Miller
C
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
935
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
525
Chris Miller
Chris Miller
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
579
bharons
bharons
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
753
Volvere
V

Part and Inventory Search

Sponsor

Back
Top