Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SSMS and case sensitivity
Message
From
22/02/2012 08:29:17
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01535979
Message ID:
01536076
Views:
31
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform