SQL Help

[TerryMcFall]

Help - attempting to refresh our test servers for the first time and running into SQL issues. The database restored without problems from a production backup and now I'm attempting to update the Repository Table.

Page 3-20 of Rehost Guide says run this command:

Update Repository set lastKnownDomain='(our target server)' where local=1;

But the response I get is "Invalid object name 'Respository'."

I've opened a call w/PTC but they are not well known for SQL resources... are there some basic troubleshooting commands I can run?

Thanks in advance.

-Ter

Terrence McFall
CAD Systems Administrator

Varian Medical Systems
911 Hansen Way
Palo Alto, CA 94304
650-424-6039 desk
650-799-0179 cell

[TerryMcFall]

Double-checked "Repository" misspelling and it was correct on the actual command.

Thanks Joe for catching that.

-Ter

[TerryMcFall]

Issue was resolved by logging into SQL Mgt Studio using admin acct from SQL Server Authentication instead of Windows Active Directory.

-Ter