Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

sqlagent - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » sqlagent (RSS)

SQL Server 2008 Policy Based Management - managing and troubleshooting policy failures

Policy Based Management (PBM) is an effective system for DBAs to manage one or more instances of SQL Server. Just to give a brief overview of what it consists, it consists 3 components: Policy management for Administrators to create policies Explicit...

SQL Server 2005 xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

Usage of SQL Mail is quite common within SQL Server environment, recently I have involved at one of the client's site with the error: Msg 17930, Level 16, State 1, Line 0 xp_sendmail: Either there is no default mail client or the current mail client...

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Is there a way of recylce the SQLAgent.out file in SQL Server 2000 and SQL Server 2005?

You may be aware about SP_CYCLE_ERRORLOG from older SQL Server versions, this will only take care of SQL Server error log and not with SQLAgent error log. So the question is there any way out to recycle the SQLAgent log file too without restarting this...