On Thu, 02 Oct 2008 10:44:09 -0400, ventalinks@xxxxxxxxxxxxxx wrote:
I need to write a stored procedure that has two different user
connections to two different databases. Both db's are on the same one
server. Is this possible to create using Transact-SQL commands in a
stored procedure?
A stored procedure runs on one connection, but it can reference
multiple databases on the same instance of SQL Server. If you
describe what you actually need to do someone may be able to suggest
an approach.
Re: Continue SP after Database Access Failure ... Error handling in SQL Server 2000 is "somewhat" problematic as you have ... I use the following trick of nesting the execution scopes:... > Over night we take a copy of various live SQL databases onto another SQL ... > I have a stored procedure that compares the latest live data against the 1 ... (microsoft.public.sqlserver.programming)
Continue SP after Database Access Failure ... Over night we take a copy of various live SQL databases onto another SQL ...server for reporting purposes. ... of the live databases is offline the stored procedure has an error and stops. ... (microsoft.public.sqlserver.programming)
Re: Overhead of Multiple SQL Calls ...connections that aren't in use, can use up a lot of resources on SQL Server ... It probably depends on how they're using the server...... > a) A Stored Procedure is called ten times, ... > Due to connection pooling I would think the overhead is somewhat ... (microsoft.public.sqlserver.server)
RE: Q: Named pipes and Windows (integrated) authentication ...Trusted Connections or Windows Authentication is when the client uses ... A user needs first to be able to authenticate to the server either using: ... Creating databases is only acomplished after you've already connected. ... (microsoft.public.sqlserver.connect)
Unable to log into the database ... I am trying to connect to a database on a server on our network. ... two databases one is Interbase, ... I can open the connections in the server explorer connect ... (microsoft.public.vb.database)
