An SQL Server 2008 R2 based program fails when updating stored procedures? I'm trying to update MIP software and one of the "companies" fails while it is updating a stored procedure.  



Is there any place in SQL Server 2008 R2 / Windows where I could see an error message about what might be causing this?  When I did the installation I gave it the sa password, and it worked for all the other "companies" that we have in the system just fine.
Considering that you're running the upgrade, this SQL Server instance must not be in production, right? If so, why don't you fire up the SQL Profiler tool to see what's happening behind the scenes. The trace should show you where the troublesome spot is. Happy troubleshooting! Hope you solve the problem.