Dot Net Questions: System Tables And Sql Server 2000 Query
- Date: 2007-04-20 - Word Count: 246
Share This!
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
Sysaltfiles
Syscolumns
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
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
Sysaltfiles
Syscolumns
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
Related Tags: dot net faq, dot net questions, dot net interview questions, sql server 2000 query
Know more about dot net interview questions and dot net questions here Your Article Search Directory : Find in Articles
Recent articles in this category:
- Ideas For Finding a Nanny Job
Looking after the welfare of children is a very important job. The role of caregivers in the present - What There is to Know About a Temp Agency
A temp agency is a place were skilled office workers can go to get work. There are a number of diffe - Discovering the Many Ways a Temp Agency Can Assist in a Down Economy
When out of money and unable to find work, often times can look hopeless. However, for many who have - Careers That Require Financial Responsibility
Keeping your finances in order is important for any adult, but if you want to work in certain career - What You Need To Know About Resumes And Cover Letters
If the ways of getting employed is composed of steps, the first task would be to come up with an imp - How To Increase Your Chances Of Getting Hired
In trying to get a job, the person that you are going to impress, aside from your would-be boss, wou - Tips on How to Get Hired in a Flash
Unemployment rate all over the world is undeniably huge. But, the bigger problem that professionals - Tips and Techniques on Finding a Job Quickly
There are three ways on how you can get employed at the soonest possible time- that would be, knowin - Securing Your Lifetime Starts Now
If by the time you're 30 and you still don't know what you want to do with your life, it should alre - Occupational Therapy Jobs For a Career in Nursing
Occupational therapy jobs are undertaken by individuals who are willing to engage their skills in he
Most viewed articles in this category:
- Hollow Eyes Are Not Dark Circles Under The Eyes
Many people of all ages complain of dark circles under their eyes. The phrase "dark circles under th - Career As A Hairstylist
Hairdressing is an art that involves arranging hair for aesthetic purposes, participation in formal - Life After West Point Military School
West Point exists to educate and train Cadets who are commissioned as Officers in the US Army upon G - Work Experience In Fashion - How To Get A Great Opportunity In Fashion Work
Work experience in fashion can be one of the most challenging positions to find. It's a simple equa - Tips for Job Hunting in Today's Market
In order to be competitive in today's job market, you must stand apart from the competition. Just h - Who are the EMTs
You'll find them at Denny's. At least I always do. Denny's, Coco's, Perkin's; any all-night restaura - Hiring A New Assistant?
More and more small businesses and even larger companies are turning to virtual office assista - You Too Can Start an Independent Record Label
It's no big secret, the trick of how to start a record label definitely involves some cash and most - Increased Salary with a Medical Degree: Consider the Options
Physicians are probably one of the highest paid professionals in the world. They make a lot of money - 5 Steps to Becoming a Virtual Assistant
Here are 5 steps that I went through in becoming a virtual assistant. These aren’t official by