Toad for SQl Server returns the following Error:
Error Number 911 Message Database 'DATABASEACCESSVERIFYTRL' does not exist. Make sure that the name is entered correctly.
SQL Text
USE DATABASEACCESSVERIFYTRL;
--SELECT * FROM fn_my_permissions ('sys.dm_db_index_usage_stats', 'object')
declare @viewdatabasestate bit;
set @viewdatabasestate = 0;
declare @viewserverstate bit;
set @viewserverstate = 0; SELECT @viewdatabasestate = HAS_PERMS_BY_NAME(db_name(), 'DATABASE', 'VIEW DATABASE STATE'); SELECT @viewserverstate = HAS_PERMS_BY_NAME(null, null, 'VIEW SERVER STATE'); DECLARE @select_dm_db_index_usage_stats bit BEGIN TRY IF EXISTS(SELECT TOP 1 * FROM sys.dm_db_index_u
WORKAROUND
none
SOLUTION
Waiting for a fix in a future version of Toad for SQL Server.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center