EXEC sp_dbcmptlevel database, 90---error

[raghvendrapanda]

Hy, While using pivot in my stored procedure i got the following error "Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel." To Solve it when i used "EXEC sp_dbcmptlevel database, 90" my sp got execited sucessfully but the rest of the sp's in the same database and having pivot stared showing me error After i changed it back to "EXEC sp_dbcmptlevel database, 80" the rest of the sp's havng pivot started working properly except the current sp i am working on. Kindly help,