We do it every year once, we have very huge prod DB in log shipping. The client wants to get copy of then live prod db for their testing and...

Hi we have exactly same issue, I restarted new thread just now didn't see yours before, got ur after googling:-)

did you resolve issue, our LS is working perfectly fine just...

The way we did it, is creating procedures and udfs script from generate script functionality of sql 2008, per file.The script didn't have Drop Function or proc script that we...