Category: 2008
SQL Agent Jobs - Non Maint Plan
03/20/12 10:20, by admin, Categories: SQL Server, 2008, 2005 , Tags: ms-sql, sql 2005, sql 2008, sql agent jobs While doing some development found a need to find non-Maintenance Plan Jobs for doing some reporting. After couple minutes searching Google and some other sites, there is a huge lack of information or queries that effectively show how to obtain or tie s… more »
Acquire SQL Service Account
02/14/12 05:40, by admin, Categories: SQL Server, 2008, 2005 , Tags: sql agent service account, tsql, xp_instance_regread LinkBack: Found this nice little code snippet for researching the SQL Agent running account. Left a linkback to the original site, but it was seriously laggy due to some backend stuff.DECLARE @SrvAccount varchar(100)set @SrvAccount =''… more »
Linked Server....
Well today, I started the fun filled adventure of managing data from/to a LinkedServer.
During this learning curve, I found plenty of information about how to query from and instert into a Linked server but most of them utilized the OpenQuery TSQL Sta… more »
Maintenance Plan history
I have been researching for the last couple of weeks a way to acquire a maintenance plan job history, success or failure.After alot of searching and finding that no one has or is not sharing the ability to do this, I decided to start hacking away at… more »
XML Feeds
