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

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

...