deleteing columns from a saved fixed width file connection object

How do I delete columns in a fixed width column file connection object, after I've saved it I can't remove columns anymore?

You'll need to reset your columns. See this thread for details ... http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=434333&SiteID=1

Donald

Deleted Stored Procedure Caused Backup Job to Failed

Hello,

I created a test stored procedure in MS SQL 2000. When the problem in my app was fixed, I deleted this test stored procedure. But the backup job thinks this procedure still exist and so backup job would failed. How can I fix this problem?

Thank in advance for your assistance.

Correct the 'backup job' so that it doesn't reference the deleted stored procedure.

I don't think that a database backup would fail because of the inclusion or deletion of a particular object, especially a stored procedure -unless that stored procedure is running the process.

|||

Arnie Rowland wrote:

I don't think that a database backup would fail because of the inclusion or deletion of a particular object, especially a stored procedure -unless that stored procedure is running the process.

Correct, a database backup doesn't care about the objects within the database.

Deleted Stored Procedure Caused Backup Job to Failed

Hello,

I created a test stored procedure in MS SQL 2000. When the problem in my app was fixed, I deleted this test stored procedure. But the backup job thinks this procedure still exist and so backup job would failed. How can I fix this problem?

Thank in advance for your assistance.

What kind of procedure it is?

I don't think procedure is anything to do database backup. Database backup is the complete copy of the database not the one by one object copy...

Can you post the error what you are getting when you are running the backup and how you are running the backup?