Articles of level

Master Database
Purpose - Core system database to manage the SQL Server instance.  In SQL Server 2005, the Master database is the logical repository for the system objects residing in the sys schema.  In SQL Server 2000 and previous editions of SQL Server, the Master database physically stored all of the system objects.

  • Prominent Functionality
  • Per instance configurations
  • Databases residing on the instance
  • Files for each database
  • Logins
  • Linked\Remote servers
  • Endpoints
  • The first database in the SQL Server startup process
The Master database holds information for all the databases located on the SQL Server instance, and it is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.Master database is system database. It contains information about servers configuration. It is a very important database and important to backup Master database. Without Master database, server can not be started.Master database is used to store information of all the databases on the SQL server. The server cannot start if the database is not configured properly.

The SQL Server (Transact-SQL) SUBSTRING functions allows you to extract a substring from a string.

SUBSTRING( string, start_position, length )
Parameters or Arguments:
string: The source string to extract from.
start_position: The position to start extraction from. The first position in the string is always 1.
length: The number of characters to extract.

PreviousDisplaying 2 of 2
1 2
Need Help? Contact Us.

Log in


Forgot password?


New User