i would simplify the issue a bit:

items that contain badwords get archived off to a separate audit table, then update the messages directly to remove the bad words; the overhead...

FYI HL7 is a messaging specification for healthcare information systems.

I goggled a bit after this, and it appears that the parsing is not a trivial thing; one of the...

the error 5.7.1 Unable to relay says the issue is with your mail server refusing anonymous mail;

usually a mail server requires mail to either come from 1)a trusted source/ip, or...

I think this happened to me once when I had upgraded the server to a higher version of a service pack, but not my local client tools; the local client...

ypk1984 (3/8/2011)

---

Hi I dont know, weather this is valid question or not?

So when we establish the linked servers, we can be able to see all the servers linked under the...

I'm guessing that the issue has to do with your SQL2008 being 64 bit, and thus requires 64 bit postgres drivers.

take a look at this article:

http://www.postgresonline.com/journal/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html

I'm not sure what you mean by that; as long as the driver, whether SQL...

backs are stored at a major version level: SQL200/2005/2008/R2;

service packs do not alter the format of the backup files, so you can restore to any installation of 2005; you can...

but he mentioned he's pulling from oracle...so joining a linked server table to your local table will threaten performance, because the command will copy the entire oracle table to tempdb,...

not like you are asking, no ...you cannot dynamically create a table by calling your procedure.... have to create a table with the appropriate columns and datatypes first.

a work around...

the issue is to NOT use the INSERT...VALUES syntax, but INSERT...SELECTinstead:

insert into sbsincome (incomekey,flightkey)

select

MAX(incomekey)+ 1 AS incomekey,

116040 AS flightkey

from sbsincome

mick i'm afraid i'll end up sending you to do some reading; i don't have a handy SQL 2000 solution to paste here for you;

as i remember it, if your...

you posted in SQL2000; are you limited to using sql 2000 for this solution?

sql 2005 introduced the row_number() function, which makes it really easy to do; your page would just...

not with openquery, but the linked server has an EXECUTE AT command that allows you to do some things;

i've created real tables, bu tnot temp tables(except inside a full set...

I believe that by default an installed instance does not listen to the default port of 1433.

take a look at your configuration and see which ports it is currently listening...