BOLs = books online (help file that comes with sql server).

In enterprise manager :

1 - Right click on your database

2 - Export data...

3 - Follow the wizard and you...

Hey vasc, what's the reasonning behind the update trigger?

Why do you do insert deleted, insert inserted instead of doing a single insert from inserted and marking it as 'U'?

Anyway you can make the InvoiceDate the clustered index?

What exactly do you need to do on the Oracle server with that data?

You can look up linked servers in BOLs and dts export data to do this task.

Thanx guys.

That's the server's log. We asked for the WINDOW'S log.

15 users is the number of persons using the system... number of concurrent queries is very small (few k/hour), almost all under 10ms.

Fox 44.

My bad...

CREATE TRIGGER trgInsertIntoNewTable

ON test2

FOR DELETE

AS

insert INTO dbo.test3 (columns list) Select ColumnsList FROM Inserted

GO

What statement are you executing????????????

Please do not cross-post, we monitor all boards.

Finish the thread here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=214648

Sorry but we can't help you then. Contact M$, but that ain't gonna be free.

I we see the actual code of the proc??

A few questions.

1 - Is this the actual code you are using or a demo for our viewing pleasure?

2 - What's the code of the function?

3 - Was there a...