I think it is possible as it is based on backup and restore. Instances involved in log shipping should have the same case sensitivity settings.

Agree with RBarry. Adding datasource will resolve issue.

How your page file setting is? Please refer http://support.microsoft.com/kb/889654 and see if you have set up correctly.

You are doing in right way by executing Alter table command.

My recommendation would be to put your alter table command in SQL Server Agent T-SQL Task job. You should...

While explaining please make sure you mention sql server version too.

Output of sp_configure indicates that you have not limited max memory setting for SQL Server.

max server memory (MB) 16 ...

setting "Both failed and successful logins" thru Management Studio will do same as changing registry directly.

Yes, restore is good if you can manage with one day older data or whatever gap you have between backup and restore. Secondly, if your database is not very large...

you should ask your Windows Admin. they are supposed to provide you this.

It is possible if you have "Both failed and successful logins" enabled.

If you are using tmp9.tmp file anywhere in your DTS then refer http://support.microsoft.com/kb/912911

otherwise you may have to refer suggestion posted by Adam.

There is no list to say why server went down. Every time you may have different reason.

I am not sure what it would be in case of MYSQL. I thought you are asking in SQL Server.

set identity on your primary key field. If you want number to start with 1 and increment by 1 at every insert then in your case it should be:

ProductNo decimal(50,0)...

execute select * from sysindexes where name ='PKCURSOR' to see whether you have PKCURSOR already in your database or not. Please do this before you try to run script mentioned....