We had an interesting problem on a recent project where SQL Server 2005 wouldn’t install on a Windows 2008 R2 failover cluster. The cluster validates properly however when installing SQL Server 2005, the install threw an “User has cancelled the installation” error. The logs showed that communications to the remote node were failing: [...]
- danovich.com.au -
For the enterprise sys admin by the enterprise sys admin
22
Jan
How to tell what version of SQL is running?
Published in Tools, WindowsI’ve often needed to work out what service pack level SQL is running or whether it is a Enterprise or Standard installation. It’s not obvious how to do this and it’s not as simple as going to Help –> About. The following query will work in SQL 2000 and above. To run it, for example [...]
Tags: service pack level, SQL, SQL version, what version