Thanks for the fast reply. I need to do it dynamically, as soon as attributes are changed.

Thanks for replies, but my question was: How can I see real pictures directly in sql QA as we can see them in MS Access, how to insert real .jpg...

Try this:

SELECT * INTO #temp2

from TBL_test where col1 = 'abc'

You don't need to drop the whole publication, just unsubscribe all subscribers and uncheck the table you don't want to publish. And subscribe again.

Another approach:

INSERT INTO maintable(pk_field, field1, field2, etc...)

SELECT s.pk_field, s.field1, s.field2, etc...

FROM stagingtable s

WHERE s.pk_field not in(SELECT pk_field FROM maintable m)

Check the port number for the named instance, it should be 1434. In sql client configuration create an alias name using port number.

There is a MS bug in xp_sendmail, the bad mapi.dll in sql2000/sp2. We have the same problem, called MS and they sent us this updated .dll (should be version 603)....

But if you have MCDE 2000 installed with another application you can install SQL2000 named instance only, or uninstall application with MSDE and install SQL2000 first.