Sunday, September 30, 2007

How to upgrade SQL server 2005

use SKUUPGRADE=1 swtich from the command prompt with setup.

Eg :
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Refer
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade

Evaluation to EE Upgrade
Refer :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2111140&SiteID=1

Saturday, September 22, 2007

SQL Server 2005 Debugging

http://blogs.msdn.com/sqlclr/archive/2006/07/07/659332.aspx

Connecting to SQL Server 2005 on Vista and Longhorn

I have seen lots of post in forums connecting to sql server 2005 on Vista. Check out this post by Protocol Team. http://blogs.msdn.com/sql_protocols/archive/2007/06/18/connecting-to-sql-server-2005-on-vista-and-longhorn.aspx#comments

Troubleshooting Performance Problems in SQL Server 2005

Good resource on Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx