Archive for the ‘SQL’ tag
What version of SQL (revisited)
Stan Smith has just posted a link to MS KB 321185 – How to identify your SQL Server version and edition which is quite handy.
I’ve posted previously on how to find out what version of SQL is running, but this newer KB link above adds SQL 2008 version numbers as well.
SQL 2005 Versions
I have to thank Kevin Chieff (ACT! guru) for pointing me to this link on how to tell the difference between versions of Microsoft SQL 2005 – and the MS page it points to re the SERVERPROPERTY (Transact-SQL) command.
The number of times I’ve had to work out just which version of SQL is running is amazing. The difficulty in doing so is amazing. There ought to be a simple utility that does it all.
So the two links above will get used a lot in conjuction with my previous post re determining SQL versions.
Evolving the ACT
It is now two weeks in to my new digs at Evolution Marketing – and it sure is fun.
Primarily I’ve been learning how to drive ACT!, software to take care of your contact management. Yesterday and today I’ve been playing with custom tables in the ACT! MS-SQL database. While ACT! looks after contacts and tasks, meetings & calls to do with your contacts really well, some clients would like to be able to do even more, like handle job sheets etc. Which is the reason for the custom tables. These allow us to track all sorts of other information and connect them to contacts & companies.
I’ve also setup a Blackberry Bold simulator and a Windows Mobile 6 Emulator, this allows me to experience the same things as our clients, notably HandHeldContact, which allows you to sync multiple calenders, notes, histories etc to your phone – loads more than MS Exchange alone allows.
To paraphrase the paragraphs above, I’m having fun learning new stuff!
The other staff at Evolution are great to work with, the coffee is good and all the tech toys I’ve asked for have been delivered, with the exception of the telephone headset, but it is on the way so they’re forgiven ;-). Woot!
Update 20th Oct: Got the telephone headset on Friday afternoon. Cool.
What version of SQL Server is running?
[update: SQL2005 versions more info here]
To find out what version of SQL Server your running, do this:
From the command prompt on the SQL Server itself,
osql -E -S %computername%
This will give you a SQL prompt, at which you do the following:
1>exec master..xp_msver 'ProductName'
2>exec master..xp_msver 'ProductVersion'
3>go
This gives you two bits of information, (1) the Product Name & (2) the Product Version – which requires some interpretation, note them both. But first, at the SQL prompt, type quit.
1>quit
The table below will help determine exactly what SQL Server is running.
By finding the file SSNETLIB.DLL and right clicking it, and checking the version number. If the version number of this file is 2000.80.760.0, you have SQL Server 2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL Server 2000 SP3a.
This file is normally found in one of these two locations:
- Default instance: C:\Program Files\Microsoft SQL Server\Binn\Ssnetlib.dll
- Named instance: C:\Program Files\Microsoft SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Of course, Microsoft have more to say and you can find it at: www.support.microsoft.com/kb/321185