>I let my application connect to an existing SQL Server instance, which then will create the database in this instance. Problem is we only support SQL 2008, so I need to check the version of the instance, without being connected to a database. The SQL Server instance can also be on another computer on the network. HOw can I check the version, having only the sa password and the instance name?
SELECT @@VERSION
Why only 2008?
What not 2008 R2 and 2012?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
