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

Stoker, Kenneth E Kenneth.Stoker at pnl.gov
Fri Feb 13 17:04:43 CST 2004


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 



More information about the dba-SQLServer mailing list