Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

2005 - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » 2005 (RSS)

The SQL Server 2005 evaluation software is no longer available. Learn more about the enhancements and new features in SQL Server 2008

Well it is a surprise (rather a bad news) for the SQL Server users, especially those who wanted to evaluate the SQL Server 2005 edition. From SQL Server 2005 downloads resources ... read more ...

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to...
Posted by ssqa.net | with no comments

SQL Server Upgrade issues - How to evaluate potential issues?

During the end of March 2009 I have presented a session " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices" in SQLBits IV conference at Manchester. The session covered a brief tour on SQL Server Upgrade options, methodology...

Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)

The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...

Production version of SQL Server 2005 Service Pack 3 (SP3) is released

Ok, you have seen many blog posts out there asking for Service pack 3 for SQL Server 2005 (such as Are you ready for SP3 and SQL2005SP3_WorkStarted , it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to...

SQL Server 2005 Service Pack 3 - public beta for your action

As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment. So what this public beta provides, this is a rollup Quick Fix Engineering that will have all...

Get ready for SQL Server 2008 RTM release!

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 will be on the August price list. This means that customers and...

SQL Server Upgrade - don't forget the Collation issues?

Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation...

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

SQL Server 2008 Express features and variation from previous version

Flood of questions fromthe users during a recent usergroup meeting. What will the specification for the SQL Server 2008 Express version be? What will be the differences between it and the 2005 version, not with MSDE? How about SQL Agent attachment to...