By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,686 Members | 1,510 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,686 IT Pros & Developers. It's quick & easy.

Tuning sql in SQL Sever 2005 using the dta utility

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.