Most commonly used System Objects? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Most commonly used System Objects?

Author

Topic

larus
Starting Member

17 Posts

Posted - 2009-11-19 : 02:11:36

Hi,

I have couple of questions regarding SQL Server 2005/2008 System objects:

1. Which System Views in a database are the most useful and most commonly used?
2. Which Stored Procedures in a database are the most useful and most commonly used?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-19 : 02:26:29

It really depends on what issue you are working on.

1. Various DMVs and DMFs
2. sp_who/sp_who2

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

larus
Starting Member

17 Posts

Posted - 2009-11-19 : 02:35:07

Yes, it depends, but there must be some System Objects that are frequently used in command task

1. Commonly used and most useful system objects (views, sp's) Database admininstration
2. Commonly used and most useful system objects (views, sp's) Database desing

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources