Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laailalalaa
Yak Posting Veteran
57 Posts |
 Posted - 2009-03-03 : 03:48:30
|
| what's the conceptual difference between sys.sysobjects, sys.objects and sysobjects (in sql server 2005)? (or other name resembling tables / views)i can see there are different columns, but why need 3 different views (tables)?thanks |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2009-03-03 : 03:55:48
|
| did you try looking in books online?sys.sysobjects and sysobjects are only there for backwards compatibility (left over from SQL2000)Em |
 |
|
|
|
|
|
difference in system views