Tuesday, September 29, 2020

Buggish: C# SMO Error The name specified in the TextHeader property of StoredProcedure 'StoredProcedureName' must match Name property.

Error Message

The name specified in the TextHeader property of StoredProcedure 'spName' must match Name property. 


Results

None. I don't why this occurs.


Details

I created code to copy Stored Procedure from one server to another. This has worked have several weeks, and suddenly I have two SP that throws this error. The immediate cause is that the source TextHeader is different from its own name.

StoredProcedure spSource = dbSource.StoredProcedures[spName];


For some reason, spSource.Name is not the same as spSource.TextHeader.


I suspect the developer created the Stored Procedure then renamed it. This is not confirmed.


Edited 8/12/2021

Confirmed that this definitely occurs when a stored procedure is renamed. My fix is to use SSMS to get the alter stored procedure and execute as is. 

Sunday, September 6, 2020

Buggish: Headset microphone not working (used to work) Windows 10, Realtek, audio connection (not USB)

I am not even sure when this happened, but suddenly the built-in mic was being used as the microphone even though it was using the headset microphone for a good period of time. I suspected something was wrong when the mute button no longer worked. I definitely found out when I was talking for a whole call then later realized my mic was up the entire time.

I tried so many different things with the sound and microphone settings in Windows 10. I tried uninstalling the audio driver in device management. I tried unplugging and re-plugging. Nothing worked for me, and none of them made a lot of sense to me because my headset is through the audio jack so it should accept the input as part of the system.

I suspected that the setting must have been set to headphones instead of headset. Then I remembered that I haven't seen the options to choose when I plug in the audio jack. I tried a lot of options to find it. Tried to run the RtkNGUI64.exe file which did not do anything.

I finally got fed with it and just went to look for the RealTek latest drivers. I should have known the auto-check wouldn't do its job. This is the full reinstall which will uninstall and re-install. I had to re-plug the headset to get the options.

I found the download on RealTek but the download took forever. Found the same driver on CNET download: https://download.cnet.com/Realtek-High-Definition-Audio-Codec-Windows-7-8-8-1-10-64-bit/3000-2120_4-77507761.html.

This probably took me a good half day to figure out, and several days of using the built-in mic because I didn't have the time to troubleshoot this. I also realized how little I know about Windows now compared to 10+ years ago. Age...

Friday, September 4, 2020

Gardening: Unguided beginner... do I know just enough to be dangerous to my plants' livelihood?

 I've started an interest in gardening because someone likes to have plants but not maintain them, and I hate seeing things die so I took it upon myself to help but no clue how. Obviously starting with watering them. Then eventually learning about over-watering. Then learning about composting.

I have to say after about 3 months... gardening is very hard. I still have no clue if I am over-watering or under-watering. I live in an area that is very dry, and the top soil is almost desert-like. My plants were doing way better when I started watering. One looks like it is not doing well again. One died which we suspect is over-watering because someone decided to just water that one plant without me knowing. Not only was I already over-watering, it had even more water than I thought. Also the soil did not look well in it.

This is actually quite time-consuming just watering and very-very-light pruning which I still am just guessing on how it works. I spend most of my time on watching videos on seeding and composting. I should probably spend more time on the things I should be doing...

Oddly enough, the experience is actually quite nice and pleasant even though it is hard work and takes up quite a bit of time. I really enjoy watching epic gardening, and like the idea of being more self-sufficient. 

There is just too much information to absorb. Would be nice if gardening was a bit easier... maybe I should consider finding a gardener friend.