Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server system tables Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 3:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 2:57 AM
Points: 53, Visits: 155
Hi,

I am familiar with SQL and have created queries.

With TSQL the problem I'm having is I'm not sure which SQL Server system tables to look in for the data I need (there are a lot of tables to browse through....)

Is there a reference guide on the internet which could guide me to look at certain system tables for certain tasks. For example for backups look in msdb.dbo.backupset table, for monitoring replication look in msdb.dbo.sysreplicationalerts and msdb.dbo.sysalerts tables etc. etc.

I know how to query but when given a new task I'm a bit lost as to where to find my data, from which SQL server system tables.

Thanks.
Post #1450967
Posted Thursday, May 9, 2013 4:51 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 29, 2014 2:55 AM
Points: 702, Visits: 2,179
SQL Server books online is essentially the documentation for SQL Server. Just use the drop down to change the version as you require. You'll need to look in there really to find what you're looking for. To be honest, I'll always just hit my favourite search engine with some appropriate key words. It's very rare that there's nobody out there that hasn't done something similar to what I'm after. The trick is to understand any code you may find before running or using it.

Thanks,


Simon




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1451013
Posted Thursday, May 9, 2013 5:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 2:57 AM
Points: 53, Visits: 155
Ok I'll do that, thanks for your help and advice.
Post #1451022
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse