Grant Fritchey works for them, so he will say good things about SQL Monitor.

Has anyone used SQL Monitor here? I am looking more of a review.

Kurt, I agree with you and I don't like the way it is. But it's one of those things that I users need it "Immediately" and I didn't...

Keith, Thanks. That did the Trick. Here is the correct Code:

END TRY

BEGIN CATCH

...

Thanks. good idea for using the breakpoints. I think I'll do that and post my answer here later. I read up and there are other instances where file system...

See picture... Do you see the same options as I do? What version of SSMS did you install?

The "Duration" column in the Profiler. In SQL 2008, it shows the timings in Microseconds (i.e. divide by a million to get seconds) and in SQL 2005, it shows...

My Regular account is listed under membership. My intention was to give my regular account access to Analysis service. Currently my regular account doesn't have access even thought...

Run This code on your report server database and it will give you an schedule to see if you are running multiple reports at the same time

SELECT * FROM...

Do you have any other processes running on the database at the time of Subscription? For example, back of the Report server Database. It might explain the occasional...

Thank you both of you. It's really good information.

I have been reading about running Perfmon data, but then yesterday I figured out that it doesn't really apply here...

Data Conversion task is a Syncronous transform, it shouldn't be taking 3hrs for 5,000 records. Please post screen shot of your package.

Alternatively, you can use T-SQL to conver...

Read up on datawarehousing and Denormalization, that will help.

Basically, you do have three different date values. This those dates are describing(dimension) the values in the fact table.

I would use SSIS to export data to a DB, access or SQL. You can schedule this to run at any frequency you like.

Then I would have SSRS access...

wait, I don't understand. You want to sum the up percentages? If you are summing up the percentages, then it would be 487.5%. Or you are looking for...

So I changed EnableAuthPersistence to False, but still no Luck. Any ideas?