Thanks for that I did that to get the correct size of the log ut in general I don't leave the auto grow option on due to other deterimental impacts...

Worked a treat!! Amazing what a little setting like that could do. Server built with the wrong default paths but never picked up until now.

You are probably best creating DB roles and applying the permissions to that role,

eg

USE DBName

go

CREATE ROLE UPDATE_ROLE

go

GRANT EXECUTE ON [dbo].SP TO [UPDATE_ROLE]

go

GRANT SELECT, DELETE, INSERT, UPDATE ON [dbo].[tblStartup] TO...