Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to update MIP software and one of the "companies" fails while it is updating a stored procedure.

fail updating stored procedures

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.

share|improve this question
1  
Have you talked to Abila support? They may have information about where they log such errors so you can investigate further. SQL Server doesn't log all errors for you unless they are critical (and this is not). So, you could start a server-side trace or extended events session to see what is really happening behind that dialog, or you could generate the script (if the GUI supports that) and run it yourself in Management Studio. –  Aaron Bertrand Jan 31 at 17:34
    
I did talk to support; how would I generate the script so I could run it myself? Would it be somewhere in the installation? –  leeand00 Jan 31 at 17:38
1  
Sorry, no idea, I have never seen or used that tool, I am just grasping and hope it has an option to generate the script for you instead of only allowing you to run it behind your back. –  Aaron Bertrand Jan 31 at 17:39
    
Well it sounds like a good idea, I will ask tech support about it. I feel like I could fix it if I knew what was going on. –  leeand00 Jan 31 at 17:41

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
Thanks! This helped too: stackoverflow.com/questions/5199812/… –  leeand00 Jan 31 at 18:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.