I wanted to give him a little more information than that.

I figured he would be able to pull that one off by himself.

I'm a little rusty but how about something like this?

select top 1 with ties

LogsID, len(Location), Location

from [LOGS]

order by len(Location) desc

Thanks.

I'm a little new to this end of things and if you could explain a couple of the points you brought up I would appreciate it.

Why cap it at 6gb?

It...

Thanks. Sounds promising, as it's using a domain account.

Can't run an RSoP myself so I floated it by an NA.

He'll get around to looking into it, eventually.

Yes.

It's third party and the vendor is slow to make any changes.

However, it is not wholly their fault, as everything is highly regulated (and, beyond that, there is also a...

Yeah.

Therein lies the source of my problem.

I can't really change anything.

Sorry. As GilaMonster pointed out, I may have been a little carefree with the terminology. It's not a deadlock situation but rather a case where the whole system is effectively...

Unless the unknown is a negative number of beer cans.

It could happen!

I heard it from a guy who heard it from a guy...

Well I'm glad you worked it out.

Good luck with the rest of your fixes.

That's very strange.

The only thing else I can think of is that the stored procedure returns multiple resultsets.

create procedure usp_MyStoredProc
as
begin
   select *
   from(select 1, 1 union...

Could it be that the stored procedure is really returning duplicate rows but you can't tell because it looks distinct with the current sort?

There may be a Join you haven't...

Could it be the extra N in 'KANSASCOMMERCE\\Admininstration'?

I don't think you need to escape slashes.

(Though, an underscore in the pattern should probably be replaced with [_])

WHERE (PATINDEX(('%,' + REPLACE(SecurityGroupReferenceID,'_','[_]')...

That's why I didn't presume it was an int.

Aside from resorting to dynamic SQL (and all the worries that go with it), you may want to make a UDF that returns a table from a delimited string:

WHERE (SecurityGroupReferenceID...

I don't have SQL Server 2005 but this is how you do it in SQL Server 2000:

(If you really want to set up a job for this, that is.

You...