Posted by rsstonejr on 11/25/42 11:59

Hello.

Has anybody ever called a stored proc on a SQL Server 2005 database
from a SQL Server 2000 database? Is it even possible?

I'm using the following command:

sql2005server.sql2005database.dbo.sp_executesql sp_storedproc

from Query Analyzer on 2000 and I'm getting the following error
message:

Server: Msg 916, Level 14, State 1, Line 1
The server principal "DbLink" is not able to access the database
"test_rpp" under the current security context.

Thanks in advance,
Stoney

• Next in forum: Re: Subquery doesnt work!!!!!!!!!!!
• Prev in forum: how to change default data directory for SQL 2005
• Thread view: call stored proc on sql 2005 from 2000

[Reply to this message]