Viewing 15 posts - 16 through 30 (of 102 total)
I don't want to start anything, just trying to get info. I'd like to stay with a SQL query.
April 15, 2015 at 11:00 am
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....
October 28, 2014 at 6:42 am
Basically, I'm trying exec sp_trace_setstatus from 1 server to all the rest.
October 6, 2014 at 8:00 pm
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
June 17, 2014 at 12:01 pm
LutzM (4/19/2014)
April 19, 2014 at 1:15 pm
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...
April 19, 2014 at 12:45 pm
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.
March 5, 2014 at 12:53 pm
MyDoggieJessie (3/5/2014)
March 5, 2014 at 11:54 am
Good advice, I will follow it, thanks.
February 24, 2014 at 8:52 am
Lowell (2/24/2014)
SQLHeap (2/24/2014)
February 24, 2014 at 8:27 am
SQLRNNR (2/24/2014)
February 24, 2014 at 8:24 am
I am seeing the same when declaring a variable table to use with a cte in openrowset. Have you made any progress on this?
February 18, 2014 at 4:36 pm
I forgot about CMS, thanks. I'm still not sure how to execute an SP to a CMS group through a job schedule.
February 11, 2014 at 11:45 am
Viewing 15 posts - 16 through 30 (of 102 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy