Know the Database version
-
Hi,I am new comer of sql server2005.How can I know the database version through query.Pls help me
-
Hi,I am new comer of sql server2005.How can I know the database version through query.Pls help me
SELECT @@VERSION
Next time i will not give you an Answer, you must First Google before you post here on the Forum.
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
SELECT @@VERSION
Next time i will not give you an Answer, you must First Google before you post here on the Forum.
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
I know this query.By this I know the version of sql server.Can I know the version of master database or user create database version.
-
I know this query.By this I know the version of sql server.Can I know the version of master database or user create database version.
hi I dont Understand what you want.
Forum: SQL and Database discussions
Subject: Re: Know the Database version
Sender: Sritanu _ Ghosh
Date: Friday, August 1, 2008 2:46 PMDoes a Database have a Version ? Am not sure what you want. ok
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
hi I dont Understand what you want.
Forum: SQL and Database discussions
Subject: Re: Know the Database version
Sender: Sritanu _ Ghosh
Date: Friday, August 1, 2008 2:46 PMDoes a Database have a Version ? Am not sure what you want. ok
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
Vuyiswa Maseko wrote:
Does a Database have a Version ?
I think he wanted to ask the compatibility level(SQL 7.0/2000/2005 etc). Here's the GUI process: In the management studio, right click on the db -> select Properties -> click on Options -> the Compatibility Level is displayed along with the collation and recovery model. But I dont know how to retrieve it using T-SQL. Syed Mehroz Alam.
-
Vuyiswa Maseko wrote:
Does a Database have a Version ?
I think he wanted to ask the compatibility level(SQL 7.0/2000/2005 etc). Here's the GUI process: In the management studio, right click on the db -> select Properties -> click on Options -> the Compatibility Level is displayed along with the collation and recovery model. But I dont know how to retrieve it using T-SQL. Syed Mehroz Alam.
i was Suprised , lets hear if this solves his Problem. :) Thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
I know this query.By this I know the version of sql server.Can I know the version of master database or user create database version.