Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Database Settings or SQL2K Compatibility ?

Author  Topic  Bunmi Starting Member 3 Posts Posted - 2002-07-17 : 15:02:51 Hi, I just upgraded to SQl Server 2000 from 7, and realized that all my reports created with existing scripts no longer work fine. The reports appear corrupt. Below is an example of a report script: declare @vSubject varchar(30), @vMessage varchar(20) Begin Select @vSubject = 'Report as of :' + convert(varchar,getdate()-1,1) Select @vMessage = 'Automatic Report' EXEC xp_sendmail @recipients = 'Bob', @query = "FetchEmailData", @attachments = 'DailyReport.wri', @subject = @vSubject, @message = @vMessage, @attach_results = 'TRUE',@width = 250 End The DailyReport.wri file appears corrupt when opened with notepad. The same happens to .xls reports too. Are there settings I need to change or is this a SQL2K issue ?. Any suggestions/help would be appreciated. SQL Server 2000 runs on Windows 2000 Adv. Thanks.