SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

This is what I see in event veiwer nothing else,

Permission is not the issue, as this account is local admin and sql system admin account other jobs are running fine with this account, I tried another power account too...

Thanks a Lot, Actually I configured everything fresh, created Operator, added a profile in SQL Mail and then configured the SQL agent to enable the mail for the specific profile,

Thanks...

I can get a test email from Database Mail no problem, bit not the job faliure

as mentioned I aqm not using data mail

No i do not, i get in other servers, is ther any script I can dreaft it of this procedure to test

I am using this,

USE [msdb]

GO

/****** Object: StoredProcedure [dbo].[xp_sendmail] Script Date: 11/20/2012 10:27:08 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Create PROC [dbo].[xp_sendmail]

@recipients varchar(max) = NULL,

@message varchar(max) = NULL,

@query varchar(max)...

can I please get a script

I have restarted the agent, I am using notification for job faliure

Thanks a Lot

Could you please let me know how the index is related to the table, I mean if the table is used quite often, How the index size works,

Thanks for your help

Hello,

I need a statement which I could run once and it would genertate the information for all the users existing in SQL with the type of permissions,

Much Appreciated,

Thanks,

Dev

I restored the database from primary server to the secondary, and enabled the log shipping, I am getting the below error,

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator...

say I am want to replicate tset data on server A as primary to Server B as reporting, where I need to configure replication please