Dear Gail

Thank with the script given it working fine. I was trying through SSMS and it was creating the issue. Dont know whats going wrong when i try it from ssms