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 |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2007-04-30 : 12:11:30
|
| HelloIs there any script or procedure which can give the object name , type ,status and owner in a database.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-30 : 12:38:29
|
| You can query sysobjects in sql2k or sys.sysobjects in sql2k5. |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-04-30 : 14:35:19
|
| You can use sysobjects as rmiao suggestes. Another alternative is to investigate the INFORMATION_SCHEMA system views. -Ryan |
|
|
|
|
|
|
Getting Object details in the DB