Re: Extended Stored Procedure: Get the current db of the client

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


.

Relevant Pages

  • Re: Extended Stored Procedure: Loopback connection
    ... SQL Server ships a sample exactly showing this: ... SQLRETURN sret, ... SRV_PROC* srvproc); ... NULL, 0, 0, "Error executing extended stored procedure: ...
    (microsoft.public.sqlserver.odbc)
  • Re: Implementation of full text
    ... There is no documented way of accessing the MSSearch catalogs directly other ... tables in SQL Server to identify the row the hit occurs in. ... table to a client from an extended stored procedure. ... To use the recordset returned from the ESP as a virtual table>. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: sql server events on data create
    ... If I were to do this, I would set up the client to listen on a socket, write ... an extended stored procedure that can trigger this socket, ... triggers on the tables of interest to call this extended stored procedure, ... Or you could start a custom SQL Server trace event with the right filters? ...
    (microsoft.public.sqlserver.programming)
  • Re: There seems to be a memory leak in srv_paraminfo
    ... > no memory leak but the sqlservr.exe memory usage went up so i thought ... will i have to restart sql server 2000 now and then ... > w/ a sample extended stored procedure that comes on the SQL Server 2000 CD ...
    (microsoft.public.sqlserver.programming)
  • Retrieve error text from extended stored proc
    ... SQL Server 2000. ... I am calling an extended stored procedure that returns an error code (0 or ... On failure I would like to record the error ...
    (microsoft.public.sqlserver.programming)