InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 03:10:13 GMT20http://www.sqlservercentral.com/Forums/Topic686821-146-1.aspxHi Grant,thanks for the remark. just like Adi suggested worked for me.bryanTue, 31 Mar 2009 05:46:30 GMTbryan van ritterhttp://www.sqlservercentral.com/Forums/Topic686821-146-1.aspxHi Adi,thanks for your reply, just what i was looking for. thanks again.bryanTue, 31 Mar 2009 05:45:46 GMTbryan van ritterhttp://www.sqlservercentral.com/Forums/Topic686821-146-1.aspxAs the last post showed, @@ServerName gets you the name of the server, DB_NAME() gets you the current database. If you pass it a database ID, it will get any other database name.Tue, 31 Mar 2009 04:59:04 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic686821-146-1.aspxIt isn’t very clear what you want to do. Do you want to get a list of databases in the instance? If this is what you want you can use this query:[code]select @@servername, name from master.sys.databases[/code] If you want something else, pleas specify.AdiTue, 31 Mar 2009 04:08:41 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic686821-146-1.aspxhello,i'am trying to create a query which gives me back the database name and the instancename of that particular database and put all of this in a table. can someone help me with this issue.kind regard,bryanTue, 31 Mar 2009 03:52:36 GMTbryan van ritter