I haven't a clue how I got these collation differences but I am not too keen on using ReBuildM.exe. Presumably I would lose all my DTS packages.

I decided to try...

Nick, I am still stuck on this one. Hopefully someone will be able to help.

Stefan

Thanks for the link. I found an example at http://www.sqldts.com/default.aspx?245

I did not realise that Automation worked in exactly the same way in an ActiveX script as in VBA....

Thanks for that. I managed to change the collation on two small databases and everything worked fine so this is obviously on the right track.

However when I tried to change...

I did not make myself clear. The two collation examples I gave above were on the same server.

Would appreciate bit more guidance how I pull this all together.

"You may need to open a SQL connection and get the names using ado but insert them into an array...

The user databases have Collation Name:

SQL_Latin1_General_Cp1_CI_AS

TempDb has a collation name:

Latin1_General_CI_AS

I don't know how this happened as installation just accepted the defaults. How would I go about bring collation in line?

Bill, that's exactly what I wanted to do. Many thanks

No responses so seems this not possible. I will try a different way.

I recently tried to do something similar. I downloaded WZZIP the command line addon from http://www.winzip.com

The documentation for WZZIP is included in a help file type wzzip /?...

Hi Andy, I did not get the message above, and I certainly have not received 12 notifications in the last 7 days.

Rather strange. I am not aware of problems with...

QUOTE

Woudn't it be simpler to save it as char(31) ?

UNQUOTE

I have been thinking about it since writing my question, and I think that was the conclusion I came to....

I only discovered today by accident that there had been further replies and turning off the emoticons makes the site more usable.

However why am I not getting email notifications. I...

I wondered if there was anything I was missing. Have only recently started working with Windows 2000.

I guess that I was wondering where the catch was. But seems it as...

Sometimes I would want to update only one password, other times I would want to update all passwords.

In either case I would generate a random password.

I guess that I would...