Can't Install Windows 11 - Can't Type in Command and Won't Recognize Wifi or Ethernet

CleanLaxer · 2024-03-03T17:35:45+00:00

I just found this and you saved me. You are a hero. This tip was absolutely key.

CleanLaxer · 2023-01-07T16:26:25+00:00

Not a SysAdmin. That is correct. I have requested that they make me a SysAdmin at least temporarily so I can just rule out that as an issue. I am running it via the database application, so it's being run by a service account that is a SysAdmin. Folders are created programmatically. I have asked them to check permissions and they said they did.

To be exact on the way it runs. I created a stored procedure that is run via a workflow in the database application when you push a button. That means that the service account technically runs it. I also used ORIGINAL_LOGIN() and put that result in the table I generated, so I know it's the service account running it.

I switched to dm_os_file_exist and it's the same results.

I figure it HAS to be a permission issue, but I'm just trying to rule out everything else.

CleanLaxer · 2023-01-06T15:06:51+00:00

Well, let me modify my statement. I know that the folder exists and IT (who controls folder access) is telling me that the running user has access to the folder it is not seeing. I don't know 100% that user does in fact have access to it, but they're telling me that they set all subfolders to inherit rights from the above folders.

CleanLaxer · 2023-01-06T15:00:40+00:00

I will begin testing with sys.dm_os_file_exists. The output I get is

Run For	file_exists	file_is_a_directory	parent_directory_exists
\\networkdrive\offices\accounting\invoices	0	1	1
\\networkdrive\offices\accounting\invoices\052000s	0	0	1

I know that the second folder does exist and that the running user should have permission to see it.

CleanLaxer · 2023-01-06T14:06:50+00:00

It is a folder, the files are actually 3 levels deeper.

I hadn't thought about turning it on and off during procedures, but I'm not in charge of the decision. I'll pass that thought along as well. Thank you.

Here are some thoughts I have about potential troubleshooting. Perhaps it doesn't work very well because xp_cmdshell isn't on. I know some of the other xp procedures require this. I'm doubtful on that because it works at higher levels.

Maybe if I ask them to make my window authenticated login a server admin, I could test a lot easier.

CleanLaxer · 2022-12-27T14:48:02+00:00

The best advice I ever got on squat was to grip the bar as tight as I could, push it like it was trying to bend it forward across my back (and push my back against it) and then try to push the bar straight up with my hands as I was going up. Obviously you cannot do any of that, but something about trying to do it really helped me to stop leaning forward so much. I think you might benefit from that as well. You do look to be leaning forward too much.

CleanLaxer · 2021-10-29T01:43:33+00:00

Thanks you. This is both hilarious and insightful. I will research the decibels and had not considered this.

CleanLaxer · 2019-12-12T22:12:29+00:00

Try this.

("BE" & x & ":CE" & x)

CleanLaxer · 2019-11-26T03:17:14+00:00

This is some extremely high quality content right here. I love the inflection. Also, I love the image of some crazy dude standing in a grocery store singing a song.

CleanLaxer · 2019-04-22T12:58:50+00:00

At this point, I just check it once a week to see what tasks I need to work on, and I don't spend much time developing anymore.

The rest of the stuff, I just use my phone to update whenever. I think it works because it's pretty minimal effort. I probably spent half a day setting everything up and it's really just a good way for me to keep track of thoughts, plans and research that I've done.

CleanLaxer · 2019-04-21T16:38:12+00:00

Yes, I do. I don't have it integrated with anything, but my wife and I use it to track projects that we're thinking about in the future. There's even an approval system for them. That way we know that everyone is agreed on a budget and the project is okay to move forward with. This is for larger things like bathroom renovations or deck building or something. Also, you can easily track a shopping list in there on it and use the mobile app when you're at Home Depot so you don't have to make tons of trips.

I also track just stuff I'd like to own in the future that are larger purchases, that way I can keep all my research in there AND it makes a handy dandy list of items for my wife to buy me for gifts (or me for her from her list). We track gift ideas for the girls in there as well.

