It looks like i have a new version of the data tools.  It does not look the same as earlier in the week.  Someone has some explaining to do.

I am assuming the logs should be in

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log

However there is nothing for yesterdays date.

figured it out, set the service account in the sql configuration manager.

It looks like the account for sqlserver agent service was changed.

When I execute the following, I see the account as xxxxx@charteroak.edu instead of NT SERVICE...

I think the problem is that it changed the log on account from nt service\sqlserveragent to the account the person was logged in under.

How can I change it...

My understanding of SQL security is somewhat limited, but I am trying to get a handle on it.

Yes, I think I would probably want to deny select...

Well it that makes complete sense! For some reason I did not think I could look at two different columns in a case statement. Thanks so much!

I found in our event viewer on the server a whole bunch of back up errors un-related to my SQL backup. I had done some digging and found that...

Did you find a resolution to your restore problem. I am having the exact same issue. This worked fine for years, just noticed it in the last month...

Thanks so much! I will check this out.

I probably shouldn't, seeing that is one supplied by our erp provider. I may create a sproc that the user runs instead.

The stored procedure is a standard proc used for different circumstances. I prefer to have a trigger execute the insert