Can you post the error messsage that you see in the copy job history. Are you sure the log shipping is succedding everytime and restoration is happening as it should...

Can you post the properties of the login. Either from SSMS or from syslogins view.

Give permissions to SPs in that database and not in all databases. Might be the syntax i have given is wrong check that and fire the right syntax.

If that's the case then script out the logins first, then the database user and finally the object level permissions. Then run against the target server. It good to get...

Yo can use the isnull command and maipulate with that.

You can look for the option of import/export kind of backup in ORACLE is you are a novice there. They are easy to implement where as other kind involve few...

Change the mode to 90 so that you can get a full features available else you will be limited using the sql 2005 features.

One thing that comes to my mind is create a batch file that sends you a message and the service failure and put that bat file to run on the service...

You can script all in the same file and run against the target server. Why do you want script out each separately.

Are you running any queries that uses temp tables and results large number of rows i have faced the problem with some what similar kind of hardware thanwe moved to...

This error occurs if you try to login thru a SQL server id which has its authntication mode set to windows. Are you sure the server runs in mixed mode....

Do you have any computed columns i hope so the problems are still there with computed columns.

Since you know VB you can also give a try on using the SSIS.

This you should have done during the capacity planning phase estimating the row size of each record and the table, database sizes. Anyways now you have given me a good...

The device points to a path that actually does not exist. Check if the path that it points exist in the drive. Its better to backup to device if you...