Database ID 2

[mikemcginty]

How do I retrieve the ID of the SQL database I am currently connected to?

I want to use sysprocesses to find out who is connected to the database but need to filter out user_names which are connected to other databases.

Regards

Mike

When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!

 

[hmckillop]

If you know the name of the database you specify it using the below call, but if you leave the parameter blank it defaults to the current DB

SELECT DB_ID('')

"I'm living so far beyond my income that we may almost be said to be living apart

 

[donutman]

Hmckillop, how in the world do you remember things like that? Is there a master list of those functions and/or switches that can be set?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[hmckillop]

Just had to use it before and knew it was db_ something so looked in books online.

BTW congrats on being new tipmaster!

"I'm living so far beyond my income that we may almost be said to be living apart

 

[donutman]

Thanks.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]