Most likely because BULK INSERT in the transact SQL method to invoke a BCP bulk copy so it is intended to run against the local instance. The bcp tool...

Here's the syntax definition from 2005. It does not support the 4 part naming convention. This came from BOL you could check on line for the 2008 version...

Whiskey Steaks at the Drover! (Anniversary Celebration)

Mmm....on their website[/url] they call it the 'The Ultra Chocolatta Bar '.

Well worth it, in my opinion.

Peppercorn Duck Club......my favorite restaurant on the planet.

hunger

quiters

In SQL Server 2005/2008, you can have SQL Server manage your partitions. You don't need to create individual tables and join them with a view. As far as...

spiral

clucasi (4/26/2010)

---

Cheers for the replies.

The inserts,updates and deletes will only effect one row ie. it could update the row then delete the row and then insert the row all acording...

Well, what did you think? I saw it in the theater in 3D so I thought that would be disappointed...

UPDATE Tutti.dbo.TBL_EMP

SETsalary =

CASE

WHEN Sarlary BETWEN 20000 AND 40000 THEN Salary + 5000

WHEN Sarlary BETWEN 40000 AND 55000 THEN Salary + 7000

WHEN Sarlary BETWEN 55000 AND...

ChrisM@home (4/23/2010)

---

John Rowan (4/23/2010)

---

Chris Morris-439714 (4/23/2010)

---

Sunny here in England, very pleasant 18C or so.

Shooting all weekend, there's a competition in Chepstow on sunday for the first time in several...

Chris Morris-439714 (4/23/2010)

---

Sunny here in England, very pleasant 18C or so.

Shooting all weekend, there's a competition in Chepstow on sunday for the first time in several centuries - shooting...