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
 SQL Server Development (2000)
 Database Name

Author  Topic 

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2006-11-29 : 06:56:08
How to know name of database from within the stored procedure?

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2006-11-29 : 07:02:37
Hi ,
try this
Select db_name()

Madhu
Go to Top of Page

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2006-11-29 : 07:32:09
perfect, many thanks.
quote:
Originally posted by hrishi_des

How to know name of database from within the stored procedure?

Go to Top of Page
   

- Advertisement -