467,903 Members | 1,736 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,903 developers. It's quick & easy.

Tuning sql in SQL Sever 2005 using the dta utility

Hi,

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.

e.g.

Create a new login: login1, pass1
CREATE USER user1 FOR LOGIN login1 WITH DEFAULT_SCHEMA = user1_schema
Workload file:
select * from table1

Table list file:
[db_recommend].[user1_schema].[table1]

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?

Thanks
Meytal

Feb 9 '06 #1
  • viewed: 1040
Share:

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 this site, you agree to our Privacy Policy and Terms of Use.