SQL/NoSQL Public Diary
Sunday, March 1, 2015
How to get SQL server and instance name??
If you want to know the SQL Server server name and instance name then just execute the
below query:
SELECT @@servername
If you want to know only the instance name of SQl server then execute:
SELECT SERVERPROPERTY ('InstanceName')
Thanks!!!
1 comment:
rmouniak
July 6, 2018 at 6:01 AM
It 's an amazing article and useful for developers
Sql server DBA Online Training Bangalore
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
It 's an amazing article and useful for developers
ReplyDeleteSql server DBA Online Training Bangalore