Thanks Frank

Reinvention of wheel can be useful in crunch so plz suggest if there is other way round ...........

is there any other way through coding...................

yes i can parse

but through em it shows sp3 why it shows sp4 in select @@version

Plz Brief me How i will use data in that case

The same thing i do but i want permanent remedy plz

no transaction is open and autogrowth is also enabled but i dont know what the problem plz suggest

But this takes one table at a time,i want

one procedure for all.