Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server Version Info

Posted on 2013-06-04
3
Medium Priority
?
378 Views
Last Modified: 2013-06-10
I am gathering the version info of some SQL servers for an audit. Is there a way to get the same information as you would from running the Select @@version query without having to log into the SQL management studio?

-Thanks
0
Comment
Question by:Allanore
3 Comments
 
LVL 4

Expert Comment

by:erik_nodland
ID: 39219289
Hi

You can use sqlcmd to do it from the command line.

Something like

sqlcmd -S myServer\instanceName -i C:\version.sql

where version.sql cotains the sql command

select @@version
go

This can obviously be done remotely as well assuming you have rights. If you need to specify a username\password then just add -U and -P switches.

thanks
Erik
0
 
LVL 19

Accepted Solution

by:
Bhavesh Shah earned 2000 total points
ID: 39219313
hi,

check out this link.
and follow the step.

if you need any assitance, get back to us.

http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx
0
 
LVL 41

Expert Comment

by:Sharath
ID: 39220645
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question