Recent content by sumgirl

Hi all. I want to script out a process to identify all local efs certs on a users machine so I can then use cipher.exe to export them and move them to that users new machine during a refresh process. Its possible that a user will have more than one cert and/or that a machine might even be shared...

Sorry, totally obvious detail I left out I guess. Assuming I want to block telnet access to from external world in through PIX. Again, I know very very little and I am just trying to get moving in the right direction. Wish there was a dummies / all you need to keep things running type of book!

Admittedly basic, but how would I block telnet? Should I do that in the PIX or is it best to do that on router or switch? I have inherited this stuff, and no one else around now to do it...so just looking for basic starting points.

Hi all. I am wondering if its possible to use WMI to get a list of all the handles an executable is using? An example of that function can be seen in the object window of sysinternals process explorer. Anyone help?

Hey all...I want to list IE addons on a remote machine. Anyone know how that can be done? I have seen several kbase articles on some reg settings, but that seems to assume you are controlling addons via GPO which my company does not. Please help!

Hey all...I want to try to use a script that allows nontechnical / locked down users to know what wireless network they are connected to. Problem is sometimes a machine cant connect to an intended preffered wireless access point and the machine connects to some neighboring open point and the...

Hang on, this worked: With Sheets(3).Columns("A:H") .Sort Key1:=.Cells(2, 1), Order1:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End With Thanks for getting me on the track.

Hi Skip, I got seriously excited for a second, but when I copy and paste that right into my vba, I get an error: Run-time error '438': Object doesnt support this property or method With this higlighted: .Sort Key1:=.Cells(2, 1), Order1:=xlAscending, _ Header:=xlYes, OrderCustom:=1...

Hey all, I need to sort a hidden worksheet, and unhiding it to allow the sort is not really an option. I have some vba code that works great for a visible worksheet, but of course makes in its pants when ran against a hidden one...can someone help?: ----------------------------...

Thanks George, that works great. To answer your question Alex, I do not yet have SQL Server 2005, but I made a note about the unique rowid stuff you mentioned, so thanks.

I know its weird, please dont make me explain or defend it, but I need to update multiple records in a table with a replace and I need to do so a single record at a time. I find the following code works SOMETIMES: -------------------x------------------- DECLARE @CNT INT SET @CNT = 1 WHILE(@CNT <...

That got it! Thanks jbenson001, this method has all kinds of obvious uses for me!

I tried that jbenson001, but I keep getting "Incorrect syntax near the keyword 'select' on line 3." I can pull the select out and execute it seperately with no problem, and it returns one value as expected. I appreciate the help all.

I know this is lack of expertise / experience and probably totally doofuslike for this form. Heres what I started with, and I have tweaked a bit here and there and cant make it work: DECLARE @SQLvar nvarchar(200) DECLARE @SQLwork nvarchar(200) SET @SQLvar = 'select pkgsourcepath from v_package...

I did a search on dynamic SQL and was instantly lost. Any chance you could post an example based on my question so I can try and understand knowing what the results would be?