When you Uninstall SQl server some of the traces will be left behind one of them are Reporting serivces catalogs in order to fix this issue
Error : Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error : the user specified as a definer (‘root’@’%’) does not exist Solution : grant all on *.* to ‘root’@‘%’ identified by ‘password’ with
SQL Error : The password does not meet Windows policy requirements because it is not complex enough. Solution : We have to use ‘CHECK_POLICY = OFF’ in
Problem : The file is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.
As we know SQL Server 2000, 2005, 2008 and 2008R2 doesn’t provide intellisense like Visual Studio by default. While writing SQL statements/queries, we need to