Fixing Maintenance Plan Error code 0x534

This article shows you how to resolve SQL Server maintenance plan execution failure error

Cleanup Older than 30 days of Files & Folder through SQL Job

Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job

SQL Jobs

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.

Select the last error in the job selected

The job will send an HTML email with the latest error at specific job.

Let's Talk Ownership (and SQL Jobs)

It seems that the ownership of jobs is something that is often overlooked when articles explain

Runaway Job Management

Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.

MSSQL Job Monitoring Simplified using Simple Query

This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.

RE: Which encryption method(s) have the best performance?

Which VPN? I'm not sure the overhead is substantially worse in one v the other. I'm sure a hardware VPN works better than PPTP in software, but bandwidth is likely the big limiting factor. What type of connnections do you have?

error 7390 when isolation level is set to serializable...

I am trying to replicate the execution of a stored procedure and hence am using isolation level of serializable as recommended by BOL for purge operations. This following code works fine when executed on the server ( logging in via terminal services) bu gives me an error when executed thru Query Analyzer. Really puzzled. ________________________________________________________ […]