It is painful if we have a table with complete identical rows. To delete such dumplicates, we may do as follow:

1. Create a column (col2) with identity;

col1     col2

A         1

A         2

a         3

B        ...

We can include those stuff.

Yes. You may choose Copy objects and data between SQL Server databases. Browse all tabs when Import/Export your data. Make sure you do not miss any important stuff.

Using Import/Export data approach.

It seems to me that there is no way converting a DTS package to a text file. A too fast conclusion? I wish someone have a soultion. But you may...

sysobjects is a system table, not a dbName. You should run

SELECT name, type FROM sysobjects WHERE name = 'yourTableName'

If it returns something, it indicates you have this object.

Run

SELECT * FROM...

Open the table, sysobjects, to see if it is there to confirm your guess.

If the ownership is not dbo, you may try to use the full name of an object,...

Open the job property;

Goto steps tab;

Click New button;

...

You would miss it.

I had the similar situation. I tried two approaches. One is the same as yours, change the ownership to sa, then change it to my desired ownership. Another is drop...

Did you try

BACKUP TRAN dbName WITH TRUNCATE_ONLY?

It might be caused by the following two reasons, but not limited.

1. Users have different privilege to access DTS;

2. Users use different versions of SQL Server Client tools.

Did you change the recovery mode to SIMPLE, since you run out of disk space?

You may use SQL Server Profiler, or PerfMon, or other third party tool to collect information first. Then, you can use whatever software, such as excel, ...to generate your report.

Microsoft defines it latch, a process is waiting for output from IO. In most of cases, the self-blocks can be unlatched. However, there is potential the self-lock will develop to...

Just for Qian Lu and anyone who know the answers of the following questions.

Could you tell me how to save an execution plan, and how do you know an execution...