471,089 Members | 1,301 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

Tuning sql in SQL Sever 2005 using the dta utility


I am using the dta utility successfully.
I have problem to tune query without specifying the schema as prefix in
case the tuning session is not with the login that own the schema, the
dta utility fails.


Create a new login: login1, pass1
Workload file:
select * from table1

Table list file:

1. If the tuning session of the dta is connected with login1, pass1 the
dta succeed.
2. If the tuning session of the dta is connected with other login the
dta fails.
If I will specify the owner in the workload file the dta in this case
will succeed

Is there a way to update the dta with the correct user/schema
dynamically instead of specifying the owner for each object in the
workload file?
Is there a way to active setuser function in the workload file?
Is there an option in the XML file to set the correct user?


Feb 9 '06 #1
0 1127

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jean-Marc Blaise | last post: by
13 posts views Thread by atlaste | last post: by
reply views Thread by Medhatithi | last post: by
3 posts views Thread by dunleav1 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.