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.
| Author |
Topic |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2006-08-22 : 18:48:40
|
| Is there any command gives the update and patches installed in the server. Select @@version gives the Sql Server version and service pack detail. But I also like to have more detail on this, like when patch was installed and what all the patches in the server.thanks in advance. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-08-22 : 19:05:19
|
| See here for version info:http://www.sqlteam.com/item.asp?ItemID=8318As far as install date, you'll need to track that yourself. You *might* be able to glean that from file timestamps in the SQL Server program folder, but I wouldn't count on it. Patch contents are documented on Microsoft's web site under the Service Pack info pages. |
 |
|
|
|
|
|
Patches Installed