Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SSMS and case sensitivity
Message
De
22/02/2012 08:29:17
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01535979
Message ID:
01536076
Vues:
21
>If you only have SSMS on that server, then it's OK. Just verify SQL Server version using
>
>select @@Version, SERVERPROPERTY('Edition') AS Edition,
>	SERVERPROPERTY('ProductVersion') AS ProductVersion,
>	SERVERPROPERTY('ProductLevel') AS ProductLevel
On the server where the engine is installed, it gives this:

Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5448
Operating System 6.1.7601

On the server where the engine is installed, your command gives this:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 X64 (Build 7601: Service Pack 1) (Hypervisor)
Enterprise Edition (64-bit)
10.50.1600.1
RTM

On the server where the engine is installed, SP1 is then installed. However, what would then have to be done in order to assure that the SSMS tool on that server is up to date?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform