hi Sean,

please find attached image , as i have written trigger, after executing it prints message what i have mentioned in code but it is allowing to insert record as...

that mean the login id which has sysadmin role, that cant be restricted to access an indivisual table in any way?

hi Eric,

thanks for such a good explaination, actually there are already multiple running applications and it is not possible to remove logins from sysadmin role or cant modify any users...

hi Andrew,

thanks for the response, there are so many jobs running, any idea to check which job related to Queuereader agent.

hi please find the output below.

DBCC results for 'MCT'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667,...

thanks for your swift response, I am placing some part of error, may be you will get any idea about this error and please help me to describe it or...

thanks for your valuable comment on it.

But what if client ask to create at least one index on each table which are not even suggested by missing index DMV.

he needs...

ok then please give me an idea regarding what to see when keeping an critical eye on each index, what is the best part to look into it.

but we can not test as its production environment, there's a long process to create or drop any index on server. so by having an idea only i have to...

and please provide any guidelines on this to add number secondary data files and initial size of each file..?

ok thanks for your prompt resonse...That mean in current scenario, i have to assign specific port numbers in all instances of DR server same as assigned in production server right?...

one more thing anthony this option "ON ALL SERVER" will enable on a specific instance on which we will create this trigger, or something else will do?

anthony thanks for reply, can you please tell me what else changes required in existing script if i only want to cature events CREATE, DROP, ALTER LOGIN only..

and what...

as i have seen this link, it is mainly dfor DDL things like create or drop tables on a database, trigger will we created on database level.. but to capture...

thanks for reply, how a DDL trigger will work on it can please elaborate?