nevermind ... http://www.codeguru.com/vb/gen/vb_database/sqlserver/article.php/c11141__1/

Thanks a lot. That's great.

Nevermind. Here is the response I got from a MS representative.

"There's still some licensing stuff to be worked out but you will be able to

put the self-extracting CAB...

you could also "left join ... on ... where key is null"

cross-server queries are considered heterogenous queries so you have to set ansi_nulls/warnings "on" with the "GO"s

then you have to create the procedure in QA (because you cant put three seperate...

Nevermind ... I found the answer.

ActiveX

http://www.sqldts.com/default.aspx?251

you could also do a left join

delete p

from patient_policies p

left join vouchers v

on p.patient_policy_id = v.current_patient_policy_id

and p.patient_policy_id = v.original_patient_policy_id

where ((v.current_patient_policy_id is null) and (v.original_patient_policy_id is null))

you can install personal edition (aka Disk 2) on XP.

File Watcher:

http://www.databasejournal.com/features/mssql/article.php/3319261

then union all

Have you tried a datatype of "text"?

an alternative could also be to create a "File Watcher" package.

http://www.databasejournal.com/features/mssql/article.php/10894_3319261_3

when using aggregate functions, you need to have the non-aggregated columns in the "group by" clause

this should get you started

declare @path varchar (150)

set @path = 'http://www.sqlservercentral.com/forums' +

(select top 1 [image] from [image table] where [criteria is met])

select @path

Based on my (limited) knowledge of replication here are a few answers:

Publisher: the server that actually has the data

Distributor: server that makes the data available (we have our publisher...

Incorrect syntax near the keyword 'RIGHT'.