run the script as it is on your server.
inspect the database tables and structure. notice a table called 'gautengdata' that does not have a primary key.
inspect the store procs.
DECLARE @return_value int
EXEC @return_value = [dbo].[_SPLOG_SPConstructor]
SELECT 'Return Value' = @return_value
with default parameters
refresh the stored procedures
inspect the stored procedures.
think about this:
a true programmer knows that the path of least effort (resistance) is usually the road to rapid application development and successful delivery.
all of this means lots of money...