Check for duplicate tables with the same name but different owners.

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Check for duplicate tables with the same name but different owners.
Document ID : 000-000745 Created: 3/19/2002 Last changed on: 3/19/2002

Use Enterprise Manager to list the tables in your NetKeeper database. Look for tables with the same name but different owners. This is an invalid situation. The correct table is usually owned by "dbo". Compare with the owner of the other tables.

When creating a table using the DTS Import/Export Wizard or DTS Designer, the owner of a table created at the destination is the current user (generally the dbo), regardless of who the owner is at the source. This can result in a situation where the dbo attempts to create a table at the destination and the table name already exists, thus causing the attempt to fail.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.