Viewing 15 posts - 10,006 through 10,020 (of 39,769 total)
Supposed to be 50s the next week. Getting warmer in the mountains as well, which sucks. Supposed to ski this weekend.
February 10, 2015 at 1:00 pm
That suggests to me that it's security somehow. The linked server can be set to use multiple security contexts, different than you in SSMS or SQL Agent. I'd look there.
February 10, 2015 at 9:33 am
Use one of these scripts: http://www.sqlservercentral.com/search/?q=bcp+all+out&t=s&sort=relevance
BCP is the fastest way. I have a script up there to export all tables. There are corresponding scripts to pull all the data in.
February 9, 2015 at 4:53 pm
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Ouch. I'm probably 0-4 then, US American, rooting for the Cowboys, Yankees, and Lakers since I...
February 9, 2015 at 10:24 am
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag of wind and a bit...
February 9, 2015 at 10:17 am
You could implement your own SQLCLR function from the .NET namespace to handle larger values.
February 5, 2015 at 8:28 am
Could be parameter sniffing, perhaps a plan flush that compiled poorly the next time, it's not the index itself.
February 5, 2015 at 8:27 am
Are you calling the linked server the same way directly and through the SP? Meaning same security context? Check the SP doesn't have any execute AS.
Linked servers get tricky because...
February 2, 2015 at 12:11 pm
It's in the registry, IIRC. However, if there are overriding parameters in the services applet or however the service is started, they should take effect.
If you restarted, I can't imagine...
February 2, 2015 at 11:49 am
You always have scheduled tasks, so SQL Agent, while nice, isn't necessary for many things.
February 2, 2015 at 10:46 am
Doctor Who 2 (1/31/2015)
February 2, 2015 at 8:30 am
Lynn Pettis (2/1/2015)
... Mark one off, 26 days on the calendar to go. 26 days on the calendar to go, 26 days to go, ...
Cheers, my man. I'd buy you...
February 2, 2015 at 8:28 am
David.Poole (1/31/2015)
Real DBAs script things because their tasks have to be reliable and repeatable across many environments. Ditto rollback activity.
I think you'd be surprised at this. So many of...
February 2, 2015 at 8:27 am
Viewing 15 posts - 10,006 through 10,020 (of 39,769 total)