Re: DatabaseName Database ID Map?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 02/25/05


Date: Fri, 25 Feb 2005 17:32:47 -0500

SELECT DB_NAME(<dbid>)

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
<jpuopolo@mvisiontechnology.com> wrote in message
news:1109369484.318741.212180@o13g2000cwo.googlegroups.com...
> Hi...
>
> In SQL Profiler, it is easy enough to the the database ID from a trace.
>  That said, it would be nice to know what database the ID number
> represents.  How can I map the database ID to it's human-friendly name?
>
> Thanks,
> John
>


Relevant Pages

  • RE: Weird table rights issue
    ... The first thing I would do is setup a trace against that database using SQL profiler. ...
    (microsoft.public.sqlserver.security)
  • Removing blank rows
    ... every other row of a worksheet ... I've got the reverse issue. ... A database created from a text input has a blank row from the original ... This is for someone wanting a semiconductor data list that can ...
    (microsoft.public.excel)
  • Re: Is this a tcpwrapper bug?
    ... DNS database as the same IP. ... how about the reverse database? ... iptables rules are only interested in IP addresses...DNS can be faked ...
    (Fedora)
  • Re: Importing an Analysis Services 2005 Database
    ... when you do a "reverse" eng. the solution save an ID which is the last time ... This behavior appears if the server version is newer then the VS Solution ... eng. simply edit the cube online. ... Analysis Services 9.0 Database". ...
    (microsoft.public.sqlserver.olap)
  • Re: Connection string in javascript
    ... not reverse them: ... connecting. ... database from javascript but it just will not play. ... missing that I've not had to do before, because connection strings work from ...
    (microsoft.public.sqlserver.programming)