Question
SQL Help
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
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