True, but as the original poster pointed out, you still need ALTER rights at the...

EdVassie (3/14/2008)

---

My take is that if the Windows admins want it moved for existing installs, they need to show the costs, downtime, risks and benefits involved in the move. ...

If they are admins, you can strip away permissions, but typically administrators have access to everything. The multiple layers of security required to make this work wouldn't be very feasible....

Yes, hardware load balancer, such as with an F5 BigIP, Cisco's load balancer, etc. In those cases the load balancer would have to be configured to maintain state.

I've not seen that. Do you have audit success and failure both turned on? If so, does it indicate a difference in the login names when you connect via RDP...

It's been a few years when we had that coversation with MS and the basic gist was, "We'll be more than happy to put resources on site to assist, and...

Here's your firepower for new hardware and a new setup:

How to move a Windows Cluster Server from one domain to another

Right near the top:

Note We do not recommend performing this...

From a security perspective, there's usually an argument against registering SQL Server databases and publications in AD. Anyone with read rights (basically most every authenticated user) can locate the information,...

A follow-on article discussing the networking config (heartbeat, public), would be ideal. Sometimes this configuration can cause a fail-over unexpectedly. I've got that t-shirt.

Engineers are very much alike, whether they are in the traditional engineering fields or are "system engineers" and whether or not they have the title or not. Give 'em enough...

Aye, on SQL Server 2005, database mail is the answer, as Joe has indicated. If you're on SQL Server 2000, or you are using SQL Mail on 2005 (you shouldn't...

You can do it that way, script and re-run, or you can just use sp_changeobjectowner for each object and see what breaks and then fix those up as you encounter...

paule (2/20/2008)

---

SQL 2005 newbie here dealing with this issue -

1. How would I use SQL Enterprise Manager from a remote location with Windows Authentication? I thought the only...

The stored procedure sp_changeobjectowner can do that. However, is your server SQL Server 2000 or 2005? Changing the owner will break any object references for stored procedures and views which...

Here's a second on the pocket guide. It was the first SQL Server 2005 book I picked up and it was more than worth the price.