My memory is a little foggy and we have upgraded to Sql 2008. But from what I remember I had to break the MP up into individual Databases and that...

I checked to make sure the user running the job had write priviliges on the Temp directory and he did. On a lark I decided to write the file out...

I have continued to work on this problem and found a few more interesting tidbits. A co-worker was also having issues with editing DTS packages and decided to load the...

Gift,

I have re-installed Sql Server 2008 and RS 2008 but this time time I did a files only RS install. I also had to create the RSExecRole and configure according...

Gift,

I think I may have stumbled onto the reason for my error. I think I mentioned somewhere above that when I did my installation I had the RS portion go...

Gift,

Thanks again for replying...I have about 200 plus reports and only 5% of those have subscriptions. The reports are failing when I merely click them for display and not during...

I checked several reports in BIDS and all the data sources are in tack. I ran/pre-viewed these reports and was able to get data to be returned and displayed in...

I saw that posting and downloaded the Hotfix but did not install as I have several reports that are giving me the error mentioned above but at most contain several...

For some reason in the "Reporting Services Configuration Manager under Scale-out-Deployment I had the same server listed twice. I deleted one of the entries and the web page displaying all...

I spoke with one of my co-workers that asked if I had restarted Report Server Services after installing the Oracle Client. I had not so I stopped and started the...

I like the idea of using a trigger and see that there are new DDL triggers at the database and server levels. But I don't see how I can leverage...

I have created a MP that runs on the weekend, I have two procedures that run, one to Rebuild Indexes and the second is Update Statistics...

Each Monday morning we have...

I was looking at the stored procedure and was wondering based on the error I got "Message : Incorrect syntax near 'CA'."

Could it be that the TRY/CATCH is not...

Additional Information...

Here is the actual error from the Web Application..

Inner Exception

---------------

Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Message : Incorrect syntax near 'CA'.

Source : .Net SqlClient Data Provider

Help link :

Errors...

Just ran one and there were no errors...

CHECKDB found 0 allocation errors and 0 consistency errors in database 'MRv4_Reg'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.