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 |
|
sbalaji
Starting Member
48 Posts |
 Posted - 2007-08-30 : 05:59:25
|
| sys.objects is a view built on sys.objects$ table.What is this $ table.Where it is available? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-30 : 06:08:01
|
| it is not available. it's a system table._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 21:12:44
|
| Are you talking about Oracle? View name in sql2k5 is sys.sysobjects. |
|
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-08-31 : 04:50:58
|
| Not in Oracle,Its in SQL 2005,I just stumbled upon this when i was looking for some system informationsys.objects,sys.sysobjects,sys.columnsIt seems,these views are built upon system tables,which we dont have access.If u try to run a select on the tables available,u get Invalid object name error. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 15:02:55
|
| Microsoft doesn't let you query system tables directly in sql2k5, unless you connect to sql instance with DAC. |
|
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-09-03 : 08:18:23
|
| Yes,its working with DAC.Thanks for the info |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-03 : 08:20:14
|
| i still don't understand why do you want to access these?there's no point in this._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-09-03 : 08:41:24
|
| I was working with altering the length of UDD.This was just out of curiosity.cheers |
|
|
|
|
|
|
sys.objects$