Hello,

May be take a look at this article: http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/

I would suggest first concentrating on the sections Day-to-Day, Security, Job Maintenance and Performance Monitoring.

Regards,

John Marsh

Hello,

Glad to hear my suggestion solved your issue.

Best regards,

John Marsh

Hello,

It could be a permissions issue. Did you try testing with the SQL Agent running under a Domain Account?

Regards,

John Marsh

PS: This MSDN article specifically recommends using a Domain Account rather...

Hopefully this link will help:

http://msdn.microsoft.com/en-us/library/ms161959(SQL.90).aspx

Assuming that is the issue then I found this on an MSDN blog:

Q: I keep getting messages about my password not being acceptable when...

Hello,

I am glad to hear it was what you needed.

Best regards,

John Marsh

Hello,

I assume you want to grant DB access to Logins that already exist – correct?

In which case highlight the DB in Enterprise Manager, Select Tools from the Menu Bar, then...

Hello,

The indexes are rebuilt to reflect the FillFactor specified (or the original FillFactor if none supplied). So that doesn’t necessarily mean an increase in FillFactor.

Take a look at the following...

Hello,

As an alternative, you could do this with .Net, but it would be a fair amount of work.

I am just wondering why you don’t want to use DTS, as that...

Hello,

Glad to hear that you are now getting the results that you need.

Best regards,

John Marsh

Hello,

Try changing your query as below and see if that is closer to what you need.

It would still need a bit of work to get the Month and Employee Names...

Hello,

If you don’t already have them saved as Scripts, then I would script them from Enterprise Manager (it allows you to script all local jobs in one go) and run...

Hello Again,

I would suspect that the Where clause is filtering out the required records.

Can you try commenting out the Where clause, except the check on the Year, and see if...

Hello,

If you use a Right Outer Join on dimDate, that will get you all records from dimDate even when there aren’t any matching records in the (Alias) fSP Table.

As...

Hello,

I don’t believe you can change the password without knowing the old one i.e. you would have to reinstall SQL Server.

The following is Microsoft’s work around for fixing your Login's...

Hello Again,

It looks like the Login “RUY\Rui” is effectively locked out because the Default DB associated to it either does not exits, or the Login does not have the right...