Jack Corbett (9/30/2011)

---

Here's the process:

....

What happens is I will get an error for one row that says "An error has occurred while sending this row to destination data source." ...

Lexa (9/30/2011)

---

Defrag with the overallocated DB? What do you use for defraging and why now be...

40% is a lot, but if you have the room to spare, leave it be. Saves you time later and gives you enough room to not need to grow...

5000+ rows.

See this: http://msdn.microsoft.com/en-us/library/ms184286.aspx

You can pass the parameter as a Table Type (new for 2k8) of a table variable.

Another option is an XML string, or even a comma delimited string, which is then...

To all those who feel this is an ugly question, remember this problem is an actually existing one if you have SSMS/VS 2k8 installed and you're still working with 2k5...

Well, if replication and mirror/snapshots are out, really the only other option left is SSIS delta data moves, and that's going to rely on you having an efficient delta detection...

Not entirely true, Gianluca. You just can't update more than one table's...

Byzza (9/29/2011)

---

Yes Exactly that. Thank you. As I said brain fart. For some reason I was trying From (Select ... from ...) instead of egnoring the select line.

Thank...

Pot, this is the kettle. I'd really like to discuss your current hue...

Elliott Whitlow (9/29/2011)

---

Yikes,...

Byzza (9/29/2011)

---

Hi All,

I'm just having a complete brain fart today and I have forgotten how to do a basic update. Could someone help me please.

I have a table "dbo.tblGroup_Drawing...

Technet article here: http://technet.microsoft.com/en-us/library/ms189087.aspx

Depends on your settings, either can be true.

PASS: The big name thing we tell our bosses we're going to for our hidden agendas... Code Magpie's Anonymous. Remember, meetings are at 8, 10, and 12, both days.

Heheh, my reaction was: But it's FoxPro.

You might want to mention a bit more about the SQL Skills you'd like them to bring to the table for...