Ok,i'll put in with some example.

I have tableA with CCode

and would like...

If i had a server side trace for auditing, which events i need to look into to get this information.

I reboot my servers every week, that means i think these queries will not give correct info.

Ok, i persume that last modifed date od an mdf or log file may...

I still believe there should be some way from the sys databases or some where else to find this information.

I am not an expert about the system information but how...

Thats all i can say. Looking for a date when was the last DML activity occured on a database.

still ican not edit my own job even after creating a new one and save it.

how do i troubleshoot this, its urgent for me.

thanks

nope thats the issue here. I would like to create those procs " WITH EXEC AS DBO" so that person authorised to exec the proc can assign permissions.

Read/Write permissions to...

Actually i am trying ot save time for restore. The .bak file may also has log in it which is very big and so i want to truncate that file...