Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 information on patches and Build

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2008-07-23 : 05:09:15
Gurus
I have never applied patches in sqlserver ,Can you provide me some information on patches in sql server and i am listening this term called "BUILD" in sql server?
IS this related to patches?

Thanks
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-23 : 13:50:22
Do you at least install service packs?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-23 : 23:46:15
>> i am listening this term called "BUILD" in sql server

Or you can call it version number, can get that with 'select @@version'.
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-07-26 : 10:06:45
Patches as per my knowledge is SP's and hotfixes and BUILD is refer to the output of select serverproperty ('productversion') or select @@version

Thanks
Chander :)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-26 : 21:07:39
They are same.
Go to Top of Page
   

- Advertisement -