Hi All,

The situation we faced is like, one request came to restore Prod backup to Dev server with last available backup, so we have checked the last backup file history...

Hi Brandie Tarvin & K. Brian Kelley,

can you please let me know how to change colour of the new query window for prod(red) and dev(green), it can be a great...

That's one of the reasons I color code my instances' query windows in SSMS (green for Dev, yellow for Test, orange for QC, and red for Production). The colors help...

any other way or any one else can put your suggestions for the same.......

Thnaks for the reply Gila.

by any way we can kill the command if it get fired to a production server.

we will not deny restore database, but can we kill the restore before database...