In our environment ,we are planning on applying service packs to all the sql instances which were old and we have 2005/2008/2008R2.
I have searched online but i dont find any particular document for service packs or patches.
Can anyone please send me a document or link that shows step by step process for applying the SP's ?
I'm looking for the pre-reqs, installation process and post installation with all the details...
Also , my main concern is i'm preparing a document with list of sql servers in my environment ( i believe there are around 100 servers ), version,current service pack, latest service pack to apply ...
Please help me on finding a script to get all these details at once...like any powershell or cmd script ?
Thanks in advance...