Did you solve the issue??? Let me know if you need more help.

There's no way to make a general rule out of this. It must be evaluated for all tables inividually depending on the data and how it is accessed.

What problem...

You can also try to ping it from you dev machine. That can show you if some port is blocked by the network admin...

Why not use a country code? I mean 250?? countries X 5 char is still WAY under 8000.

Do you have enough permissions on your machine to edit...

Are you sure you are pointing to the right server / database and with valid credentials?

Last point, is the server still running (might also want to check sql browser and...

I use varchar(max) and I never had a problem with 8K limit as a parameter... what problem are you getting with this option?

Here's the image in questions.

forsqlserver (5/26/2011)

---

Thanks a lot Gila,

My Edition is:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation ...

Fraggle-805517 (5/26/2011)

---

I would love...

Gianluca Sartori (5/26/2011)

---

Impressive. You...

jshurak (5/26/2011)

---

No no no. It was simpler than that. Insert statements are for rows that don't already exist in the database......update statements are for rows that do...

I think my "official" best run was over 1500 posts in june 06 or 07. I'm not trying to beat that one anytime soon ;-).

ridzuan_first (5/25/2011)

---

Thanks,but need a shortcut on the server desktop to ease my users execute it.Is there any way to generate all script from maintenance plan?because plan to deploy 100 over...

Maintenance plan is supposed to create a job....