January 17, 2010 at 4:48 pm
I am getting error when execting the query
SELECT NAME FROM [OBEAVER].master..sysdatabases
Error:
Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "OBEAVER".
When query this..
SELECT NAME FROM [OBEAVER].master..dbo.sysdatabases
Error:
Msg 117, Level 15, State 1, Line 1
The object name OBEAVER.master..dbo.sysdatabases' contains more than the maximum number of prefixes. The maximum is 3.
I am runing above queries from SQL 2005 to SQL 2000.
January 17, 2010 at 7:27 pm
Try removing the double dot...
OBEAVER.master<one les dot in here>.dbo.sysdatabases'
January 18, 2010 at 3:56 am
This is a problem with SQL 2000 SP upgrade. What SP are you using on the SQL2000 server. To fixe run the following scripts Instcat.sql on the 2000 server. For more information you can search google for the script name and you would find a whole lot of articles on this.
If you have another solution please let me know.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
January 19, 2010 at 4:32 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply