Viewing 15 posts - 1,936 through 1,950 (of 7,168 total)
For one, convenience. I change my default DB sometimes so that when I connect I am dropped into the DB I use most often. When I setup new developers with...
February 15, 2013 at 9:42 am
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...
February 15, 2013 at 9:17 am
winmansoft (2/15/2013)
February 15, 2013 at 8:48 am
Carl Waitz (2/15/2013)
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,...
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?
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...
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...
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.
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...
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...
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...
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...
February 14, 2013 at 1:52 pm
MyDoggieJessie (2/14/2013)
February 14, 2013 at 10:55 am
MyDoggieJessie (2/14/2013)
midnight251 (2/14/2013)
February 14, 2013 at 10:42 am
Viewing 15 posts - 1,936 through 1,950 (of 7,168 total)