Step-By-Step Instructions on How to export query result to .csv file in SQL Server 2008 1. Open SQL Server Management Studio 2. Go to Tools […]
Tag: SQL Server
Change The Instance Name On Microsoft SQL Server
1. Login on to the server you want to change the name of 2. Run this in Microsoft SQL Server Management Studio 3. Click on Create […]
Determining Service Pack Level Microsoft SQL Server
Log onto server Open SQL Server Management Studio (SSMS) Click About then Help To the right of SQL Server Management Studio match the Versions with the list below to determine your service pack […]
Scheduling Backups on SQLServer Express
Since Netback Database Client will not backup Microsoft SQL Express. The backup solution I came up with was one .sql file each for full and incremental backup, and […]
SQL Memory Leak Settings Work Around
Microsoft SQL Memory Leak work around. Microsoft SQL is a huge memory resource consumer there is no fix besides add more memory but there is a […]