I can't say I would recomment it but I've already had sql 7, 2005 and 2008 on the same machine :-D.

When aside from a code 18 :

- The trigger can be disabled

- The trigger may be set on the wrong table (dbo.table1 & user2.table1)

- I think I remember...

Hope it's not a stupid question but have you tried with 2 different files or did you change your code for the post?

Other than that I just don't know what...

Here's 1 exemple. I needed to keep the date updated / added and by whom on that table. On top of that I needed a deleted flag and...

Yes... it cannot really be otherwise.

You can obvioulsy add more fields when you need to, but the 2 most important fields are the 2 pks.

Have you tried with a single variable? I think I remember reading about that requirement on the post I sent you.

SET @Path = 'c:\whatever.txt;d:\report.html;\\Shared\this.zip'

This thread might help you out :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118851

Thanks a million to all who've helped on this problem.

I've had a very happy conclusion yesterday. After being told but the erp cie that it was impossible to add...

Here's the article I used to get started... I used the other one when I got stuck. I'm using vs2008 on sql 2008 64 bit and c# 3.5 so...

This might help you get started.

http://www.gotreportviewer.com/

TAMMYAUDETTE (4/12/2010)

---

Yes, this would be simply for downloading reports, invoices etc.

But integrating the two? The two what? Sorry, I'm a little lost.

Given that this isnt a transactional or...

Well yes and no.

You lose windows authentication...

DBCC TimeWarp would be so usefull for this one :-D.

Paul White NZ (4/10/2010)

---

While revisiting the Numbers table solution, I discovered that the following code creates a table from 20 names in 6 seconds on my old laptop:

USE tempdb;

GO

IF ...

I don't see why you would put that last one ine there (ID (FK Uniqueidentifier, but just a normal field)).

The 2 tables linked together need an id. Then the...