Thank you all for your help,

Adding recompile to sp helped, the article cleared some questions nad created this sp will run once a day but 30 times( each time...

The wierdest part is that running the same query with no parameters( embede values) works fine and running sp and passing parameters no metter if to sp or to a...

Thanks for your replies. Probably there are some security issues. The problematic server is domain member, but my dev machine is stand-alone machine, which in this case is the only...

You're right. BIG telecom company and i CAN'T filter load data sets

Thanks for the advice!!

Any other suggestions

Hi!

ALL servers have SP2 installed and Principal & Mirror are SP3

MsForEachDB can be easily replaced by using variables in SSIS.

But the idea is great!

I have a complete set of scripts that works for sql2000 and higher edditions and it gives...