Redgates tools are awesome, i ponied up and bought them for myself, but they are expensive.

on a cheaper note, if you've installed SSDT, you can easily use the built in...

I see you posted in SQL2008, you need to install the tools like SSMS and BIDS on your workstation from some production media, or from a 2008/R2 developer editions...

i'm pretty close to Jez's methodology; i've pretty much had one specific account for 90% of my proxy situations; it's mostly about accessing network resources. i tend to use that...

you probably need to simply join three groups of data together to create your view; it might be slow;

CREATE VIEW vwGeneralTransactionsMultiSite

AS

SELECT T1.Site,

T1.Trans_num,

...

my keyboard has a light to signify caps lock on or off, isn't that significantly easier than asking for one specific application to show it's status? just glance at...

carol can you simpyl test your users xp_cmdshell permissions? does this still give permissions errors?

EXECUTE AS USER='pvtreader' --test as our specific users permissions.

exec xp_cmdshell 'whoami'

REVERT; --change back into myself

I think the issue is you developed/created the package in a higher version of BIDs (or potentially 2012/2013 SSDT), right?

Pretty sure you created it in Visual Studio 2010, but the...

i put together this prototype;

basically, for every SQL server in msdb.[dbo].[sysmanagement_shared_registered_servers_internal], i'm creating a linked server for it, and passing commands;

my example is just running a fancy @@version++ inventory...

two ideas.

can you just use two jobs, one scheduled to start on Saturday, and repeat each two weeks?

can you use a datemath and inline logic within the job step to...

if the command is compliant with the other DBMS (mysql, oracle, etc,) then yes.

the ODBC...

some groups cannot be enumerated , I've seen that on my AD, where we have two forests of AD accounts with two way trusts.

I've found we've got a groups with...

if you are local admin, you probably want to do a takeover of the server,

then i believe you can at least add yourself via a dedicated admin connection...

Tac11 (5/3/2016)

---

Hi Lowell,

in the result header there are 2 columns 'date' and 'Start_time' what are these can you put specific column name? plus if I want to filter by date...

since you don't have the error yet, i'm leaning towards checking things that are different in the other environment, like ANSI_NULLS and QUOTED_IDENTIFIER.

maybe the procedure was compiled or is running...

i would add dates and whodunnit information to the history table as well. From what you have show so far, you cannot tell when it occurred, which could be important,...