When you plan to install the Windows 7/2008 R2 SDK, the SDK needs to be installed before VS2010 SP1. Here is the recommended install order: 1. Visual Studio 2010 2. Windows SDK 7.1 3. Visual Studio 2010 SP1 4. Visual C++ 2010 SP1 Compiler Update for the Windows SDK 7.1 Here is the link to …
November 2011 archive
Nov 21 2011
Unit Testing Private Static Methods in C#
I had never needed to unit test a private static class method in C# before, but it turns out that Microsoft created a special object type to handle just such a case. To test the private static method DetermineFilename (that takes filePath as a string parameter and returns a string) in the FileManager class, do …
Nov 17 2011
Get SQL Server Version/Edition Information
Just connect to the database in which you are interested, open a new query window, and enter the following query:
|
1 2 3 4 5 |
[sourcecode language="sql"] SELECT SERVERPROPERTY('ProductVersion') as 'Product Version', SERVERPROPERTY('ProductLevel') as 'Product Level', SERVERPROPERTY('Edition') as 'Edition' [/sourcecode] |
For me, this produced the following:
|
1 2 |
Product Version Product Level Edition 10.50.1600.1 RTM Enterprise Edition (64-bit) |