stored procedures issues

I resolved my issue, but only by reattaching the SQL Express .mdf file. Once done, I could view all of my stored procedures and none were missing. Hopefully, they'll be there later today.

Does anyone have an idea why this would have happened?

 

I installed the JobSiteStarterKit and got it working. I was able to login, post jobs, enter company information, etc... and all seemed great. I went back this evening and now I get the error EXECUTE permission was denied on the object 'JobsDb_Companies_GetCount'. Interesting I get the error now when it seems that it was working just fine since the site statistics were displaying without error this afternoon.

I checked the stored procedures, but I can't even find this one in particular. In fact, compared to my SQL Server 2005 Express database, over half of the stored procedures are missing. Could the attach process gone awry?

What I'd really like to do is just create this stored procedure via the SQL Server Management Studio Express tool, but I again getting insufficent permission error when logged in under the default SQL login account. Should I be logging in using something else?

Any help would be greatly appreciated.

 

It's a mystery to me....the site was working perfectly yesterday afternoon. Last night I got the 'execute permission denied' error on the sproc. Today I just attached the db again, overwriting the existing db (no big deal since it's all test data) and it works again because all the sprocs are there. Last night less than half were there. I have no explanation.

BUT, I'm going to watch it to see if it happens again.