The only way I can see you achieving this is by linking all the tables together using a left outer join.

For example.

create table tmp_parent

(parentid int, name nvarchar(5))

create table tmp_child1

(child1id int,parentid...

You are missing the quotes here:

objMail.TextBody = GlobalVariable (OIW_DOLLAR).Value <-- this fails

should be:

objMail.TextBody = GlobalVariable ("OIW_DOLLAR").Value

store the output in a global variable which you can then access in your code

Easiest way is to create a temporary table in which you insert all the records that are duplicates. Remember that this includes the records you want to keep as well....

I would go back to the user and tell them that you will backup the database at the point of a new version and can then restore from the backup...

I understand what you are trying to do now. I've never tried it myself, but this article from sqldts.com is what you are looking for. It loads a child package...

You need to create an activex task somewhere that is called before the value of the variable is required. The syntax to set the value of the variable is:

dim yourlocalvariable

.....logic...

From your post I am not too sure what you are trying to do.

However, at a guess, I would suggest creating and populating a global variable in the first activex...

I am as surprised as you are. I would suggest reading the chapter "Shrinking the Transaction Log" in BOL. I think you need to investigate the virtual log concept. Sorry...

As far as I know, there is no way to do it directly.

You can use a product like emarcadero to generate diagrams which will also give you other features...

I would

Backup log xxx with truncate_only

Then use DBCC SHRINKFILE and specify the size that you want. This will shrink the physical log file.

Then go into enterprise manager and change your settings...

sp_MSforeachtable will help do what you are looking for.

Someone passed this on to me at this site. Search for it and you will see the code to do exactly what...

If dts is not playing the game properly the only thing you can really do, is to do the export through an activex task.

That way you can format the...

select sum(filesize) as MB, sum(filesize)/1000 as GB
from o_file
where volid = 2 and groupid = 200

An obvious way is to break the text column up during the insert and insert one column into seperate table columns that are large enough to hold the data required....