[dba-SQLServer]Determine which database a sproc is being called from

well, there's db_name() but that only gets the current database you are 
in...


>From: "Stoker, Kenneth E" <Kenneth.Stoker at pnl.gov>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]Determine which database a sproc is being called 
>from
>Date: Fri, 13 Feb 2004 15:04:43 -0800
>
>Is there a way for a sproc to determine which database it resides in
>when called?  I would like to make a sproc I am build generic enough so
>that it can be implemented in any database within a server instance.
>
>Thanks for any help.
>
>Ken Stoker
>Technology Commercialization
>Information Systems Administrator
>PH: (509) 375-3758
>FAX: (509) 375-6731
>E-mail:  Kenneth.Stoker at pnl.gov
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963