Common Table Expressions (CTE’s) are a new structure in SQL Server 2005 that can be used to assist with performing recursive operations.
Monthly Archives: March 2007
The WARDY IT Community Dinner is a great opportunity to network with other IT professionals in order to share knowledge, information and experiences.
If you have already installed SQL Server 2005 Service Pack 2 it is recommended that you apply the Critical Update referenced in KB933508.
Often when a new login has been created and the user mapped to a login the next step is to grant EXECUTE to all Stored Procedures in a database.
More and more organisations are looking at Virtualization as a solution to managing the growth in the number of SQL Server instances that today’s IS departments need to support.