You could try changing the recovery model (if you operational policy allows it).

If you do change the model then be sure to backup the db (after you set back to...

When you say policy.... Do you mean permissions?

Have you traced to see what options are in effect (Ansi Null Default On, Ansi Nulls On, Ansi Padding On, Ansi Warnings On etc) at the point the SP is...

Joe

Thanks for your reply...

Indexes and Stats are updated on these table every night.

JL

Is this SQL 2005 on Windows 2003?

Have you check the security Setting in the "Component Services" console?

Im guessing the WMI service is running?

Also check that you have IIS installed.

It depends what process it is.. Can you find out? Maybe using sp_who2?

For example I have a LogReader process that has used 6 million ms of CPU.

Have you also tried to apply the latest SQL service pack?

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4

Try the following

- Open a command prompt

- goto \Program Files\Microsoft SQL Server\90\DTS\Binn- Type in regsvr32 dts.dll

Failing that you may need to reinstalled the Management Tools.

Rgds

JL

Are you able to run a memcheck on this server? Could be a memory issue?

Also who many CPU's do you have on this SQL server? What is your MAXDOP set...

Try using "-C" (uppercase) and defining your database/Column collation.

Firstly, have you run CHECKDB on the data base...

ALTER DATABASE [DBNAME] SET EMERGENCY;

GO

ALTER DATABASE [DBNAME] SET SINGLE_USER;

GO

DBCC CHECKDB ([DBNAME], REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;

GO

Then check the status

SELECT state_desc FROM...

Thanks for the reply

That is my 1st plan to try and resolve this.. But what im not understanding when I simulate a failure in my Dev AND QA env it...

As in the previous post you can script the job... I pref to use SSIS, but that is personal pref.

You could try using "EXEC sp_change_users_login 'Auto_Fix', 'user'" to corrent any...

Have you tried using SSIS within BIDS?

There is a transfer job tasks that has worked for me. I have had it where it fails but that was due to the...