Post reply

Service pack applied

  • March 30, 2009 at 2:19 pm

    #203129

    I masters,

    Do you know any t-sql to see what is the Service Pack that i have applied on my instance of SQL Server 2000?

    tks,

    pedro

  • March 30, 2009 at 8:30 pm

    #968834

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Product Level = SP.

    Also a good reference is http://sqlserverbuilds.blogspot.com/ to see your build :).

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply