Jeff Moden (5/17/2012)

---

Heh... gotta give me some credit, as well. It took some stones of...

Incorrect. Your SQL Server name is the virtual name so I don't see a problem..

In the case of a named instance the SQL Server name is the virtual name...

MysteryJimbo (5/15/2012)

---

Elliott Whitlow (5/15/2012)

---

I did something like this recently. It was a straight SQL 2008R2 to SQL 2008R2 move though due to a hardware replacement.

I brought up the new...

I did something like this recently. It was a straight SQL 2008R2 to SQL 2008R2 move though due to a hardware replacement.

I brought up the new server with a...

Jeff,

You gotta give 'em cred for calling back that takes some stones.

CEWII

I like not having database services running on Server 2 however its not real hard to limit the attack surface of a SQL server that you are only allowing local...

ALTER AUTHORIZATION ON DATABASE::[database name] TO [login name];

CEWII

The last two technical interviews I had were tense only in the level of detail they wanted. But in both cases later they comment how relaxed I came accross....

I've only had this happen when I had a component that only looked like it was in the same container. I moved them around and it resolved the issue.

CEWII

I would use the data in an SSIS package using a ForEach Loop to perform the actions. I won't use Linked servers for this..

CEWII

Wendy,

You paint a very confusing picture.

You created a database. Defaults of not I doubt you did anything wrong there.

I am guessing you created it as a user with sysadmin server...

-Removed snarky comment due to what was posted while I was typing it-

CEWII

Your question is not easily answered.

There are a number of factors such as server sizing and resource utilization that come to mind first. If your server is large enough...

CptCrusty1 (5/11/2012)

---

Elliott Whitlow (5/11/2012)

---

Honestly I'm not sure this is possible.

Even if it were I have to say I don't think its a good idea. Just create a table in...

Same process, you need to GET the value and then you can USE the value.

You can then likely pass the value in as a parameter to the DFT source.

CEWII