Can you send a server name to a stored procedure as a variable?

Article View: bit.databases.mssql-l

Article #85

Back to bit.databases.mssql-l Previous Next

#85

From: Dave A. Law
Date: Sun, 07 May 2000 00:00

6 lines
872 bytes

I was wondering if there was any want to dynamically connect to a MS
SQL Server 7.0 database in a stored procedure by sending the stored
procedure the server, database and such as variables.  If this is
possible, or not, please e-mail me at: dave.law@hedgehogsystems.com

Thanks.

Technical Details

Message-ID: <3915dc9e.804762@news.cadvision.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,2fa0d75d0d59ec7e,start
X-Google-Attributes: gidf6611,public
From: lawd@cadvision.com (Dave A. Law)
Subject: Can you send a server name to a stored procedure as a variable?
Date: 2000/05/07
Message-ID: <3915dc9e.804762@news.cadvision.com>
X-Deja-AN: 620155289
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 204.50.1.43
Content-Type: text/plain; charset=us-ascii
X-Trace: 6 May 2000 20:59:34 -0700, 207.148.143.101
Organization: DEGA Studios
MIME-Version: 1.0
Newsgroups: bit.databases.mssql-l