Krishna1 (6/20/2013)
Dear GailThank 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
I ran that from SSMS too. Either the DB was left in full recovery (which is the default) or you had some code somewhere that was changing the DB to full recovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability