current database name needed...

[David]

Hi:

I need to know the current database name in executing a stored procedure,
which will trancatte the log of that database.
(in a dynamic multiple customerID oriented database environment,
ex. custID_101_db, custID_102_db, .....)

[Steve Rodgers]

David,

You need to use DB_NAME(), this will return you the current database name.

Cheers,



------------
David at 4/10/2002 8:17:39 PM

Hi:

I need to know the current database name in executing a stored procedure,
which will trancatte the log of that database.
(in a dynamic multiple customerID oriented database environment,
ex. custID_101_db, custID_102_db, .....)