Tech Support > Microsoft Windows > Windows CRM > 1.2 to 3.0 Upgrade / Install
1.2 to 3.0 Upgrade / Install
Posted by Glen Howie on December 14th, 2005


So I'm trying to upgrade our demo server, and get these two errors (amongst
others); (and I'm para-phrasing)

1) Triggers inconsistent with 1.2 (extra ones in database)
2) SP's inconsistent with 1.2 (missing?)

so..

1) how does it check for extra SP's ? (is there a SQL script that can be
run?) I know there might be extra ones in there, and I'm willing to clean
them out but without checking every table..?)
2) what SP's is it looking for ?

thanx for any help, kind words of encouragment, etc
--
Glen Howie
Microsoft CRM Product Specialist
WolfBridge Solutions
www.wolfbridgesolutions.com

Posted by David Jennaway on December 16th, 2005


Afraid I don't know the specifics, but I'd use SQL Profiler to see what it's
doing. It'll give you a fair bit to wade through, but you can save the trace
output to a SQL table and search that. Look for queries that reference
sysobjects and INFORMATION_SCHEMA

Hope this helps

"Glen Howie" wrote:

Posted by Glen Howie on January 2nd, 2006


Actually to answer my own question, the log file in;

systemdrive\documents&settings\userprofile\applica tion
data\microsoft\mscrm\logs\crmsvrsetup.log

lists all the sp's and truiggers in question.


--
Glen Howie
Microsoft CRM Product Specialist
WolfBridge Solutions
www.wolfbridgesolutions.com



"Glen Howie" wrote:


Similar Posts