How to determine SQL server version number for Compact edition 4 up to full sql server 2008?

I don't really work with SQL Server anymore but here is my attempt at this little problem For version 4 of compact edition the following should give you the version and build var ver = new System.Data.SqlServerCe.SqlCeConnection(). ServerVersion And the following should give you the assembly version var version = typeof(System.Data.SqlServerCe. SqlCeConnection).Assembly.GetName().Version.

I don't really work with SQL Server anymore but here is my attempt at this little problem. For version 4 of compact edition the following should give you the version and build. Var ver = new System.Data.SqlServerCe.SqlCeConnection().

ServerVersion; And the following should give you the assembly version var version = typeof(System.Data.SqlServerCe. SqlCeConnection).Assembly.GetName().Version.

Thanks Gareth, it's what I ultimately ended up doing. Not how I wanted to do it but it does the job. – JohnC Apr 17 at 23:01 Not at all elegant but I'm glad it worked for you.

– Gareth Apr 18 at 7:02.

Take a look at this blog post. It has a link to download a utility that detects which version of SQL Compact edition you're running. It also has a link to the source code for the utility which may be of interest to you.

Sorry I wasn't specific enough I guess. I need a way to know via a sql query what version of sql server I'm connected to so that my code can issue the appropriate format of paging query. – JohnC Apr 15 at 5:04 @JohnC, Looking at the SQL Server Compact Edition Function List (technet.microsoft.Com/en-us/library/ms174077%28SQL.100%29.

Aspx) it doesn't look like there is a function to return which version is running via TSQL. – Jason Towne Apr 15 at 15:34.

Run this SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') See details here.

The methods in that link will work for all versions of SQL Server except Compact edition which is one of the versions the OP listed in his question. – Jason Towne Apr 15 at 15:39 Yikes! I wrote that method right in my question.

:( – JohnC Apr 17 at 22:59.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.