Okay we are trying to write a script to find out the version of the database but cannot find the command. We know "select @@version" will give us the version of the database server but we need to know the version of the database the database server is running. Currently dealing with database server version 8, 9, 10. Thanks in advance for your assistance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to find the version of the database
- Thread starter sux2b
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
In SQL Server I pull @@version and then parse it using the substring and patindex functions.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP
My Blog
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question