While migrating from MS CRM 4.0 to MS CRM 2011, if your 4.0 contains some custom SPs,
before migrating you need to 1st chop all there, then import by using the deployment manager.
After that you can again put back the SPs.
So if the number is too high(for me it was around 250) :(
then just follow the below
Below steps may help you. Finally you will get output in scripts. Execute that script in your destination.
Before that make sure to back up your destination DB.
Hope this will help others also.