Hello Andrew,

I am seeing the same message in our logs. Did you ever find a good answer?

Thanks,

Keith

Hello Ron,

I tried running your script and I received the following error message.

Line: 626

Char: 2

Error: Unterminated entity reference - matching ';' not found

Code: 80040008

Source: Windows script host

Any ideas as...

Looks good. Thanks for your help.

Keith

Thanks Ken. Your last post sorts the data great.

Wilbur gave a good solution that involved using a function and I appreciate it. I was just curious if anyone else had a solution that could be more portable (with...

The new function does work for the sample data set. When I get a chance I am going to try it on a larger data set and will let you...

Just tried your function. The new data set comes back like below. It doesn't seem to do well if there are two of the same number even though the beginning...

Thanks for the quick reply. I should have given a better data sample, Sorry. When I try

SELECT YourCol

FROM YourTable

ORDER BY

        LEFT(YourCol, 2)

        ,CAST(SUBSTRING(YourCol, 3, 3) AS int)

it works great for the...

Great article. Thanks for taking the time and good luck getting the next part into words. Also the comment about bad management is a sign of a sinking ship is...

Found the culprit so I wanted to post it in case anyone else runs across this. My colleague recently installed the Visual studio Service pack 6. Backed out of the service...

Unfortunately I found that out a few moments ago when I looked at the version features compare page http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx 

Does anybody have some feedback on this? I just downloaded SQL 2005 Express and I seem to be having the same issue. thanks

Keith

Thanks. The page looks like it is going to give us some options.

Keith

Thanks for the responses. The replmonitor role worked great until I was then told to make sure the user could run merge agents. After reading through Books Online again I...

Does anybody have any thoughts or recommendations? thanks

Keith