Know System Databases

  • 10:23 PM
  • 1 comments
Master 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...
Read more »
 

Copyright © 2010 SQL Cached, All Rights Reserved. Design by DZignine