SQL server 2000 (SP 4)?

• nicholas-250056

  SSC Enthusiast

  Points: 107

  More actions

  October 18, 2005 at 6:41 pm

  #110629

  Dear sqlservercentral friends,

  Good Day! I already install the SP 4 for my SQL Server 2000, can i know how to ensure that i install successful? I means, from which way i can check , MANY THANKS!

  Also, one more question! I run my Enterprise Manager, can i know why the memory will keep increasing? Is it any bugs or something else i havent do???

  Many Thanks!

  Regards,

  Nicholas

• fhanlon

  SSChampion

  Points: 13131

  More actions

  October 20, 2005 at 8:55 am

  #598746

  type Select @@version

  the respose in part should be:

  Microsoft SQL Server  2000 - 8.00.2039...

   

  SQL Server likes memory and will attempt to take as much as it can.  There is nothing wrong with this.

  see http://www.sqlservercentral.com/columnists/nboyle/memorytuning.asp

   

  Francis