Thanks Greg

Mike

On sql server management studio open up the security folder right click on a login,

select new login

create user as needed in appropriate box

if NT authentication is needed...

Thanks that worked .Now there is no next to fetch so fetch_status should not be equal to zero  and the test fails

Mike

In some cases you may have to truncate your transaction log to free up space.

At least in my case when you backup a 456M database with a 15G transaction log...

Without knowing your application you could definitely utilize more memory than 512M..

Mike

What version of sql are you on ...

Mike

If you google for this you might find a send mail tool I once used

xp_SMTPSendMail80

Tried the run for individual tables and it succeeded for most of them.The error appeared after one of them but the dbcc checktable for the table for the particular...

backed up just like on the same domain but a trust relationship had to be set

Mike

Made modifications suggested by noeld and the error reccurs

The maintenance plan failed with the same error

Will try to run for individual tables

Mike

Are you talking a single table ,multiple tables or database objects ?

If the problem is tables which is most likely drop ,export import

You can drop all the tables in the...

Are you running the same programs you have been running earlier

Mike

Those are various flairs of sql server ...

Go to your server and run print @@version .

Microsoft SQL Server 2000 - 8.00.2187 (Intel X86)

Mar 9 2006 11:38:51

Copyright...

I do not see why not if it can be shrunk/truncated ( I have not shrunk tempdb trans log before so test )MSSQL would not let you truncate an...

Not sure it does .But a maintenance plan is in place to do the same job

You will be informed if that works

Thanks for your time

Mike