Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SSMS and case sensitivity
Message
 
 
To
22/02/2012 08:13:40
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01535979
Message ID:
01536071
Views:
25
>>The first one looks like it is missing SP1.
>
>On that server, only SSMS is installed for 2008. The engine is not there. So, it would then be possible to install SSMS for 2008 from a DVD for R2 without having installed the DVD for SP1. Is that correct? But, if that is the case, does this mean, on that server which has no engine, that we would have to insert the DVD for SP1 just to install SSMS and then do the same procedure again from the DVD for R2?
>
>I would then assume SP1 would have been missing from all the other installations where SQL Server 2008 R2 was installed. This is something I will have to check this morning.

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
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform