No. But since we were having this problems, we changed settings to 'number of processors to be used by parrallel query" from 4 processor to 1 and it works fine,...

trying one more time!

Anyone have any ideas?

Thanks for your help.

Try BOL. Search for Errors. Some of the errors are listed, and if you can't find there I usaully check Knowledege Bases on Microsoft's website.

After making sure you have proper account with proper privileges to start SQL service and SQL agent, restart SQL server and restart SQL agent. Might work.

I had this problem too. I disabled in my Database. Are there any disadvantages of turning this off? Thanks.

Thanks, Andy. I think sp_change_users_login is the way to go. Also instead of SQL users I created new users with NT authntication, and it seems to keep the windows users...

Thanks everyone for your suggestions.

I didn't have any permission issues, but Swarn's version of file did it.

Swarn, what is different in your file than it would be in...

Terry,

I had this experience recently. And I thought it's usual. I am new to SQL server and this happened to me in first few weeks.

We had full backups though for...

Thanks, Matthew.

Yes it was a linked server issue and it's working now. Still working on the package, changed all the passwords but didn't work yet. Thanks everyone for your...

Thanks, Simon but we are using NT authentication for sql agent.

I found other solution for my problem from databasejournal.com

textcopy /S ServerName /U sa /P /D msdb /T sysdtspackages /C packagedata /W "where name='DTSName'" /F DTSText.dts /O

This command will bring...

Thanks Zack. Atleast now I know what the problem is. IT is version issue. Package was written from client machine (2000). Server that package is running on is 7.00. I...

Rebooting that machine worked for me. Thanks guys.

When my log file sizes increases I truncate log file and I shrink it though EM. then I take DB backup if it's production DB. Is this a right way...

Thanks, jayharper.

We are actually SQL 7.0. ANy suggestions for that? Thanks.