Hi,
Does any one know how to regress the Service pack in SQL server.
Today I spend couple of hours for this testing and came to know that my assumption that 'systemresource' database is used to regress the service pack in SQL server was wrong.
What i did:
1) Made a SQL Sever without SP (taken 'systemresource' database backup)
2) Install Service Pack1 (taken 'systemresource' database backup)
3) Install Service Pack2 (taken 'systemresource' database backup)
4) Install Service Pack3 (taken 'systemresource' database backup)
My purpose was to regress from heigher SP version to lower SP version. But when i replaced the 'systemresource' database files from lower version to heigher. The SP version didn't changed. I tried it with all the backups. But it didn't work at all.
Does anyone know if this is possible?
Thanks,