move logins from a sql 2000 server to a sql 2005 server

Hi guys,
I have tried to use the sp_help_revlogin script to move logins from a sql 2000 server to a sql 2005 server. It works for users that have a password. But if the password is blank it will fail. Is there a work around for this since I can't change the users passwords?
I have also tried SSIS package but that too doesn't work because of the same reason.

Can anyone help...

Users MUST have a password in SQL 2005. You will need to change the logins to have a password.

Move Images (BLOBs) from MSSQL to a folder

Hi Guys.

I have a MSSQL database of 2 gigs which has about 100mb of data, the rest is images.

I have noticed a huge decrease in performance as more images are entered into the database (most images are about 1mb).

I would like to know if there is a way to extract the images from the database and move them to a folder on the server.

Does anyone have experience or suggestions as to how this can be done?

Regards

VVOLTT

Quote:

Originally Posted by vvoltt

Hi Guys.

I have a MSSQL database of 2 gigs which has about 100mb of data, the rest is images.

I have noticed a huge decrease in performance as more images are entered into the database (most images are about 1mb).

I would like to know if there is a way to extract the images from the database and move them to a folder on the server.

Does anyone have experience or suggestions as to how this can be done?

Regards

VVOLTT

Before doing something like this, make sure that your SELECTS are optimized so that they don't pull images unnecessarily, and that your tables are properly indexed. Try taking a look at the execution plan for your slow queries.

The easiest way to do something like this would be to create a simple interface to query each row, and then write the data to a file.