Problem: drop database ITAxCRMBI;
5780 Cannot DROP a user or database that has DBQL enabled.
Solution: You cannot drop a user or database that has DBQL logging enabled. First disable logging for that user or database. show query logging on ITAxCRMBI;
Request Text Rule UserName ITAxCRMBI Rule UserId 00001843 Rule ZoneId 00000000 Account (Rule for any Account)
DBQL RULE: Explain F Object F SQL F Step F XMLPlan F StatsUsage F UseCount T Param F FeatureUsage F Verbose F StatsDetails F UtilityInfo F NoColumns F Summary F Threshold F Text Size Limit 200
end query logging on ITAxCRMBI; show query logging on ITAxCRMBI; Request Text Rule UserName ITAxCRMBI (From an ALL rule) Rule UserId 00000000 Rule ZoneId 00000000 Account (Rule for any Account)
DBQL RULE: Explain F Object F SQL T Step F XMLPlan F StatsUsage T UseCount F Param F FeatureUsage F Verbose F StatsDetails F UtilityInfo F NoColumns F Summary F Threshold F Text Size Limit 300 drop database ITAxCRMBI; |