Thanks very much. Rather then continuing to go in circles I turned to C# to get this to work. However, now that I have something to chew on I will...

Thanks Eugene, that solution worked great with the update I needed to make:

Here is what ultimately did the trick...

select ID, GroupNumber

into #LogFileTracker

from dbo.logfiletracker

where groupnumber = 4441

and statusbit is null

;with cte

as

(

...

This appears to work for my purposes:

DECLARE @count int

BEGIN

SET @count = (select count(groupnumber) from dbo.tbl4441 where groupnumber = 4441 and statusbit is null)

WHILE @count <> 0

BEGIN

UPDATE t

SET t.GroupNumber= 4441, statusbit...

Thank for the suggestion. Found something that looks promising:

UPDATE t

SET t.GroupNumber= 4445, statusbit = 1

FROM

(SELECT ROW_NUMBER() OVER (ORDER BY groupnumber) AS Seq,*

From dbo.tbl4441)t

WHERE t.Seq IN (1)

and t.statusbit is null

Note there...

Thank you very much opc.three. It does help a great deal!

opc.three (3/8/2012)

---

Not security related, but relevant if you use the PowerShell subsystem in SQL Agent. Make sure you choose a...

The nested Replace statements worked great! Thanks Phil and Shawn!

Thanks Koen. I will check with the Admin to see if I am in the Distributed COM Users group.

Thanks for the reply. Unfortunately the package was run manually outside a job. Thre is no logging in the package and no auditing configured on the server. It was also...

I might add that this was a manual run of the package. Not scheduled through Jobs nor is there any configured logging in the package itself.

This tool you reference looks very promising :). I haven't yet tried to install it but if it works then no more messy external PowerShell files to deal with. At...

Great advise! Again thanks so much!

opc.three (2/18/2012)

---

You are correct...

Sorry about the name confusion :-S. I must say that both the solutions (PowerShell & T-SQL) are very elegantly done.

I do like PowerShell because it is so integrated with...

You guys appear to have a great grasp on working with Regular Expressions and PowerShell. Any resources (books, articles, etc...) that you can recommend?

BTW, SSCrazy that was cool how you...

Thank you both so much for your help!

SSCrazy, that script is guenius. I will learn a lot from that script. Life saver!

Good FYI and thanks! That will most definitely help me in the future.