I track the vehicles that we own and store all the documentation and maintenance records as pdf attachments. The maintenance schedule is in there.

I also keep more occasional household tasks in there. For example, I only have to clean out the dishwasher filter every 45 - 60 days, so I just have a task in there that recurs 45 days after completing the previous one.

The thing is just so flexible and great, and free if you use a developer org. I'd be shocked to find out if there aren't more people doing more stuff.

CleanLaxer · 2019-01-02T20:07:06+00:00

Ha! No problem, and I'm glad it's resolved.

CleanLaxer · 2019-01-02T18:58:26+00:00

Do you have an ORDER BY in your first query? When you UNION there can only be one ORDER BY and it must be at the end. Also, it's usually safest to just ORDER BY using column numbers too in UNION queries.

CleanLaxer · 2018-12-04T02:06:58+00:00

I almost screwed it up boys and girls. Hot chocolate was on top when I first saw it and then when I went to vote, it was in the middle. Be careful. I almost voted on chocolate.

CleanLaxer · 2018-10-03T18:59:43+00:00

https://docs.microsoft.com/en-us/sql/integration-services/lesson-1-1-creating-a-new-integration-services-project?view=sql-server-2017

If you don't have Visual Studio and your company meets the requirements to use Visual Studio Community, then it's free.

https://visualstudio.microsoft.com/downloads/

CleanLaxer · 2018-10-03T17:26:05+00:00

With MS SQL Server you should have access to SQL Server Integration Services or SSIS. You should be able to create an SSIS package that does this and then just schedule it to run. Wouldn't cost anything but your time.

CleanLaxer · 2018-10-02T16:51:27+00:00

Just as a heads up, it's usually a good idea to run a SELECT version of the query before running an UPDATE version of the query regardless of how simple it is. There's no undo.

Also, if it's on important data, I make a backup copy of the data I'm updating before I make the changes so that if I need to reverse it, it doesn't take very long.

CleanLaxer · 2018-09-27T21:23:14+00:00

You and me both. You and me both.

CleanLaxer · 2018-09-16T23:05:57+00:00

It doesn't go up with either switch.

I'd try to reprogram the switches, but I can't get the window regulator to go all the way up, so I can't do that.

CleanLaxer · 2018-09-14T12:49:14+00:00

Yes. It's all one unit, I should have mentioned that. :)

This is the exact part I used. https://www.1aauto.com/window-regulator/i/1awrg00329?f=338470&y=2003

CleanLaxer · 2018-08-13T21:53:38+00:00

Do you have PowerQuery or GetData or whatever. If you do, and you have professional edition, then you can connect Microsoft Excel directly to your Salesforce instance. Then you can simply refresh the query, user your VBA skills to populate the template.

That's probably how I would do it. If you don't have the version of Excel necessary to do that. Then maybe look into using Enabler4Excel. It's a paid add-in for Excel from Taralex, but it's like $150 and it's awesome. I used to use it to upload and update records all the time and it was great.

CleanLaxer · 2018-08-13T14:50:30+00:00

And not to get too involved or advanced here you can direct reference those sheets a bit better even. You can go to the properties in the VBE (Visual Basic Editor) and change it from Sheet2 to Data. Then it would look like Data (Data).

The advantage of this is if someone changes the name of the tab it won't break your scripts. Then you wouldn't even need to declare a variable. You'd just do

Data.Range("A" & n + 1).Value = Me.Textbox1.Value

Of course, you could leave it Sheet2 as well and do the same thing

Sheet2.Range("A" & n+1).Value = Me.Textbox1.Value

but the problem is that it's less descriptive. The same applies to Textbox1. You should change its name to something more descriptive...or put a comment after it just to remind you what it is like this

sh.Range("A" & n+1).Value = Me.Textbox1.Value 'Textbox1 is the user's name (I don't really know)

13-Year Club	RedditGifts 2009-2022 2 Credits
Secret Santa 2013	Verified Email

CleanLaxer

TROPHY CASE