SQL Server 2005 | Kuhnline.com

SQL 2008 R2 Shrink Log Files in Management Studio

Date July 28, 2016 Author By kadmin Category SQL Server 2005

Set Logging To Simple If you want to prevent further growing you need to set your database logging to simple (but only if you do Full Backups of your database!). Right click on your database Choose Properties Choose Options Set Recovery mode to simple Shrink The Database Open up Sql Management Studio Right […]

SQL 2005 Shrink Log Files Without Management Studio

Date July 5, 2016 Author By kadmin Category SQL Server 2005

Paste this into Query Analyzer USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO source

Visual Studio 2010 SQL Express 2008 SA Account

Date September 2, 2011 Author By kadmin Category SQL Server 2005

VS2010 configures SQL Express for Windows Authentication and disables the SA account You must install SQL management studio 2008 R2 in order to change the SA password SQL management studio must be Run As Administrator or you can’t do anything (right-click the icon and choose Run As Administrator). then you must turn on mixed mode […]

SQL 2005 Management Studio Install

Date November 2, 2009 Author By kadmin Category SQL Server 2005

The problems with installing SQL Management Studio 2005 are well documented here and here. But I recently had a unique problem of my own. I ran sqlrun_tools.msi from the CD as suggested but it kept saying the components were already installed. After many tries, I found that SQL 2005 Express Edition tools were installed and […]