cross database chaining

From: Warren (wsze@advent.com)
Date: 04/08/03 

From: "Warren" <wsze@advent.com>
Date: Tue, 8 Apr 2003 14:55:02 -0700

Don't know if this is the right area to post.

Running. SQL Server 2000 SP 3

Currently running into a problem where we have some
databases that need to share data with each other. We
have a stored procedure on one database that performs at
JOIN on a table in another database.

We receive a SELECT permission denied when running that
stored procedure. Only one out of the 5 databases have
this problem. We have checked the 'Allow Cross database'
linking box on all of the databases, but still have this
problem. This has been happening whenever we run into an
error during setup of the databases that we subsequently
fix. Short of recreating all of the databases from
scratch (not feasible in production), is there anything
else that can be done?

Thank you,

Warren

Relevant Pages

  • How to query two SQL Server instances
    ... I need to run a stored procedure, or make it simpler, to run a query to ... access the databases from two machines location at different locations. ... On client's machine A, say in city A, have installed SQL Server, another ... the databases in head office? ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedure
    ... the stored procedure. ... to use in ISAM databases (yes... ... fields are not used in SQL Server except in rare situations. ... > @Param3 money, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Same transaction on 2 different DB
    ... databases. ... Pro SQL Server 2000 Database Design - ... > tran, select insert and update some table from both the DB, this ... > has effects on both DB or only in the DB in which the stored procedure is? ...
    (microsoft.public.sqlserver.programming)
  • Covering index causes blocking on exclusive latch acquisition in tempdb?
    ... We have around two dozen databases with the same schema. ... The stored procedure definition is below as well. ... that introducing non-clustered covering indexes on each of these tables ... The queries were even accessing different databases in the blocking chain, ...
    (microsoft.public.sqlserver.programming)
  • Permissions on stored procedures & tables
    ... At one client site, the DB server has 2 databases, that of my application ... I thought having the right to execute the stored procedure, ... explicit rights to the tables from which it selects. ... Senior Software Solutions Developer ...
    (microsoft.public.sqlserver.security)