{"id":113,"date":"2008-08-25T14:51:48","date_gmt":"2008-08-25T17:51:48","guid":{"rendered":"http:\/\/www.foxnet.com.br\/portal2\/?p=113"},"modified":"2008-08-25T14:51:48","modified_gmt":"2008-08-25T17:51:48","slug":"como-identificar-a-versao-e-a-edicao-do-seu-sql-server","status":"publish","type":"post","link":"https:\/\/www.foxnet.com.br\/portal3\/?p=113","title":{"rendered":"Como identificar a vers\u00e3o e a edi\u00e7\u00e3o do seu SQL Server"},"content":{"rendered":"<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Para determinar qual vers\u00e3o do SQL Server 2005 est\u00e1 em execu\u00e7\u00e3o, conecte-se ao SQL Server 2005 usando o SQL Server Management Studio e execute a seguinte instru\u00e7\u00e3o Transact-SQL:SELECT\u00a0 SERVERPROPERTY(\u2019productversion\u2019), SERVERPROPERTY (\u2019productlevel\u2019), SERVERPROPERTY (\u2019edition\u2019)<br \/>\nOs resultados s\u00e3o:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoListParagraphCxSpFirst\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">A vers\u00e3o do produto (por exemplo, \u201c9.00.1399.06\u2033).<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">O n\u00edvel do produto (por exemplo, \u201cRTM\u201d).<\/span><\/p>\n<p class=\"MsoListParagraphCxSpLast\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">A edi\u00e7\u00e3o (por exemplo, \u201cEnterprise Edition\u201d).<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Por exemplo, o resultado deve ser similar a:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">9.00.1399.06 RTM Enterprise Edition<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">A seguinte tabela lista o n\u00famero de vers\u00e3o do Sqlservr.exe:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Lan\u00e7amento<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><strong><span style=\"font-size: 10pt; color: #000000;\">Sqlservr.exe <\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\nRTM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02005.90.1399<br \/>\nSQL Server 2005 Service Pack 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02005.90.2047<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Como determinar qual vers\u00e3o do SQL Server 2000 est\u00e1 em execu\u00e7\u00e3o<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\nPara determinar qual vers\u00e3o do SQL Server 2000 est\u00e1 em execu\u00e7\u00e3o, conecte-se ao SQL Server 2000 usando o Query Analyzer e execute o seguinte c\u00f3digo:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">SELECT\u00a0 SERVERPROPERTY(\u2019productversion\u2019), SERVERPROPERTY (\u2019productlevel\u2019), <\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">SERVERPROPERTY (\u2019edition\u2019)<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Os resultados s\u00e3o:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoListParagraphCxSpFirst\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">A vers\u00e3o do produto (por exemplo, 8.00.534).<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">O n\u00edvel do produto (por exemplo, \u201cRTM\u201d ou \u201cSP2\u2033).<\/span><\/p>\n<p class=\"MsoListParagraphCxSpLast\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">A edi\u00e7\u00e3o (por exemplo, \u201cStandard Edition\u201d).<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Por exemplo, o resultado deve ser similar a:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">8.00.534 RTM Standard Edition<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">A seguinte tabela lista o n\u00famero de vers\u00e3o do Sqlservr.exe:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Lan\u00e7amento<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><strong><span style=\"font-size: 10pt; color: #000000;\">Sqlservr.exe<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\nRTM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02000.80.194.0<br \/>\nSQL Server 2000 SP1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02000.80.384.0<br \/>\nSQL Server 2000 SP2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02000.80.534.0<br \/>\nSQL Server 2000 SP3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02000.80.760.0<br \/>\nSQL Server 2000 SP3a\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02000.80.760.0<br \/>\nSQL Server 2000 SP4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02000.8.00.2039<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Como determinar qual \u00e9 a vers\u00e3o em execu\u00e7\u00e3o do SQL Server 7.0<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\nPara determinar qual vers\u00e3o do SQL Server 7.0 est\u00e1 em execu\u00e7\u00e3o, conecte-se ao SQL Server 7.0 usando o Query Analyzer e execute o seguinte c\u00f3digo:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">SELECT @@VERSION<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Os resultados s\u00e3o parecidos com o seguinte:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server\u00a0 7.00 &#8211; 7.00.623 (Intel X86)<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Nov 27 1998 22:20:07<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Copyright (c) 1988-1998 Microsoft Corporation<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Desktop Edition on Windows NT 5.1 (Build 2600: )<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Observa\u00e7\u00e3o<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><span>\u00a0 <\/span>Neste exemplo, o n\u00famero da vers\u00e3o \u00e9 7.00.623.<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Use o n\u00famero da vers\u00e3o da seguinte tabela para identificar o produto ou o n\u00edvel de service pack:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">N\u00famero da Vers\u00e3o<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><strong><span style=\"font-size: 10pt; color: #000000;\">Service Pack<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\n7.00.1063\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 7.0 Service Pack 4 (SP4)<br \/>\n7.00.961\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 7.0 Service Pack 3 (SP3)<br \/>\n7.00.842\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 7.0 Service Pack 2 (SP2)<br \/>\n7.00.699\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 7.0 Service Pack 1 (SP1)<br \/>\n7.00.623\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 7.0 RTM (Release To Manufacturing)<\/span><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\">\u00a0<\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\">\u00a0<\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Se o n\u00famero da vers\u00e3o reportado por @@VERSION n\u00e3o estiver listado nesta tabela, o SQL Server estar\u00e1 executando um hotfix ou a compila\u00e7\u00e3o de uma atualiza\u00e7\u00e3o de seguran\u00e7a. Por exemplo, se @@VERSION relatar um n\u00famero de vers\u00e3o 7.00.859, voc\u00ea est\u00e1 executando o SQL Server 7.0 SP2 com um hotfix instalado. O n\u00famero da vers\u00e3o aumenta com cada nova vers\u00e3o do arquivo execut\u00e1vel Sqlservr.exe Consulte o arquivo Readme.txt do seu hotfix ou atualiza\u00e7\u00e3o de seguran\u00e7a para obter informa\u00e7\u00f5es adicionais.<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Como determinar qual vers\u00e3o do SQL Server 6.5 que est\u00e1 em execu\u00e7\u00e3o<\/span><\/strong><strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\n<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\">Para determinar qual vers\u00e3o do SQL Server 6.5 que est\u00e1 em execu\u00e7\u00e3o, conecte-se ao SQL Server 6.5 usando Isql_w e execute o seguinte c\u00f3digo:<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">SELECT @@VERSION<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Use o n\u00famero da vers\u00e3o na seguinte tabela para identificar o n\u00edvel do produto ou do service pack.<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">N\u00famero da Vers\u00e3o<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><strong><span style=\"font-size: 10pt; color: #000000;\">Service Pack <\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\n6.50.479\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 5a (SP5a) Update<br \/>\n6.50.416\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 5a (SP5a)<br \/>\n6.50.415\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 5 (SP5)<br \/>\n6.50.281\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 4 (SP4)<br \/>\n6.50.258\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 3 (SP3)<br \/>\n6.50.240\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 2 (SP2)<br \/>\n6.50.213\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 Service Pack 1 (SP1)<br \/>\n6.50.201\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL Server 6.5 RTM<br \/>\n\u00a0<br \/>\nSe o n\u00famero da vers\u00e3o reportado por @@VERSION n\u00e3o estiver listado nesta tabela, o SQL Server estar\u00e1 executando um hotfix ou a compila\u00e7\u00e3o de uma atualiza\u00e7\u00e3o de seguran\u00e7a. O n\u00famero da vers\u00e3o aumenta com cada nova vers\u00e3o do arquivo execut\u00e1vel Sqlservr.exe Consulte o arquivo Readme.txt do seu hotfix ou atualiza\u00e7\u00e3o de seguran\u00e7a para obter mais informa\u00e7\u00f5es.<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Como determinar qual edi\u00e7\u00e3o do SQL Server est\u00e1 em execu\u00e7\u00e3o<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"><br \/>\nSe voc\u00ea n\u00e3o tiver certeza sobre qual edi\u00e7\u00e3o do SQL Server est\u00e1 em execu\u00e7\u00e3o, a \u00faltima linha da sa\u00edda retornada pelo @@VERSION reporta a edi\u00e7\u00e3o com a qual voc\u00ea se conectou. O exemplo usado neste artigo \u00e9 o SQL Server 2000 Standard Edition no Windows NT 5.0 (Build 2195: Service Pack 2).<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Observa\u00e7\u00e3o<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\"> As informa\u00e7\u00f5es sobre a compila\u00e7\u00e3o e sobre o service pack fornecidas anteriormente servem para o sistema operacional, n\u00e3o para o SQL Server.<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Standard Edition no Windows NT 5.0 (Compila\u00e7\u00e3o 2195: Service Pack 2)<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">Refer\u00eancias<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">Para obter mais informa\u00e7\u00f5es, clique nos n\u00fameros abaixo para ler os artigos na Base de Dados de Conhecimento Microsoft (alguns artigos podem estar em ingl\u00eas):<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\"><br \/>\n290211 (<a href=\"http:\/\/support.microsoft.com\/kb\/290211\/\"><span style=\"color: #0000ff;\">http:\/\/support.microsoft.com\/kb\/290211\/<\/span><\/a>) Como obter o service pack mais recente para o SQL Server 2000<br \/>\n301511 (<a href=\"http:\/\/support.microsoft.com\/kb\/301511\/\"><span style=\"color: #0000ff;\">http:\/\/support.microsoft.com\/kb\/301511\/<\/span><\/a>) Como obter o service pack mais recente para o SQL Server 7.0<br \/>\n273914 (<a href=\"http:\/\/support.microsoft.com\/kb\/273914\/\"><span style=\"color: #0000ff;\">http:\/\/support.microsoft.com\/kb\/273914\/<\/span><\/a>) Readme.txt para a atualiza\u00e7\u00e3o para SQL Server 6.5 posterior ao service pack 5a<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/strong><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><strong><span style=\"font-size: 10pt; color: #000000;\">A informa\u00e7\u00e3o contida neste artigo aplica-se a:<\/span><\/strong><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0px; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000;\">\u00a0<\/span><\/p>\n<p class=\"MsoListParagraphCxSpFirst\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2000 Standard Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2000 64-bit Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 7.0 Standard Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 6.5 Standard Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2005 Standard Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2005 Express Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2005 Developer Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2005 Enterprise Edition<\/span><\/p>\n<p class=\"MsoListParagraphCxSpLast\" style=\"margin: 0px 0px 0px 36pt; text-indent: -18pt; line-height: 14.25pt;\"><span style=\"font-size: 10pt; color: #000000; font-family: Symbol;\"><span>\u00b7<span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt; color: #000000;\">Microsoft SQL Server 2005 Workgroup Edition<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Este artigo descreve como identificar o n\u00famero de vers\u00e3o atual do Microsoft SQL Server e o n\u00edvel de service pack (SP) ou do produto correspondente. Tamb\u00e9m descreve como identificar a edi\u00e7\u00e3o espec\u00edfica se voc\u00ea estiver usando o Microsoft SQL Server 2000 ou o Microsoft SQL Server 7.0&#8230;. <\/p>\n<div class=\"read-more navbutton\"><a href=\"https:\/\/www.foxnet.com.br\/portal3\/?p=113\">Read More<i class=\"fa fa-angle-double-right\"><\/i><\/a><\/div>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,16,26,102],"tags":[124,171,85,172],"class_list":["post-113","post","type-post","status-publish","format-standard","hentry","category-software_microsoft","category-programacao","category-software","category-sql-programacao","tag-microsoft","tag-ms-sql","tag-sql","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=113"}],"version-history":[{"count":0,"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foxnet.com.br\/portal3\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}