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

Skynet

Can you try this?

- Create a new user in AD, no rights.

- Use SQL Config Manager to assign this user as the service account.

- Restart SQL Server.

This help?

http://sql-articles.com/blogs/enable-disable-remote-connections-via-dos-or-t-sql/

Did that article fix things?

Is there a check requiring the change of the password on login?

Clustering involved?

declare @report_instance nvarchar(50)

select @report_instance =

case

...

If you are just a MS shop, TFS has some nice SQL and VS integration. I might also look at Git/Mercurial as well if you are distributed at all.

Good comments, and a heated debate, and please try to remain courteous to others.

@djackson 22568 - Great points about the fines going to government. That's not a solution. Perhaps a...