Thank you so much Gila, You always rock

I want to understand the reason behind it. why regular full backup is not allowed in secondary replica in always on

I already checked, but it didn't help.

Ols Hallengren's script doesn't provide multi-threading solution.

@Phil \ @george - OrderNo and OrderHeadrNo are two different columns of different tables. Value of both columns must be different that's why identity at a column will not...

I Agree, No workaround can prevent these actions if it is intentionally, But definitely help us track the accident and prevent the any accidental changes. Not sure how can i...

I know, Limited permission is the appropriate solution of this.
 but in my case, I cant remove permissions due to some business reasons, that's why I have to implement these...

Thank you so much, Perhaps I was not able to think at this level.

Guys,
After Restrict the Drop databse through DDL trigger, 
I need to restrict all db users to take OFFLINE and DETACH the database from the SQL server. 
1.  I created the ddl trigger for ALTER_DATABASE....

Thank you so much guys, @gail- you are right, now clear my confusion.

Dear Folks, 
I know if condition is commented, because I was trying to put a condition with db state ONLINE, but unfortunately I cant capture the same with the help...

I can understand, But I have to implement trigger as its kind of environment requirement.

@jeff - Very valid points,But I want to give a chance to it as my server has high-end configuration and no business activity/user land at weekend on server.

Thanks a lot to all of you for your great suggestions, I agree this is bad query which doesn't follow even the basic rules of optimal query writing. 
But I would...

@Eirikur/@Fritchey - Thanks a lot for suggesting week points of this query, indeed these all are nice suggestions. if I remove group by list, IsNull function from where clause. but...