Name of current db in proc

microsoft.public.sqlserver.programming

10 Sep 2005 12:28 PM

Soeren S. Joergensen

Hi,

What's the best way to get the name of the current db (not filename, but db
name) from inside a sp ??

I'm writing a general sp that has to be put into numerous db's, except one

Kr.
Soren

10 Sep 2005 1:02 PM

Soeren S. Joergensen

Hi,

DB_NAME() must be the way to go :)

Soren

Show quote

"Soeren S. Joergensen" <nospam@nodomain.com> skrev i en meddelelse
news:eska3MgtFHA.2328@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> What's the best way to get the name of the current db (not filename, but
> db name) from inside a sp ??
>
> I'm writing a general sp that has to be put into numerous db's, except one
>
>
> Kr.
> Soren
>