You need to modify boot.ini to include /PAE switch and then enable MAX Server Memory in SQL Server. Shutdown SQL Service and restrat it.

1. You can go to Services.msc and restart MSSQLServer and SQLServerAgent Services.

2. In ISQL type SHUTDOWN.

3. On a command prompt, type NET STOP MSSQLSERVER /y and Hit Enter. Once done,...

If I were you I would either write a DTS package or I will copy that text file to the server where SQL server is located. You can either set...

If you can post error message from the job history, it will help me in making more recommendations.

If you think that it's not a permission issue, try doing a...

Unfortunately, you can't use "USE" statement in a batch execution. What you should do instead is split USE statment with rest of the batch.

Something like this:

USE COMMON

GO

NOW write...

You can avoid all this by setting up a wrapper class around sp_password and implement these policies as I stated. My only worry was if SQL server offers this out...

It certainly seems like a problem with the headers. Can you post your backup statement to review, please?

Thanks.

You are probably having permission issues Either on the table or on the view. When you run it thru QA, your logged on security credentials are supplied to SQL Server...