>I cannot reproduce what you seeing. I tried the following on SQL Server 2000 SP1:
>
>use pubs
>select object_id('authors')
>select name from sysobjects where id = object_id('authors')
>
>use northwind
>select object_id('pubs..authors')
>select name from pubs..sysobjects where id = object_id('pubs..authors')
>
>-Mike
Mike,
your code works. However, try this one, if you please:
-------------------------------------------
USE pubs
SELECT *
FROM sysobjects
WHERE OBJECTPROPERTY(ID, N'IsUserTable') = 1
USE northwind
SELECT *
FROM pubs..sysobjects
WHERE OBJECTPROPERTY(ID, N'IsUserTable') = 1
-------------------------------------------
I get two different sets of data.
Aristotle