Database ID

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mike2265 Right there with Babe Points: 753 More actions · Answer 1

this'll work

select dbid from master.dbo.sysdatabases

where name = db_name()

Not sure if there's an sp that does the same

cheers,

Mike

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 2

SELECT db_id('pubs')

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Mike2265 Right there with Babe Points: 753 More actions · Answer 3

doh - I should've found that given it's next to db_name in the help index.

Incidently - If you leave out the name it'll return the current database id.

cheers,

Mike