I restarted SQL Server Service.

It is at 0% recovered. Not moving.

The Transaction Log Backup is 145 GB. Tried shrinking it but it did not make much of a difference.

They tried canceling the Query from SSMS and closed the window so...

abendigeri (10/25/2013)

---

@Welsh,

Thanks,

I agree, but thats the environment:-)

There are no open transactions...But when i run DBCC opentran its says, one open transaction is there and the SPID is 66s !

I have...

I would be interested in finding out what it takes to resolve this issue.

Your Network Team should not be restarting SQL Server without consulting with the DBA.

You want to make...

I was able to perform Test Database Mail without any problems.

I right clicked on SQL Server Agent > Properties >; Alter Settings > Clicked on the Alert Systems Tab. I...

if @RecCount > 0 begin

Msg 156, Level 15, State 1, Procedure usp_JobStepFailedAlert, Line 27

Incorrect syntax near the keyword 'if'.

I wish that I knew why my jobs are not sending Job Notifications?

I am the...

It appears that the permissions need to be granted the SQL Server Service Account.

I thought that it was an issue with permissions on the SQLServerAgent Account but it is the SQLServer Service Account.

I will take steps to resolve.

It should work.

When I attempt to create a backup device I get the following error:

Cannot verify the existence of the backup file location. Do you want to use the backup file location...

Dumb question but how do you post an execution plan from start to finish?

Thanks.

J Livingston SQL (10/11/2013)

---

Welsh Corgi (10/11/2013)

---

I'm sorry but Proprietary information would be disclosed if I posted the execution plan.

So consider this post closed.

btw, it is slow for EVERYONE except the...

Thanks!

I'm sorry but Proprietary information would be disclosed if I posted the execution plan.

So consider this post closed.

btw, it is slow for EVERYONE except the developer that created the view....