What is wrong with backup and restore? It by far the easiest and safest way to do this.

I am guessing you will have better luck on a java forum since this is clearly an issue with java connecting to sql. 😉

Duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1325233-392-1.aspx

If by that you mean the Sporting KC win last night then I would say my celebration was up to par. 😉

Have you looked into EXCEPT? http://msdn.microsoft.com/en-us/library/ms188055.aspx

You have procs running sporadically slow sometimes the two most likely candidates are blocking and parameter sniffing. Take a look at Gail's article about parameter sniffing.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

Make sure you read all...

Sorry yesterday was a holiday here in the US. It looks like Chris...

SQLBill (7/3/2012)

---

Sorry, that's an old one that's been on this site...

Congrats Gail. That is certainly something to be excited...

SQLRNNR (7/3/2012)

---

Brandie Tarvin (7/3/2012)

---

GilaMonster (7/3/2012)

---

Sure. Will you finish off...

OK your description is still incredibly vague but I think that you are asking if you call a scalar function from within a trigger can you see the newly inserted...

jitendra.padhiyar (7/3/2012)

---

That...

No need for that. Here is some code that works perfectly in SQL.

;with Details(ChargeDescription, Charge, Weight)

as

(

select 'wrong address', 5.00, 2 union all

select 'wrong address', 5.00, 3 union all

select 'wrong weight',...

jitendra.padhiyar (7/3/2012)

---

Sean Lange (7/3/2012)

---

It makes sense if you think about it. You are talking about pushing modified rows contents to another database. Without a primary key how do you know...

It makes sense if you think about it. You are talking about pushing modified rows contents to another database. Without a primary key how do you know which row is...