Sorry about that. Try this one:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7915&FORUM_ID=5&CAT_ID=1&Topic_Title=Sending%20Attachment%20with%20Cdosys&Forum_Title=Administration

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Might want to take a look at this post. It address the same issue:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7915

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

What method are you using to connect to SQL Server?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

No, what you need to do is restore the backup to another database, and then DTS the table back to your original database.

Gregory Larsen, DBA

If you looking for SQL Server...

Are you having the same problem with your web page, and/or application? Have you looked at your @@TEXTSIZE setting?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

If you are using QA there is a results setting that specifies the maximum characters per column. It defaults to 256, but can be changed on the "Tools" -...

Yes I have seen this problem. It occurs when there are lots of database backups information in the MSDB database. I'm guessing if you where to run sp_delete_backuphistory...

I move jobs this way all the time. The main problems I have are around job owners, and the operators being notified. Make sure the job owners are...

Not exactly sure what you are trying to do, but seems that if you know the job_id, then you can always uses the sysjobs table to get the jobname.

Gregory Larsen,...

Scorpion_66: If the database was originally created by a user other than SA you can issue the command:

exec sp_changedbowner 'SA'

To change the owner to 'SA'

Gregory Larsen, DBA

If you...

Oh. In our shop the DOMAIN account is in the local admin group, although I'm not sure we have give much thought to why.

Gregory Larsen, DBA

If you looking for...

Have you checked into the package object to see if you is some method that might be useful.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

We have set up SQL Server services to use DOMAIN accounts. Here is why:

1) We want SQL Server to interface with Exchange to sent mail, and need a domain...

We have put TEMPDB on a RAID1 device. We did this for performance reasons. I'm not a performance person, but I have been told by some performance experts...

I just tested this and the email attachment seems to work in my environment. Just to let you know this machine has both IIS and SQL. It is...