SP2/BPA Frequently Asked Questions

SQL Server 2005 Compact Edition

EXEC dbo.LongTermMemory__Archive — Fri, 19 Jan 2007 11:30:15 GMT

SQL Server 2005 Compact Edition has been RTM'ed (formerly known as SQL Server Everywhere). More information...

SQL Server 2005 Compact Edition

EXEC dbo.LongTermMemory__Archive — Sat, 20 Jan 2007 13:20:01 GMT

SQL Server 2005 Compact Edition has been RTM'ed (formerly known as SQL Server Everywhere). More information...

Best Practice Analyzer for 2005

Tibor Karaszi — Sat, 03 Feb 2007 12:55:48 GMT

I'm glad to see that the tool Best Practice Analyzer is finally coming in a SQL Server 2005 version.

SQL Server 2005 Best Practices Analyzer

.NET Tools Blog — Sun, 04 Feb 2007 18:07:47 GMT

re: SP2/BPA Frequently Asked Questions

Nik — Thu, 08 Feb 2007 02:25:12 GMT

A pity the don't provide slip-streamed SQL 2005 release, which would save many hours of unnecessary work.

re: SP2/BPA Frequently Asked Questions

rsocol — Mon, 12 Feb 2007 20:16:43 GMT

You wrote: "Can I upgrade only the tools on my client workstation? Will this still work with SQL Server 2005 RTM and SP1?

Yes. If you want to test out the functionality of the tools, you do not have to upgrade your database engine. There are some areas of the product that may have required changes to the engine or stored procedures. These features should display a friendly message indicating that they will not work on pre-SP2 instances."

However, the following bug:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249725

can cause some real problems if the UI tools are on SP2 and the server is on SP1. There is no friendly message here, you just see misleading informations in the UI.

Please consider fixing the bug for the final release of SP2.

Razvan

SP2の残はSQL Server 2005 BPAとPerformance Dashboard Reports

米田 Blog ( SQL Server MEMO ) — Wed, 21 Feb 2007 22:44:29 GMT

SP2の残はSQL Server 2005 BPAとPerformance Dashboard Reports

Don’t miss on – current goodies with SQL Server 2005

.NET and SQL Geek — Mon, 26 Feb 2007 11:05:43 GMT

Recently Microsoft has release the much awaited SP2 for SQL Server 2005. Guys go and grab it – it has

re: SP2/BPA Frequently Asked Questions

John Bates — Thu, 29 Mar 2007 05:40:39 GMT

Hi Paul,

Since the T-SQL checking is being removed from the final product, can this be factored out into a separate tool? I found it very useful for enforcing ANSI compliance, proper DB options, etc. with developers.

I still have to deal with SQL 2000 instances occasionally so if it can have separate compatibility levels that would be great. A command line tool using a configuration file would be excellent for QA teams.

John.

re: SP2/BPA Frequently Asked Questions

Tim Hatcher — Tue, 01 May 2007 10:50:39 GMT

I hear what you are saying about the T-SQL checking section, and that FxCop is the way to go, do you know if there are any plans or roadmap to update it to check T-SQL ?

Thanks

Tim