Category: General

This category contains general information relating to SQL Server

SQL: Error “Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.”

Back in June 2014, I discovered a SQL Server Agent job that was failing with the error “Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed”. It turns out that the person who set up the job did not have sysadmin rights. I changed the owner of the job to a sysadmin user, and now it works 🙂

SQL: Red Gate’s SQL Search

Hi. I have just downloaded Red Gate’s FREE SQL Search tool from http://www.red-gate.com/products/SQL_Search/index.htm Features: Find fragments of SQL text within stored procedures, functions, views and more Quickly navigate to objects wherever they happen to be on your servers Find all references to an object Integrates with SSMS Why use SQL Search? Impact Analysis You want […]

Page 1 of 212
CJayMead's SQL Server, Endeca, MS Office Help © 2018