BugNET

Only one stored proc does not have [dbo] as the prefix in it's CREATE Procedure statements in the install scripts.

BugNet_Bug_GetBugFixedInVersionCountByProject

This means that  it gets created in the sql 2005 default schema which may not be dbo if you use shared hosting.

This can cause a few problems.

1) If it's called with the dbo prefix dbo.BugNet_Bug_GetBugFixedInVersionCountByProject, it will not be found.

2) If you manually delete all your BugNet database objects in the dbo schema, this object/proc in another schema gets missed resulting in a subsequent failure of the install script when you re-install.  Because that proc will exist in your default schema still.

This happenend to me last week on a re-install situation.

Thanks

Rick Hubka