Re: Extended Stored Procedure: Get the current db of the client
- From: "Mike C#" <xxx@xxxxxxx>
- Date: Thu, 11 May 2006 21:30:06 -0400
Works for SP's, might work with XP's as well:
1. Prefix the name with "sp_"
2. Mark it as a system object with sp_MS_MarkSystemObject
This causes the SP to run under the context of the database it was called
from, not the master database where it resides. At the least, you can put
an SP wrapper in the master DB for the XP, and pass in the db_name() as a
parameter to the XP and it will have the correct database context (not
"master").
"Gert E.R. Drapers" <GertD@SQLDev@Net> wrote in message
news:%23ZtUJnzcGHA.3632@xxxxxxxxxxxxxxxxxxxxxxx
This never worked correctly, this is not way you can get the database
context from within an XP, easiest work around is to use a wrapper SP that
passes the db_name() or db_id() as a parameter.
In general using wrapper SP's is a good practice for doing parameter
validation, and meta data exposure since XP's do not emit the parameter
signatures.
GertD@xxxxxxxxxx
"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:feuv521gpm893g6hfi4aja0vpp8vguiun4@xxxxxxxxxx
What version of SQL Server?
It's a limitation of extended stored procedure programming
with SQL Server 2000. Some have tried using svr_rpcdb but it
will generally just return master as the database name. And
it's no longer supported.
-Sue
On Mon, 8 May 2006 14:41:59 +0200, "Hans Stoessel"
<hstoessel.list@xxxxxxxxxxxx> wrote:
Hi
Is there a way to get the current database of the client who calls my
Extended Stored Procedure?
I have written a DLL in Visual Studion 2005 for the SQL server 2003 in
C/C++
using the functions srv_*.
Thanks.
Hans
.
- Follow-Ups:
- Re: Extended Stored Procedure: Get the current db of the client
- From: Gert E.R. Drapers
- Re: Extended Stored Procedure: Get the current db of the client
- References:
- Extended Stored Procedure: Get the current db of the client
- From: Hans Stoessel
- Re: Extended Stored Procedure: Get the current db of the client
- From: Sue Hoegemeier
- Re: Extended Stored Procedure: Get the current db of the client
- From: Gert E.R. Drapers
- Extended Stored Procedure: Get the current db of the client
- Prev by Date: Re: Extended Stored Procedure: Get the current db of the client
- Next by Date: Re: Change servername based on logon server
- Previous by thread: Re: Extended Stored Procedure: Get the current db of the client
- Next by thread: Re: Extended Stored Procedure: Get the current db of the client
- Index(es):
Relevant Pages
|
