Monthly Archives for February 2011
A quick overview of Microsoft SQL Server Metadata
SQL Server has a set of tables that store information about all the objects, data types, constraints, … In SQL Sever 2008 these tables are called the system base tables. These tables can exist either only in the master database … Continue reading
Microsoft SQL Server: SAVE TRANSACTION
Today somebody asked me a question concerning SAVE TRANSACTION, so I decided to write a small blog post about the basic concept. Consider a database test that resides on our SQL Server instance. In this database we have a table … Continue reading