Deting SQL Server Version

[Nitin Nikam]

How Can I detect version of SQL Server running on the web server using
ASP.Net (C#)

I am working on a installer and want to check machine configuration before
installing the web based script.

Thanks In advance,
NN

 

[Gabriel Lozano-Morán]

With a SQL statement:
SELECT @@VERSION;

Gabriel Lozano-Morán

 

[Rad [Visual C# MVP]]

How Can I detect version of SQL Server running on the web server using
ASP.Net (C#)

I am working on a installer and want to check machine configuration before
installing the web based script.

Thanks In advance,
NN

You can create a SqlCommand object and execute the following query

Select @@version

This will give you information about the installed SQL Server version