Interesting article but it's not quite true that it needs a clr - I did something similar for pre v2005

http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html

As to your question - you can get the table...

Have a look at

http://www.nigelrivett.net/FTP/s_ftp_GetDir.html

It shows how to do this sort of thing in a stored pocedure.

Will need access to the disk to create the command files though.

You might want to have a look at

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-common-table-expressions/

Which shows how this sort of thing can be done in v2005.

Must admit I never create a permanent table like this but...

see

http://www.nigelrivett.net/DMOScriptAllDatabases.html

'COM1' is a constant and so does not need to appear in the group by.

>> Is that means that table definitely has no duplicated rows?!

No. Only a unique index will prevent duplicates. A clustered index just orders the rows.

If you have inserted over...

look at bcp in bol

Other methods

http://www.nigelrivett.net/WriteTextFile.html

Cursors never.

DTS - only when needed and never to control.

From the number of relies this article has generated I guess it's a success whether you agree with it or not.

Sorry I haven't read the whole thread (or the article).

My...

Is the other step enabled?

There are lots of things that can cause this.

Remove tasks that you don't think are involved ib the workflow and then add them one by one...

Clear space on the disk to allow tempdb to grow or change the query so that it uses less tempdb space.

Do you have all the databases in simple recovery mode...

I'm pretty sure this is because of the way you created the database.

I suspect this is an identity in the old database but not in the new (and that the...

SP = Stored Procedure

What does the rest of that insert code look like - does it set the command type to adCmdStoredProc?

In query analyser try an insert statement

begin tran

insert prl_shopping_cart(col1,...

I take it this is calling an SP in which case the column can't be referenced.

Yoyu copied the database usnig dts - have you checked that the default was also...

No.

With an mdf the only thing you can do is attach the database.

see sp_attach_single_file_db

And read about backup strategies.

Cursors never.

DTS - only when needed and never to control.

You are probably inserting null into the field rather than omitting it from the insert list and allowing it to default.

Cursors never.

DTS - only when needed and never to control.