I'm adding this to my repository of excellent SQL articles. Very nice job!

lmu92's solution looks to do the trick but I figured I'd post mine as well. Just another way of going about things. This also assumes that we use the start...

I didn't see a "Right click -> Properties -> Options" as one of the choices...:-P

If you bring up the properties of the attribute look in the "KeyColumns" and NameColumn" section. Drill down in both till you see the DataSize...insure that matches what is in...

Not sure if this is exactly what you're looking for but it should get you started down the right path. If you create the below table and put the trigger...

Thanks Steve! Option 1 worked perfectly.

GilaMonster (8/21/2009)

---

Any pattern in when it happens? Any entries in the SQL error log or windows event log that coincide with the time it starts?

What OS, how much memory? Do...

Thanks binko, I'll be sure to run that query in the future to see if we have any stale connections out there.

No rebuilding or stats going on.

No, this problem happens sometimes at 4 am on a Sunday night when I'm sure there are not admins logged into the server to make any changes like that. And...

Is it a stored procedure or is it a sql statement?

select

col1,

REPLACE(col2 , '\' + col1, '')

from dbo.folderTable

That should do the trick as long as your folder names are not the same as the values in column 1. If they are...it...

SELECT @TestAppend = @TestAppend + ', ' + a.MfrCode from (select distinct MfrCode from test) a

Does that give you what you're looking for?

I generally would prefer the subquery over the temp table. I'm not sure if I would see any savings by using the temp table with an index but based on...

Hi Kate,

Does the query below return the needed results?

select person_id,

insurance_payer_id,

RANK() OVER(PARTITION BY person_id ORDER BY insurance_payer_id asc) as 'cob'

from dbo.resequence

If so, you can use the results to update the table.