Hi,
I hit error when upgrading my 2.2.1 database to 3.0.4 using the SQL Package application located under Gemini Database folder as below. Any ideas? Should I run the script manually? BTW, where could I get the upgrade instruction doc?
<SQLError Package="CounterSoft_Gemini_v3_0_1_SampleDatabase"><Error>There is already an object named 'gemini_getissuereportersforallprojects' in the database.</Error><Assembly>CounterSoft_Gemini_v3_0_1_SampleDatabase</Assembly><Package>Package1.resx</Package><Batch>Batch642</Batch><SQL>
CREATE PROCEDURE gemini_getissuereportersforallprojects
as
begin
SELECT b.projectid,a.firstname+N' '+a.surname AS fullname
FROM gemini_users a join gemini_issues b on a.userid=b.reportedby
GROUP BY b.projectid,a.firstname+N' '+a.surname
ORDER BY fullname
end
</SQL></SQLError>
Thank you