Daily Archives: February 9, 2012

SHRINKFILE, SHRINKDATABASE and AutoShrink

Just got an insight of these 3 commands ! In fact, something worth knowing , if you are managing really large databases ! A write-up by Simon Facer here would give a wonderful understanding of Why SHRINKFILE is a very … Continue reading

Posted in Database | Tagged | Leave a comment

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

In SQL Server 2008, while you try adding a new column, even though ‘is null is true’, or any change which needs a table drop and recreate,  you might get this error message : Saving changes is not permitted. The … Continue reading

Posted in Database | Tagged , | Leave a comment

The data protection operation was unsuccessful. This may have been caused by not having the user profile loaded for the current thread’s user context, which may be the case when the thread is impersonating.

Exception Details: System.Security.Cryptography.CryptographicException: As the error message says all you need to do is to have the ‘User profile loaded in IIS’ – you can set this in the setting for the AppPool of that specific application in IIS manager. … Continue reading

Posted in General, MS CRM | Tagged , | 1 Comment