db.sql and MyDMS_StoredProcedures.sql don't match up

Oct 7, 2009 at 4:44 AM

Hi, I wanted to give this a whirl, but the sql files don’t match up.

I get errors like the following when running the MyDMS_StoredProcedures.sql


Msg 207, Level 16, State 1, Procedure TG_Office_SelectAll, Line 5

Invalid column name 'Office_Logo'.

I see I might be able to fix up a couple of the tables by adding a new column, such as [Is_Verified] in [dbo].[UserInfo] but others are not so clear. Could you upload another version of db.sql with the correct tables and columns?

Much appreciated


Jul 23, 2010 at 8:35 PM


I am trying to setup the project and start working. But I have the same issue as Mark. 

Is somebody working on the issue or you people dumped the project. Atleast if we have a idea about database then we can give some input

Please upload the latest database code for both tables as well as stored procedures


Satish Busarapu

May 17, 2011 at 4:50 AM

H PettyMark

can you modify column name 'Office_Logo' ---> 'Office_Logo_Path'