I told you it has value outside of...

Steve Jones - Editor (12/26/2008)

---

Lynn,

Not sure if this applies, but check pathing in your setup files. We had an issue with Sp3 and multiple instances in SQL 2000 where we'd...

Jack Corbett (12/26/2008)

---

Lynn,

I did see your post about the registry issue, but I knew I had seen the command line install instructions somewhere so when I saw it, I figured...

Jack,

Actually, no I haven't. A friend of mine did some research and it seems that there have been a few others that have had similiar issues with a multi-instance...

How about a logical explanation? REPLACE is changing an unknown number of characters in the target string(s) whereas STUFF is adding a known number of characters at a specified...

[font="Arial Black"]

Merry Christmas! Happy New Year!

Our thoughts and prayers with all those who are serving our country in foreign lands and our away from family and friends this season!

My...

And you seem to be missing the point as well. When using REPLACE to create a table using SELECT INTO, how does the function know how long the longest...

On this note, it should be known that Books Online...

A select statement won't start a distributed transaction unless you are explicitly starting one.

We had that issue with linked server queries as well. You need to search this site...

Any updates over a linked server requires a distributed transaction, using MSDTC. There is quite a bit of overhead involved using a distributed transaction, and that is what contributes...

Time depends on your hardware. Once applied, the only way to back out is to uninstall and reinstall RTM.

Okay, I think I'm onto something, just not sure what or where it is heading.

This is from the Hotfix.log file on DWDEV02 where the install worked:

12/18/2008 19:44:39.656 Copy Engine: Creating...

Jeff Moden (12/19/2008)

---

Lynn Pettis (12/19/2008)

---

Okay, hows this??

create table #MyTest (

CompanyName varchar(50),

CompanyID varchar(10),

RegionID char(2)

);

insert into #MyTest

select 'ANDERSON DAIRY PRODUCTS...

Not a problem. I appreciate any help that I am getting.

I may be onto something myself right now finally!

Stay Tuned.........

There isn't a C:\Tools directory on either server.