Search my blog
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
283,436-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
- Find the SQL Server Instance name using Task Manager
- The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
- Script to check database user permissions
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: sql agent
SQL Server Agent does not start | ‘(Unknown)’ is not a member of the SysAdmin role
Last week on one of the SQL Server 2000 instances, the SQL Server Agent service was not starting. This server was on the same domain in which the SQL Server Agent was connecting to SQL Server using sa login and … Continue reading
Posted in SQL Agent, SQLServerPedia Syndication, Troubleshoot
Tagged services, sql agent, troubleshoot
1 Comment
xp_sendmail: Procedure expects parameter @user, which was not supplied.
On one of the Production instances a job which sends the details of blocking sessions was failing. This is the same instance which was rebuilt on Tuesday. On checking the job history, it was found that the job was failing … Continue reading
Posted in services, SQL Agent, SQLServerPedia Syndication, Troubleshoot
Tagged configure, services, sql agent, troubleshoot
1 Comment


RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare