Qualify Object names - changed schema

tkdennis

I applied the Qualify Object Names to a whole script, and it changed tables that already had schema names to use the dbo schema. It happened when I changed the USE <database> statement at the top of the script in order to get it to qualify the cross-database references. The other database had tables in the dbo schema.

TRUNCATE TABLE dn.table1

to

TRUNCATE TABLE dbo.table1

Thanks,
Traci

Anu D

Many thanks for your post.

What happens when you remove the Use database statement and select the database which has table 'Table1' in 'dn' schema?