Thanks sql_lock. I have another question:

I have a default instance of SQL Server 2000 running on Windows Server 2003 R2 SE SP2. May I install a named instance of SQL...

Thanks Mohit. I am still going to research why SQL 2005 DBMail would not allow you to send an attached file (created from the Report and Logging Dialog within the...

Thanks Mohit. I would have to Select the text file name (with your code) into a variable and then past the variable into the sp_send_dbmail command as the value for...

I have checked the Plan History, SQL Logs and Event Logs. Nothing helpful there.

Thanks, Kevin

Brandie, here are more details:

BTW, the folder has been shared and permissions given.

This is the dialog within the Maintenance Plan that creates the file I want attached:

Edit a Maintenance Plan...

(Mohit), as far as writing the output to the same file, I am talking about the file that contains the database tasks (check integrity, update statistics, backups, etc) output. It...

As far as writing the output to the same file, I am talking about the file that contains the database tasks (check integrity, update statistics, backups, etc) output. It sounds...

I have made progress on this today. (I removed the user account from the built in admin group and from the db server sysadmin role.) I have it so the...

Not yet. We are using a Domain User which is used to start the SQL Agent Service. (This is SQL Server 2005 running on Windows Server 2003.) This is what...

Yes, the email is being sent. The attachment is not being sent.

Thanks. I had to put the tablename in single quotes. Sorry about posting a SQL 2000 Question on the SQL 2005 Forum.

Kevin

Question,

OBJECT_ID seems to be unique to SQL Server 2005. How would you get this query to work for SQL Server 2000?

Thanks, Kevin

Are you saying that the "move pages to the front" option would fragment your database and also shrink your log? Or the "truncateonly" option would fragment your database and also...

Are you talking about using isql or osql?

Thanks, Kevin

Thanks for the reply. I also had a related question that I mistakenly ask under the Administration Forum:

We have SQL Server 2000. I would like to run a query on...