In this post we will discuss how we can get the database server name in sql server 2008. Also you can check out my previous posts on:
- Get nth highest lowest salary in SQL Server 2008
- Working with enterprise library for data access in asp.net Part-3
- Asp.Net MVC4 Controller class example
Below is the script to get the server name of the sql server 2008:
select @@SERVERNAME As 'Server Name'
Below is the script to get the version of the sql server:
Select @@VERSION As 'SQL Server Version'
The result will come like below:
- Get nth highest lowest salary in SQL Server 2008
- Working with enterprise library for data access in asp.net Part-3
- Asp.Net MVC4 Controller class example
Below is the script to get the server name of the sql server 2008:
select @@SERVERNAME As 'Server Name'
Below is the script to get the version of the sql server:
Select @@VERSION As 'SQL Server Version'
The result will come like below: