Here's an obscure bug I ran into if anyone is interested:SELECT * FROM sysobjectsWHERE OBJECTPROPERTY(id,N'IsUserTable') = 1
Will return tables created when merge replication is configured on a SQL Server 7 database, even though in enterprise manager they are clearly shown as system tables. Have to code it like this:SELECT * FROM sysobjectsWHERE OBJECTPROPERTY(id,N'IsUserTable') = 1and OBJECTPROPERTY(id, N'IsMSShipped') <> 1
Even though the tables don't "Ship" with SQL Server... they are not there at all unless you configre merge replication.----Nancy Davolio: Best looking chick at Northwind 1992-2000<edit> to fix display </edit>Edited by - robvolk on 08/13/2002 20:17:25