February 26, 2008 at 7:47 am
After 12 hours of analyzing, DB Tuning Advisor started step 4 "Generating Reports", but finished with a warning. The Tuning Log had some error messages at the end, similar to:
E000
Error encountered while generating reports. Write to [msdb].[dbo].[DTA_reports_table] failed.
[Microsoft][SQL Native Client]Unable to resolve column level collations
SQL Server and DTA are running on different Win2K3 machines.
I don't know where to start looking... Hints?
Thanks... ++Vitoco
November 27, 2011 at 1:34 am
I wish someone had replied to your message! I'm getting the same error and thought maybe it was because the collation is different on the server that I am profiling than the one that I'm running profiler on (case-sensitive vs not), but I get the same error if I run on the one I'm monitoring.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 9, 2013 at 3:41 pm
I am having same problem its not Generating any reports , can some one please reply on this post really appreciate it
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply