dbTalk Databases Forums  

Running DTA (2005 and 2008) using a 2005 TRC file

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Running DTA (2005 and 2008) using a 2005 TRC file in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stevecin
 
Posts: n/a

Default Running DTA (2005 and 2008) using a 2005 TRC file - 11-06-2008 , 07:11 AM






I have not used DTA more than a couple of times.
Running against this trace file I keep getting the error "Invalid object
name '??'” on all the objects.
We are using a schema name different from DBO.
The selects are not qualified by the schema name.
I have used a trusted connection, SA user, and also tried the User we have
set up for our objects.
I have even transferred all the objects to the DBO schema and tried it.
I trying to figure what I am doing wrong or if there is a problem with DTA.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.