No downtime, but you could experience a performance degradation and blocking while the command runs.

Register all the servers in SSMS, right click the server group and select "New query".

Run sp_password.

However, I wouldn't set the same password on all the servers, as Lowell pointed out.

Jack Corbett (11/21/2011)

---

Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I blogged about it, http://t.co/hCjjRnRh if you...

Koen Verbeeck (11/21/2011)

---

I kid you not.

I'm even surprised myself 🙂

We even had an Indian Summer that was better than the...

50 days without rain???

In Belgium????

You must be joking. :hehe:

-2 °C This morning here.

And Italy is supposed to be one of the warmer countries in Europe...

You can set up a linked server to your Exchange using this:

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

Hope this helps

Gianluca

SELECT SomeColumn

FROM SomeTable

WHERE SomeDateColumn BETWEEN '20110901' AND '20111031'

You'll need something that parses the request e-mail, queries the database and replies with something like Database Mail.

I'm not aware of any tool that does this out of the box.

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1209021.aspx

Couldn't resist...

And congrats from me too!

Almost forgotten: wrap that code into a transaction!!!!

Drop the column and re-create it.

Here's an example:

CREATE TABLE #test (

id int identity(1,1) PRIMARY KEY,

name nvarchar(50)

);

ALTER TABLE #test ADD new_id int NOT NULL; -- Remember NOT NULL, otherwise you...

Grant Fritchey (11/18/2011)

---

Gianluca Sartori (11/18/2011)

---

Another way could be using a loopback linked server and execute the procedure as a pass-through query: http://spaghettidba.com/2011/11/16/discovering-the-output-of-dbcc-commands/

The technique described there uses DBCC commands, but it...