New way to get SQL Server 2005 version

After updating my SQL Server 2005 to SP1 I tried to find out what version was running. So I open a new query window and type:

SELECT @@VERSION

and get as result:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) ...

I'm not so good at deciphering these version numbers so I wanted to look them up. Only then I found out that there were some changes to Transact-SQL.

Read more ...
1 May 2006  Comments [0]  SQL Server 2005  
Updaye your SQL Server 2005 Books Online

Last week I attended the Deep Dive SQL Server 2005 course at Class-A. The trainer Bob Beauchemin from SQLskills shared a lot of information with us on SQL Server 2005.

One of the things I would never thought of is updating the "Books Online". Bob told us that the documentation shipped was based on a previous release of SQL Server 2005. That also explains the Downloading and Updating Books Online link in the "Additional Information" pane of the Books Online mainscreen.
The december release of the English version is available for download, the download size is 118.3 MB.

How do you know if your Books Online or up-to-date? Check the title bar of the Books Online window. After updating the Books Online the title bar shows what version of the documentation is installed.

Books Online

14 Mar 2006  Comments [0]  SQL Server 2005