Viewing 3 posts - 1 through 3 (of 3 total)
Check that.....
name id xtype uid user_name suser_name
-------- ----------- ----- ------ --------- ----------
table1...
October 1, 2009 at 10:20 am
#1060558
SELECT * FROM sysobjects WHERE [name] LIKE 'dbo%' returns no results
SELECT substring(name,1,8)as name,id,xtype,uid FROM sysobjects WHERE [name] LIKE 'table%'
returns:
name id ...
October 1, 2009 at 10:08 am
#1060551
The uid of the table in sysobjects does not exist in sysusers
October 1, 2009 at 8:58 am
#1060497