How to find table name by Table ID

waitresource
--
TAB: 12:600441263 []
I had blocking issue. I query sysproceses table and it shows me process are
waiting for "waitresource=TAB: 12:600441263 []"
TAB table
12 -- it is DB id...it is not problem to find dbname...sysdatabases
600441263 - table ID
How to find table name from Table ID '
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200608/1Switch to the proper DB and do:
SELECT OBJECT_NAME(600441263 )
RLF
"jkostic via droptable.com" <u11642@.uwe> wrote in message
news:64cf78c5f56a6@.uwe...
> waitresource
> --
> TAB: 12:600441263 []
> I had blocking issue. I query sysproceses table and it shows me process
> are
> waiting for "waitresource=TAB: 12:600441263 []"
> TAB table
> 12 -- it is DB id...it is not problem to find dbname...sysdatabases
> 600441263 - table ID
> How to find table name from Table ID '
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200608/1
>|||OBJECT_NAME() function will give you the table/any object name when you pass
the id.
in your case
Select OBJECT_NAME(600441263 )
will give you the table name.
There are otherways to do it.
Here is one more by using the system table
select name from sysobjects where id = 600441263
you have to run this comments on the particular database i.e the database id
12 you mentioned.
regards,
Saravanan
"jkostic via droptable.com" <u11642@.uwe> wrote in message
news:64cf78c5f56a6@.uwe...
> waitresource
> --
> TAB: 12:600441263 []
> I had blocking issue. I query sysproceses table and it shows me process
> are
> waiting for "waitresource=TAB: 12:600441263 []"
> TAB table
> 12 -- it is DB id...it is not problem to find dbname...sysdatabases
> 600441263 - table ID
> How to find table name from Table ID '
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200608/1
>

How to find table name by Table ID

waitresource
--
TAB: 12:600441263 []
I had blocking issue. I query sysproceses table and it shows me process are
waiting for "waitresource=TAB: 12:600441263 []"
TAB table
12 -- it is DB id...it is not problem to find dbname...sysdatabases
600441263 - table ID
How to find table name from Table ID '
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1Switch to the proper DB and do:
SELECT OBJECT_NAME(600441263 )
RLF
"jkostic via SQLMonster.com" <u11642@.uwe> wrote in message
news:64cf78c5f56a6@.uwe...
> waitresource
> --
> TAB: 12:600441263 []
> I had blocking issue. I query sysproceses table and it shows me process
> are
> waiting for "waitresource=TAB: 12:600441263 []"
> TAB table
> 12 -- it is DB id...it is not problem to find dbname...sysdatabases
> 600441263 - table ID
> How to find table name from Table ID '
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1
>|||OBJECT_NAME() function will give you the table/any object name when you pass
the id.
in your case
Select OBJECT_NAME(600441263 )
will give you the table name.
There are otherways to do it.
Here is one more by using the system table
select name from sysobjects where id = 600441263
you have to run this comments on the particular database i.e the database id
12 you mentioned.
regards,
Saravanan
"jkostic via SQLMonster.com" <u11642@.uwe> wrote in message
news:64cf78c5f56a6@.uwe...
> waitresource
> --
> TAB: 12:600441263 []
> I had blocking issue. I query sysproceses table and it shows me process
> are
> waiting for "waitresource=TAB: 12:600441263 []"
> TAB table
> 12 -- it is DB id...it is not problem to find dbname...sysdatabases
> 600441263 - table ID
> How to find table name from Table ID '
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1
>