Dear All

As per the scenario above I also faced the same problem with one of my SQL server 2008 R2 edition. After troubleshooting and cross checking...