No rush. Please tackle it if you'd like.

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.

Ouch. I'm probably 0-4 then, US American, rooting for the Cowboys, Yankees, and Lakers since I...

Grant Fritchey (2/4/2015)

---

Nah, I hear he's a giant bag of wind and a bit...

You could implement your own SQLCLR function from the .NET namespace to handle larger values.

Could be parameter sniffing, perhaps a plan flush that compiled poorly the next time, it's not the index itself.

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...

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...

You always have scheduled tasks, so SQL Agent, while nice, isn't necessary for many things.

Doctor Who 2 (1/31/2015)

---

I agree with you Steve, but sometimes I wonder. Where I worked we had 18 years worth of data which I've maintained and advocated for years, should...

Cheers, my man. I'd buy you...

I think you'd be surprised at this. So many of...

Thought about that as well 😉

Glad you like it.

GA Programmer (1/30/2015)

---

I've commented often about this issue within our industry. I think the biggest problem is ourselves. We don't set down the proper expectations, so when they ask...

There is no landing, senior or not. There are only stops along the path of your career.

As you gain experience, and talent, you will have more, and fewer choices, but...