Viewing 15 posts - 1,936 through 1,950 (of 7,164 total)
Check that the Windows account you're using to log into the SQL Server with has a login and permissions to select from that table on the remote server. If it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 15, 2013 at 9:17 am
winmansoft (2/15/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 15, 2013 at 8:48 am
Carl Waitz (2/15/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 15, 2013 at 8:43 am
It sounds like you are looking for a "Web Service Destination" Component inside the Data Flow Task but you will not find one there. How you might deal with it,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 15, 2013 at 5:21 am
Have you looked into the Web Service Task? If so and you found it lacking can you describe more about what you are trying to do?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 4:53 pm
bcp exporting to a csv file is used all over the world and probably will be for a very long time. bcp is obviously not as robust as SSIS since...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 4:47 pm
The need is far less than in previous versions, especially SQL Server 2005 running on Windows Server 2003. Personally I will not enable it unless I am seeing specific symptoms...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 4:27 pm
Any idea why this would happen or how to troubleshoot this?
No way to tell from here. Please post the Actual Execution Plans for all three queries.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 3:35 pm
zi (2/14/2013)
I enabled the trace stop time, but still the import performance data is disabled (gray)
any idea why?
Thanks
Not trace stop time, the starttime and endtime event data...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 2:34 pm
By the way , for my workstation developer instance, I use local account, like local system of nt service account, does it automatically register SPN, I never did that on...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 2:23 pm
Bill (fluffydeadangel) (2/14/2013)
It would be if our org didn't disable the standard trace to setup a custom one.
That's horrifying. At worst a "custom" default trace should be a superset containing...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 1:54 pm
Is the register spn a necessary step for SQL service account?
It is if the SQL Server service is being run as a domain account and you want clients to be...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 1:52 pm
MyDoggieJessie (2/14/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 10:55 am
MyDoggieJessie (2/14/2013)
midnight251 (2/14/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 10:42 am
midnight251 (2/14/2013)
Great info thanks. What would a sensible size be, 50 gig?
It's mostly a guess. The only way to know for sure would be to capture the output of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 10:11 am
Viewing 15 posts - 1,936 through 1,950 (of 7,164 total)