Wow, there is so much wrong here, it's hard to know where to begin. Still, if you are looking for a quick fix (which I suspect) then change this:

[code[

...

Define "last".

I have to admit, I am quite suprised that SQL Sevrer 2005 allows you to do this. I guess they did not conver the msdb.dbo.* tables over to sys.*...

I don't believe that will find table columns named "Address" will it?

It's a shame we never got the query. I was hoping to work on it today.

I prefer [font="courier new"]{expression} AS {columnAlias}[/font], but I suppose its just because I am used to it. I agree with Jeff though, only use the brackets¹ when they are...

It has been a long time since I did this on SQL 2000, but I think that you drop the subcriptions first, then the article. Then add the article,...

What happens if you make new sessions?

Jpotucek (6/13/2008)

---

Here we go again.. a DR Test but a short one this time.. only a couple of hours.

While my distribution job is disabled, what would the proper...

That would be my advice, yes.

balbirsinghsodhi (6/12/2008)

---

I am able to extract data from XML files using SSIS package through XML Source component. It looks ok but there is little problem about datatype. Default datatype for...

This is exactly what you must not do with EM...

jim.powers (6/12/2008)

---

I had an EM session open before we started the batch. Once the batch was started,...

Great! Glad it worked out.

I would suggest using the SOUNDEX or DIFFERENCE functions. And you do not need a cursor or a While Loop, just use set-based processing.