Generally its a good idea to specify the RAM max when using more than 16GB and using the memory options. Colin has pointed that out correctly.

with the distribution transaction you will also need to specify SET TRANSACTION ISOLATION LEVEL SERIALIZABLE else it will result in a error.

Yes Dave i do agree few things in 2005 are complicated rather than being simplified. One such example is the log shipping role change thati have already pointed out. I...

For other new user Dbs you can make the default path by configurin that in config manager.

Why can't you use the Generate Script that is readily available to you in SQL Server.

Yes two instances of SQL Server in one cluster group is possible.

is /PAE switch added to your boot.ini file for 16GB or more memory you have to add the switch to have memory managements process.

Nothing to be nervous just take a backup and then fire the shrink task. But remember to give some amount of free space at the end.

run this command

sp_change_users_login 'report'

if the user lists in the output then run the following given below

sp_change_users_login 'update_one','username','username'

this should ix your problem.

You can use the import/export option to import to sql server the data can be imported.

Better name the database so that its meaningful else there will be n numbers of confusions around after few years.

If you are planning to use the same query and display results often the my idea would to use EXCEL-> import external data->New database query and place the query there...

There is no constraint of number of databases that can be used in log shipping in a single server. But the server hardware and network should hold desirable limits to...

If i have misunderstood let me know and apologises too.

Is you req

you have 126 SPs in a database and need to move these into 6 other databases.

if so script the SPs and run against the target servers.