Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 current database

Author  Topic 

amarpowar
Starting Member

2 Posts

Posted - 2005-08-12 : 05:41:00

how to find out current database name?
i am writing store proc where i want to know the current database name
how to get it , there is no function in sql server like current_user

pl help

with regards
aamar powar


madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-12 : 05:45:48

select db_name()


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -