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,...

j-1064772 (4/29/2016)

---

Sioban Krzywicki (4/28/2016)

---

I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's...

SQL!$@w$0ME (4/29/2016)

---

Hello guys,

I can't connect to a named instance(TCP/IP) through VPN connection. But I can connect to the default instance(TCP/IP) [highlight="#ffff11"]on the same server[/highlight] through VPN.

The named instance is...

it's not a one line fix; performance and query tuning and analysis, a have entire books written on the subject.

in general, my knee jerk reaction would be to update statistics...

just the drops scripts are pretty easy, you can just build the statements from sysjobs;

select

'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name + ''')

EXEC...

Sioban Krzywicki (4/28/2016)

---

I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all...

Sioban I'm with you here!

I try like crazy to make everyone replace reserved words, as well as fixing misspelled columns i inherited.

I have a column ProvdierType that makes me crazy,...