What is the information stored in the master database ?

The master database holds information for all databases located on the SQL Server instance and 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.
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
The tempdb database holds temporary objects such as global and local temporary tables and stored procedures.
The model database is essentially a template database used in the creation of any new user database created in the instance.

Comments

Post a Comment

Popular posts from this blog

Export gridview into excel pdf csv   http://www.aspsnippets.com/ Articles/Print-functionality- in-ASP.Net- GridView -control. aspx  http://www.aspsnippets.com/ Articles/Export- GridView -To- Word-Excel-PDF-CSV-Formats-in- ASP.Net.aspx
Read more
How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));         temptable.Columns.Add("IsActive", typeof(string));         foreach (ListItem item in ListBox1.Items)         {             if (item.Selected)             {                 //                 // Here we add five DataRows.                 //                 temptable.Rows.Add(1, 1, 1);             }
Read more