Professional Web Applications Themes

How to know which SQLServer Service pack is installed? - Microsoft SQL / MS SQL Server

Gustavo, HOW TO: Identify Your SQL Server Service Pack Version and Edition [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185[/url] -- Dinesh. SQL Server FAQ at [url]http://www.tkdinesh.com[/url] "Gustavo Pizzini Becker" <gustavoinf.ufrgs.br> wrote in message news:O6GNiYZQDHA.1072TK2MSFTNGP10.phx.gbl... > How to know which SQLServer Service pack is installed? Is there a query for > it? > > Thanks, > > Gustavo > >...

  1. #1

    Default Re: How to know which SQLServer Service pack is installed?

    Gustavo,

    HOW TO: Identify Your SQL Server Service Pack Version and Edition
    [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185[/url]


    --
    Dinesh.
    SQL Server FAQ at
    [url]http://www.tkdinesh.com[/url]

    "Gustavo Pizzini Becker" <gustavoinf.ufrgs.br> wrote in message
    news:O6GNiYZQDHA.1072TK2MSFTNGP10.phx.gbl...
    > How to know which SQLServer Service pack is installed? Is there a query
    for
    > it?
    >
    > Thanks,
    >
    > Gustavo
    >
    >

    Dinesh.T.K Guest

  2. #2

    Default Re: How to know which SQLServer Service pack is installed?

    [url]www.aspfaq.com/2160[/url]



    "Gustavo Pizzini Becker" <gustavoinf.ufrgs.br> wrote in message
    news:O6GNiYZQDHA.1072TK2MSFTNGP10.phx.gbl...
    > How to know which SQLServer Service pack is installed? Is there a query
    for
    > it?
    >
    > Thanks,
    >
    > Gustavo
    >
    >

    Aaron Bertrand - MVP Guest

  3. #3

    Default Re: How to know which SQLServer Service pack is installed?

    select version should do it!

    gl,


    tudor
    mcse, mcsa,
    [url]www.ipcom.ro[/url]


    "Gustavo Pizzini Becker" <gustavoinf.ufrgs.br> wrote in message
    news:O6GNiYZQDHA.1072TK2MSFTNGP10.phx.gbl...
    > How to know which SQLServer Service pack is installed? Is there a query
    for
    > it?
    >
    > Thanks,
    >
    > Gustavo
    >
    >

    Tudor Sofron Guest

  4. #4

    Default Re: How to know which SQLServer Service pack is installed?

    This is always covered in the readme file for service packs. It's in section
    1.4 of the SQL Server 2000 SP3a readme:

    [url]http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp[/url]

    --
    Alan Brewer [MSFT]
    Lead Technical Writer
    SQL Server Doentation Team

    This posting is provided "AS IS" with no warranties, and confers no rights


    Alan Brewer [MSFT] Guest

Similar Threads

  1. [Macromedia][SQLServer JDBC Driver][SQLServer]Internal
    By gsmadman in forum Coldfusion Database Access
    Replies: 1
    Last Post: February 9th, 04:53 AM
  2. SERVICE PACK 4 HELP
    By raydan in forum ASP Database
    Replies: 2
    Last Post: August 18th, 01:11 PM
  3. service pack
    By toyin in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 18th, 01:05 AM
  4. Service pack 1
    By Dave INM in forum Windows XP/2000/ME
    Replies: 6
    Last Post: July 15th, 12:04 AM
  5. Deleting the backup done when service pack 1 is installed?
    By Aussie in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 4th, 06:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139