Hi,

After a longtime I see there is no reply from the Gurus here, to help me tide over this issue. But just to inform all here since the last post...

Hi,

255 Threads on the server.

max worker threads,32,32767,255,255

Have tired using sp_executesql but no luck.

Thanks

Hi,

Here is the Code for the Proc:

CREATE procedure restoreDB_prodTest

as

begin

DECLARE...

Check BOL it gives detailed usage and advantages of using DBCC Shrik Files.

Tushar