Probably. I'm not sure it hurts to be there, but I can understand it being annoying.

If you open a case, would like to know how you remove it.

So can you post all the code? REPLACE by itself doesn't change things. You would have to do this:

update mytable

set col011 = replace( col011, CHAR(10), '')

are there quotes in the name of the server?

Maybe this?

sp_dropserver '''ServerA; UID=DEVAccount;PWD=DEVPwd'''

Sorry, I'll ask some people if they have other ideas.

Are you saying this doesn't work?

replace( col011, CHAR(10), '')

http://msdn.microsoft.com/en-us/library/ms186862.aspx

SQLRNNR (6/23/2011)

---

They are?

Truncate = D R O P T A B L E

Delete = D R O P T A B L E

I don't...

Just so we're clear, we're not talking about any user. XP will work fine for client applications. It won't run the SQL Server tools or dev edition.

Try this:

sp_dropserver '[ServerA; UID=DEVAccount;PWD=DEVPwd]'

AFAIK, the code is

sp_dropserver 'Servera'

No need for the name and pwd. You just include the server name as a drop or an add.

http://msdn.microsoft.com/en-us/library/ms174310.aspx

You wouldn't use Red Gate's SQL Source Control instead of TFS, it's a "with TFS". The RG product integrates almost any VCS with SSMS so you can check in/check out...

Eric M Russell (6/23/2011)

---

Regarding the client tools specifically (SSMS, BIDS, DAC, etc.), if the user's version of Windows has the latest .NET framework installed, then it shouldn't matter what version...

roger.plowman (6/23/2011)

---

Bah. Steve, with all due respect, you're part of the problem. The fact is XP *DOES NOT WORK* anymore. Why? Security! It's out of support, meaning no more security...

In the properties for a services in config manager, the first tab as a Log On As and a "Use this account" with a browse button. You just pick any...

It's not a bug or a flaw, it's logical order. the distributor is the highest in the chain, and it requires upgrading first. If the publisher goes first, the version...

I like plumbers. They seem to do a better job than I do at hooking pipes together