Dot Net Questions - System Tables and Sql Server 2000 Query


Visitors: 308

System tables are the groups of table that helps sql server to track the information regarding users, databases, tables, replications tasks and so many task and also helps in sql query just like insert query, delete sql query, update sql query, . All information regarding database that is knows by sql server are in system tables. These system tables are break down into server groups.

1) The master databases contain information regarding databases, logins, server and some system wide information.

2) Each data base contains some table which holds information on objects, indexes, columns and some database information.

3) The MSDB database contains a set of tables that used by SQL SERVER Agent which store information on alerts, jobs and others items that manages by agents.

4) The MSDB contains information regarding backup and restore information.

5) The master database contains a set of tables that hold name of publishing and subscribing servers.

6) The distribution database contains information on replication schedules and transactions.

7) The databases that participate in replication objects with in those databases.

There are almost 100 of system tables and some examples of queries are here:

Sql Server 2000 query on systems tables:

1) To get name of primary files from system table database Selectname, filename from sysdatabases

2) How t get name of all files used by database with the help of Sql Server 2000 queries Select name, filename from sysfiles.

Some examples of system tables
Master database
To hold databases
In each database
Column information

If you want to know the entire database name then the query is:
Select * from sysobjects where xype = ‘U’ order by name

Know more about dot net interview questions and dot net questions here


Article Source:

Rate this Article: 
MCP Market News: Microsoft SQL Server & SQL Reporting Services
Rated 4 / 5
based on 5 votes

Related Articles:

How to Recover or Reset Sa Password in SQL Server 2000

by: Yee Lau (October 18, 2010) 
(Computers and Technology/Data Recovery)

Parameters in Microsoft SQL Server 2000 Reporting Services

by: Tom Bizannes (September 26, 2005) 
(Computers and Technology/Software)

Server Roles In Dot Net

by: Adam Sturo (June 24, 2007) 
(Business/Careers Employment)

About 70-458: Transition your MCTS on SQL Server 2008 to MCSA SQL Server 2012 ..

by: Jason S. Lawson (July 08, 2014) 
(Computers and Technology/Certification Tests)

70-457: Transition your MCTS on SQL server 2008 to MCSA: SQL server 2012 Part 1 .

by: Jason S. Lawson (July 08, 2014) 
(Computers and Technology/Certification Tests)

SQL Server Compare and SQL Server Migration - Make your Life Easier

by: Daniel Zr (April 24, 2011) 
(Internet and Businesses Online/Web Development)

Dot Net Questions - COM - DCOM - COM+

by: Perjej Munjal (February 28, 2007) 
(Computers and Technology)

Dot Net Questions - XML Reader Class

by: Adam Sturo (June 07, 2007) 

SQL database recovery in case of heap corruption in SQL Server Agent

by: Colin Dolly (January 27, 2011) 
(Computers and Technology/Data Recovery)

MCP Market News: Microsoft SQL Server & SQL Reporting Services

by: Guy Leba (May 17, 2005) 
(Computers and Technology/Software)