Yep.

You need to use the IMEX command in the connection string. MSDN has all the details.

I had the same problem a while back and posted the detailed solution on...

It's not really a question of quantity of databases. It's a question of traffic and load vs server capability.

There's a huge difference between one database being hit by 10-thousand...

I don't really have a home. I have a place where I live, currently an apartment, but I can't really say I'm tied to it in any way, emotionally.

I...

Without a cursor or While loop or whatever, you could get that in one pass with something like this:

create function Cols

(@Table_in nvarchar(128))

returns nvarchar(max)

as

begin

declare @Cols nvarchar(max)

select @Cols = coalesce(@cols + '+isnull(['...

Michael Earl (1/15/2009)

---

So far, I haven't seen anything violent. Everyone seems...

Loner (1/15/2009)

---

10:15 - messing around on SQL Server Central

10:21 - help desk ticket #35104

11:30 - lunch

12:50 - building view dbo.JoesNewReport

13:07 - emergency help desk ticket #542138

13:17 - building view dbo.JoesNewReport

14:57...

If you actually have to do row-by-row, use a cursor for it. It's what they're built for, and they're good at it. While loops for row-by-row aren't as...

I think it's pretty much the same question as "which is better, red or blue?"

Staging tables like that work quite well. Yep.

declare @pFile XML

set @pFile = '(Your XML string)'

select @pFile.value('(*:Enroll/Context/@SubmitterUserId)[1]','varchar(100)')

Result:

THEUSER

(Can't post the XML here, but it's a copy-and-paste from your file.)

The default trace should have the command in it that is doing the disabling. That should give you the source.

Jeff Moden (1/14/2009)

---

John Dempsey (1/14/2009)

---

I'm with you Jeff. I always use BEGIN TRANSACTION when performing a manual delete. I also use it when I am doing an update...

Grant Fritchey (1/15/2009)

---

Oh now, don't be...

If you have a situation where some of the Customer_No values will already be in the target table, and you just have more rows about more stuff with the same...