This post explains it a little more

http://www.pluralsight-training.net/community/blogs/jimjohn/archive/2008/03/23/50536.aspx

MarvinTheAndriod (10/12/2010)

---

Thanks. Ran the T-SQL and it generated the following script:

ALTER LOGIN [SA] WITH PASSWORD = 0x01004086ceb66433e82f3f8946c27e33641a8179e4ad419c5811 HASHED, CHECK_POLICY = ON, CHECK_EXPIRATION = OFF

But it still generated the same error:

Incorrect...

MarvinTheAndriod (10/12/2010)

---

Lowell (10/11/2010)

---

i see what you were refering to...if you run sp_rev_login with no parameters, every login EXCEPT sa is scripted.

if you pass a specific login name, it gets scripted...

Markus (10/12/2010)

---

Microsoft pushes Clustering as the next best thing to sliced bread. In my experience we have had more downtime with clusters than with a regular server. Clusters...

can you post details of the query you are using?

The Redgate compiled help manual in your Redgate client install directory also has full details how to do this. Search the manual for either the "CONVERT" command to use command...

This has all changed between versions SQL Server 2008 and SQL Server 2008 R2

which edition are you using?

Licensing all physical CPU's in the Host machine at Enterprise level in 2008...

That's the steps you need to follow

Halcyon (10/11/2010)

---

via right click...

Create a clustered DTC resource and put it into the same resource group as your clustered SQL Server instance.

Then create a mapping to the DTC resource for the SQL Server...

Duran (10/11/2010)

---

Hello,

Just to be clear, if I have 5 SQL instances on a cluster, I'd need 5 separate drives, each with their own drive letter? 5 SQL instances cannot put...

what are the severity and state values for this message?

Shared disk arrays can take many different formats. You could have a linux based server with disks shared over iSCSI, you may have a storage area network using fibre channel...

you will need new disk resources to install the SQL 2008 instance, you wont be able to share the SQL 2005 disk resources!

Yes for a clean shutdown, the domain controller (which I guess is...

Go into failover cluster manager and expand the cluster. Right click Storage and select Add Disk!