Viewing 15 posts - 1 through 15 (of 17 total)
January 4, 2007 at 3:26 pm
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...
August 2, 2005 at 9:58 am
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...
May 20, 2005 at 10:39 am
Nevermind ... I found the answer.
ActiveX
May 13, 2005 at 1:04 pm
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))
April 22, 2005 at 10:49 am
you can install personal edition (aka Disk 2) on XP.
April 13, 2005 at 3:31 pm
April 13, 2005 at 1:27 pm
an alternative could also be to create a "File Watcher" package.
http://www.databasejournal.com/features/mssql/article.php/10894_3319261_3
March 3, 2005 at 11:22 am
when using aggregate functions, you need to have the non-aggregated columns in the "group by" clause
February 28, 2005 at 3:23 pm
this should get you started
declare @path varchar (150)
set @path = 'http://qa.sqlservercentral.com/forums' +
(select top 1 [image] from [image table] where [criteria is met])
select @path
February 28, 2005 at 3:05 pm
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...
October 25, 2004 at 10:55 am
Viewing 15 posts - 1 through 15 (of 17 total)