(rajigopal@gmail.com) writes:
> When we create new user objects, can we assume that the object_id will
> constantly increase? In other words, if I create a table and then a
> view, is it true that the object_id of the view if I query sysobjects
> view will be greater than the object_id of the table?

It does not seem so. I ran this query on a database that I have:

select name, crdate, id from sysobjects where type = 'U' order by crdate

Output:

abaconfigproperties 2008-02-03 19:36:39.107 1977058079
abaconfigsettings 2008-02-03 19:36:39.153 2009058193
abahistsysobjects 2008-02-03 19:36:39.217 2073058421
abainstallhistory 2008-02-03 19:36:39.293 2105058535
abaobjecttypes 2008-02-03 19:36:39.357 5575058
abasslabels 2008-02-03 19:36:39.403 37575172
abasubsystems 2008-02-03 19:36:39.450 85575343
abasysobjects 2008-02-03 19:36:39.513 133575514



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx