We have a server with two instances of SQL Server 2005. Both the instances right now had SP1 applied on them. Now we want to upgrade SP2 on only one instance, ie. instance 2. Is it possible to keep one instance on service pack1 and other on service pack 2?
Thanks in Adv.