I get error at step 7. When I try to preview my data I get following error.

Error at SQL_Overview_Package [Connection manager "MultiServer"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB...

I get the below error at Step7.

Error at Central Pacakge Database Properties [Connection manager "MultiServer"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005....

none of the options provided are correct for identity col(-1,1)

the correct answer is (-1,0,1)

Please check before you post.

Thanks

We had a similar problem. Integrity check was working fine then one day it started failing with the error mesage

"Alter failed for Server '<servername>'. "

in Maintenance Plans | View...

Good work mate.

Works good for me.

Thanks

I get the following error when i execute this script. Thanks for the script.

Msg 102, Level 15, State 1, Procedure sp_who3, Line 3

Incorrect syntax near '?'.

Msg 102, Level 15, State...

You can get the mapping and securables imported through the script. I tested it on my production server and i didn't had any problems and even my encrypted password logins...

When you right click on the database->tasks->generate scripts

script wizard opens up and u can select the database where u want to script the logins and in the second window set...

Thank you very much for the reply.

I have fixed it. In SQL 2005 we can actually script login along with their securables. I have scripted the user and his roles...