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.

Are you getting an error? If so, what error. If not, what is the result you are getting, and what are you actually looking for?

Steve Jones - Editor (12/19/2008)

---

We can argue about whether an indexed view should be a type of index or not, but right now MS is choosing to call it that....

Is there a way to run the service pack install from the command line and have it update only a specified instance, either the default or a named instance?

I'm wondering...

But if you read the documentation, SQL Server will use the index on an indexed view when querying the base table if it the optimizer determines that it would be...