I don't want to start anything, just trying to get info. I'd like to stay with a SQL query.

It's processed from a package on our job server to the upgraded server. The settings are currently default for the analysis server processing task editor object in the package....

Thanks, I think I can work with that.

Basically, I'm trying exec sp_trace_setstatus from 1 server to all the rest.

I should've mentioned that earlier, yes the sp_trace_setevent was a part of the script.

example:

exec sp_trace_setevent @TraceID, 12, 11, @on

exec sp_trace_setevent @TraceID, 10, 11, @on

LutzM (4/19/2014)

---

Why don't you just use a conditional split with a left outer join to the table holding the primary key. Check for NOT NULL of the PK value and...

Will try, thanks.

I'm executing a package on server 1 that runs a query on server 2 for job history and inserting results back to server 1. The table being inserted into...

Yep, every data type I try it tells me to try another. I try int it tells me nvarchar, I try nvarchar it tells me int, grrrrrr.

MyDoggieJessie (3/5/2014)

---

Check the data type for your last parameter, per the link below it needs to match the value in the trace that you are looking up (which in this...

Good advice, I will follow it, thanks.

Lowell (2/24/2014)

---

SQLHeap (2/24/2014)

---

So, I have this developer that created a job on a dev server that executes a number of ssis packages that I handed over and he/she didn't change...

SQLRNNR (2/24/2014)

---

The best method for that is to have the prod database servers segmented away from the dev servers via firewall/router. Then have firewall rules preventing access between dev...

I am seeing the same when declaring a variable table to use with a cte in openrowset. Have you made any progress on this?

I forgot about CMS, thanks. I'm still not sure how to execute an SP to a CMS group through a job schedule.