November 3, 2008 at 7:24 am
Guys,
I have a big doubt, I am running my SQL database is 8.00.760 version, I say that is SQL 2000, but my admin user says that is MSDE, please any little help, how can I know that I am running with MSDE or 2000?
Thank you.
November 3, 2008 at 7:27 am
I don't know if it works on 2000, but on 2005 you can do this:
Select SERVERPROPERTY('Edition')
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 3, 2008 at 7:28 am
By the way, remember to check which Forum group you are in when you post: this is a SQL Server 2005 forum.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 3, 2008 at 7:30 am
Yes it works under 2k as well.
November 3, 2008 at 7:42 am
Thank you Guys, it worked, my apologies, yes I noticed this is 2005 Forum, but just after I posted this, sorry I am going to move this over it.
Thanks.
November 3, 2008 at 8:02 am
Glad we could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply