Category Archives: SQL Server

SQL Server: What’s new in SQL Server 2008

  Please read the article below by Joshua Jones: Almost five years had passed the last time Microsoft released an upgraded version of its flagship SQL Server database back in 2005. While SQL Server 2005 was warmly received by IT … Continue reading

Posted in SQL Server | Leave a comment

SQL Server: Get Version of the running version

  SELECT ‘SQL Server ‘ + CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR) + ‘ – ‘ + CAST(SERVERPROPERTY(‘productlevel’) AS VARCHAR) + ‘ (‘ + CAST(SERVERPROPERTY(‘edition’) AS VARCHAR) + ‘)’

Posted in SQL Server | Leave a comment