| Author |
Topic |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2010-09-21 : 02:14:39
|
| Does anybody have a complete list of system views (catalog, DMV, etc.) gathered together? :)in 2000 and 2005/2008 versions.e.g.:sql 2000 | sql 2005/2008 | typesysdatabases | sys.databases | catalog view:) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-09-21 : 02:31:37
|
| well, BOL and MSDN are very handy and useful :) but one needs to copy/paste and search in order for desired results :)i thought that someone has this "magic" list already prepared ;)i'll check your blog :) |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-09-21 : 11:18:20
|
| --All sysviewsselect * from sys.all_views --All DMVsselect * from sys.all_objects where name like 'dm%' and type='V'MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-21 : 13:21:08
|
| Quest offers some nice posters and PDFs for system objects:http://www.quest.com/backstage/promotion.aspx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-09-21 : 15:01:31
|
| thank you all. :) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-21 : 15:54:01
|
quote:
I've requested the posters for the ones I'm interested in. I look forward to the phone calls, email, and snail mail stuff that I'll get as a result. NOT!!!
I ordered the Perf counter poster and got it in the mail within 2-3 weeks, but no phone calls or harassing emails whatsoever. It's possible they have my old info or I requested it via Mailinator, either way I'm not complaining.By the way, if Quest is at a SQL Saturday event they will usually have these posters as giveaways. And if Kevin Kline is there he'll send you all kinds of things if you ask. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
system views