Thanks for that.  But how do I tell it to do it to a particular script.  I don't mean to be stupid, but I can't see where it says export it...

I'm not very familiar with SSIS at this stage.  Where is it available in 2005.  In 2000 it's just part of the job scheduling under SQL Agent, I can't seem...

Yeah, Sorry.  I noticed after I posted, but I can't seem to find a T-SQL part of SQL2005 and I didn't want to post twice.  Where would recommend I post...

One of those days I think

Thanks for that, works perfectly.

I get the following error when I change the table names to be the same name.

The objects "Table1" and "Table1" in the FROM clause have the same exposed names....

Sorry.  I should have mentioned it's the same table.

I can create tasks on all clients.  It's only when I want to modify them I have the error on the one server.  I've installed the client tools on another...

It can't be rights related as I haven't changed them since the initial install.  I'm also using the same user account on 2 other servers and they are working fine. ...

I have now got this working.  It appears if you remove the time it will work.  eg EXECUTE master.dbo.xp_delete_file 0,N'C:\aaa',N'bak',N'03/01/2006'.

However this does not appear to help when running...

I'm having the same issue.  I have been told that SQL 2005 can't delete files in sub folders, but I've done a bunch of backups directly on the C drive and...

Thanks for that

Thanks, you're a legend

That has confirmed that the owner I'm trying to delete does not exist on the database, yet still won't let me delete it.

To give you an example.  When I run sp_revokedbaccess I get the same error, but the result set says the "grantee" is public and then the table name.

Does that make...

When you look at the table owners it says it is the one I set up, but for some reason when I run the TSQL it says the old owner is...