Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  why must have database.owner.table

Author  Topic  abc Starting Member 48 Posts Posted - 2001-11-07 : 02:29:08 I have create a database and login as a creator database (not sa). So I just have to use table_name when I use T_SQL. But when I backup and restore that database, I can't use table_name only, to transaction, instead I have to use: database.dbo.table, I can't use database.hien.table, too (hien is database's creator), althought sa have create login hien and permit hien some right for her login as first. Whar wrong is it ? Thanks for your attention