We have a legacy application that uses a REVOKE ALL SQL command. Up until now, all of our customers can run the application under SQL 2005 and SQL 2008 without any errors. We have one customer that has been running our application for years without
any problems. Recently, they have been starting to receive errors in the form of an exception when they run the app and execute the above command. the error states "The ALL permission is deprecated and maintained only for compatibility.
It DOES NOT imply ALL permissions defined on the entity." My first impression was that they must have upgraded their SQL instance to one that no longer supports the deprecated command. Usually, these type of low level warnings never get thrown as errors.
I checked their SQL 2005 version and it's 9.0.3073. We are running the following versions in house but do not receive the error. (9.0.3042, 9.0.5000, and 10.0.2531). If I open SQL Server Managem ...
Go to the complete details ...