ansaurus

Question

Answer 1

+2 A:

You can obtain the database name using:

SELECT DB_NAME()

Do you get the DBName column running sp_who2 ?

Mitch Wheat 2010-01-23 06:13:29

No I dont Ge DBName Column running sp_who2 either. The Select DB_NAME() dosent work too. It returns a blank column.

SK9 2010-01-23 06:54:13

@SK9: sounds like it might be permissions related.

Mitch Wheat 2010-01-23 06:57:25

@SK9: what identity and role are in running under?

Mitch Wheat 2010-01-23 07:36:41

@SK9: SELECT DB_NAME() *has* to return a value. You always have a database context, even if it's master. Do you get any rows back from sp_who? Try SELECT @@SERVERNAME

gbn 2010-01-23 07:39:43

I dont think this is a problem with the Databse rights or permissons, coz when I connect to the sane Database using BDE alias all the above commands Work. It seems they only dont give any value, when i connect trough the ODBC Connection. Am i missing some settings in creating the ODBC connection.

SK9 2010-01-25 04:52:13

some how still when i use ODBC Sql server native client i dont get the DBname when i query sp_who. Infact i dont get the loginame field when i query the sys.sysprocesses. But I do get the DBID field which i used in this situation. This is a mere workaround to get my application up and running.

SK9 2010-01-26 06:55:21

ansaurus

tags:

views:

answers:

SP_Who does not return DBName Column

related questions