Yes, replication partners need to have a direct connection to each other. If you cannot arrange this through your DMZ, then I would suggest setting up another SQL Server...

dwither_07 (1/13/2009)

---

RBarryYoung

The answer is no, it has different number of fields and commas...

Abhijit More (1/13/2009)

---

there is another way which you can use..

1. Take the MAX(userID) before batch insert. this will give you the last UserID before batch insert

2. Perform batch insert.

3. Retrive...

How can you be so sure? I have written a lot of specialized...

Yes, Delete Cascade does work that way. Update Cascade means that if you change the CustomerID in the Customer record, then it will automatically make that same CustomerID change...

Following up on what Gus said, you want to try it like this:

declare @val varchar(8000)

declare @appid int

set @val = ('2212,2194,2215')

set @appid = 14

insert into link (appid, serverid)

Select @appid,...

Oops, didn't see the later posts: If you are going to SSIS, that is fine too and should be about as fast as SQLBulkCopy. If you are going...

mikael (1/12/2009)

---

Hi Barry,

Sure ... here it comes.

...

Here i loop over the Items in the...

Powichrowski Marek (1/11/2009)

---

Those...

Glad I could help.

I think that you'll have to show us the actual code for us to help you.

Once...

Stephanie J Brown (1/11/2009)

---

mtucker (1/11/2009)

---

The sad reality is that people make judgements about you based on appearance and other things that have no relation to how good an employee you...

Powichrowski Marek (1/11/2009)

---

There is no information about those contracts:

http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho

http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic.

First contract implements "ping" to the service broker instance (I think). The second contract implements message Query sent by initiator and...

Dugi:

FYI, you can use SQL in Access. It is not an "either..or" situation.