How To Apply Security Patches

I want to ask 1 sim开发者_如何转开发ple question in SQL SERVER.....

How To Apply Security Patches in SQL SERVER 2000 and above.

Sql security patches (and also service packs) are usually downloaded from Microsoft as EXE files (usually 3 options for x86, x64, or IA64)

To apply these patches, you just run the EXE file directly on the server.

Note: the answer can be slightly different for the free versions of SQL Server 2000 (e.g. MSDE, Sql Express)