Just wanted to give an update, I have solved the issue, and am pretty certain it was due to a SQL security update that happened over a week ago. ...

No, its just a development environment, nothing is restored from the production server or vice versa, for all intents and purposes they are completely independant SQL 2008 servers. Yes,...

Thanks for the links, after comparing the roles on our dev and production boxes I noticed a big difference. I see that on our Dev box (currently working fine)...

Yes, that is correct. Grant is selected for all securables. Master is the default. I have tried changing the users default database to a database they have dbo...

I am the server administrator (far from a DBA)

I can recreate this issue by creating a new user. New users by default have the "public" role. They should...