Really?

http://www.sqlservercentral.com/Forums/Topic1127568-5-1.aspx

You are welcome.

CEWII

Craig Farrell (6/17/2011)

---

GilaMonster (6/17/2011)

---

Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get...

This is a very odd request.. And I think covered by every NDA I've ever signed.

CEWII

Let me see if I understand.. you are trying to install that BEFORE you install SQL? If so, you will NEVER succeed. It is a service pack...

Ok, here is some pictures of a package to do this that I threw together in about 5 minutes, adding the guts would have taken about 5-10 minutes more..

CEWII

Are the tables truncated first?

CEWII

bcmat (5/13/2011)

---

Hello. We are getting a new server with the following specs:

Dell PowerEdge R710

12GB Memory 1333MHZ

(2) Xeon E5503, 2.0GHZ, 4M Chache, 800MHZ, Max Mem Processors

We need to run SQL...

Its always fun when I get to use this statement.. It depends..

What you are trying to accomplish in a given sproc largely drives the choice. CTEs are good...

I would say linked servers is out, I can almost guarantee performance issues.

I like log shipping, SSIS, and replication. How many databases? How many tables? How current...

I would do this in SSIS it is very simple. I would absolutely NOT do it over linked servers, you will see orders of magnitude performance increases in SSIS....

How about:

EXEC master.dbo.sp_addlinkedserver @server = N'SERVER_2005', @srvproduct=N'SQL Server'

CEWII

I would tend to agree, it feels like a defect. I'd check Connect and see whats there..

CEWII

So whats the question? The problem? What you are trying to solve?

CEWII

And then won't let you change it...

CEWII