Hi,

Its working perfectly 🙂

I must have had a brain freeze! I tried exactly that earlier on but was getting duplicate results (in other words I was doing something stupid and...

Just a shot in the dark...

What if you run a bunch of inserts into a dummy table (you can work out how may) with a BEGIN TRANSACTION but no commit....

well, it looks like I solved it... all I needed was a good night sleep 🙂

Turns out that my Route for Service2 was using the sending service instead of the...

The indentation uses some weird characters. In my case I pasted it into an advanced text editor and they came up with question marks. I just replaced the question marks...

Thanks, I will get our guys to contact Microsoft for this.

dematerialising the views is possible as a last resort, but I would prefer that we didnt as it would have...

Thanks George,

I will get SP4 installed and take it from there.

You are also correct, the system is generating dump files, but I do not know how to analyze them.

I know...

Rich.Gamble (7/15/2008)

---

Provided script failed to create sp_utl_FindMisMatchedObjects in SQL Server 2005 with the following error:

Msg 4145, Level 15, State 1, Procedure sp_utl_FindMisMatchedObjects, Line 26

An expression of non-boolean type specified in...

Thanks for the input Noel, Ill read up on that.

Kudla, the parameters are sometimes the same, and somethimes not the same. made no difference in this case.