it does work extremely well if you take the time to get to grips with its parameters

karthik -450760 (4/21/2010)

---

Ahhhhh.. :w00t:

I tried to login to the server through Remote desktop connection and I got the error message ,

" The account is configured to prevent you from...

is why I suggested login to server if account or domain is...

My reply says logon to the server not SQL server 😉

the best way to check an accounts validity is to logon to the server, true it doesn't have to be...

firstly logon to the server with the account details and verify success.

Next, change the service account info and enter the new password via SQL Server configuration manager

Subversion is a great source control product, highly recommend it!

Couldnt agree more! Litespeed or SQLBackup are both great products.

Redgate offer generous discounts too which make the product affordable and it has great features. I use it and recommend it!

if you only want a 2 node cluster Std edition should suffice. You will lose a few other features but its still an option

to further my point and using Pauls kind example

the following would fail and hence, would only allow a single NULL value

USE tempdb;

GO

CREATE TABLE dbo.Parent

...

sorry my bad that is only for SQL 2005 onwards

just out of interest what version SQL server are we talking here?

WayneS (4/20/2010)

---

I was just thinking about...

mate, your keen this thread is over a year and a half old 🙂

are you seeing this on all databases that are having indexes rebuilt??

run this on each server and it will create an alter login script with the old password

select 'alter login [sa] with password = ' +

sys.fn_varbintohexstr(password_hash) +

' hashed' +...