BUG
303 TopicsBug: "Invalid column name" after sp_recompile for valid column in custom data type
Hello, I was hoping to find a workaround for an issue I am having. I believe this is a bug in SQL Server (we are using SQL Server 2022) I have written a utility stored procedure for solving the gaps and islands problem, utility.GetTimeIslands, which returns the longest contiguous islands from the time islands passed into it. This procedure utilizes a custom datatype, utility.TimeIslandList, which is defined as CREATE TYPE utility.TimeIslandList AS TABLE ( ISLAND_ID BIGINT NOT NULL, KEY_1 BIGINT NOT NULL, KEY_2 BIGINT NOT NULL, KEY_3 BIGINT NOT NULL, START_DATE DATE NOT NULL, END_DATE DATE NOT NULL, PRIMARY KEY (ISLAND_ID) ); The call to utility.GetTimeIslands in PRC.LoadDeals is DECLARE Til utility.TimeIslandList; INSERT INTO Til SELECT STG_DEAL_SCHEDULE_ID, DEAL_ID, PRICE_ACCOUNT_SET_ID, PRICE_ITEM_ID, START_DATE, END_DATE FROM #DealSchedulePrep; INSERT #LatestTimeIslands EXEC utility.GetTimeIslands Til; If PRC.LoadDeals is called after a server reboot, or after EXEC sp_recompile 'utility.GetTimeIslands'; Is called, it throws the error "Msg 207, Level 16, State 1, Procedure utility.GetTimeIslands, Line 60 [Batch Start Line 8] Invalid column name 'KEY_3'." Line 60 corresponds to the first statement in utility.GetTimeIslands where the custom data type is referenced WITH ChangePoints AS ( SELECT KEY_1, KEY_2, KEY_3, START_DATE as X_DATE FROM Til UNION SELECT KEY_1, KEY_2, KEY_3, DATEADD(DD, CASE END_DATE WHEN '9999-12-31' THEN 0 ELSE 1 END, END_DATE) FROM Til ) ... However, if DECLARE Til utility.TimeIslandList; EXEC utility.GetTimeIslands Til; Is called prior to calling PRC.LoadDeals, then PRC.LoadDeals does not throw the error. And PRC.LoadDeals will execute successfully until utility.GetTimeIslands is recompiled. Another interesting twist is that adding those lines to PRC.LoadDeals, prior to the actual call, does not help. It throws the same error on the empty call, if the empty call is made inside the stored procedure before the empty call is made outside the stored procedure. For that matter, once any call is made to utility.GetTimeIslands outside the stored procedure, calls made to it inside the stored procedure will work. Has anyone ever seen anything like this? If so, is there a solution outside of making the GetTimeIslands empty call after each server restart? Does anyone have a guess as to why the error message calls out KEY_3 specifically?50Views0likes1Comment[Wayland] PWAs no longer appear as separate app windows — all group under main Edge icon
Hi, Since around 2025-09-07 to 2025-09-10, I’ve noticed that on GNOME (Wayland) all installed PWAs (even across different profiles) now appear grouped under the main Edge browser icon in the GNOME Shell dash/taskbar. Previously, each PWA would open in its own window group with its own icon. This is still the behavior in Chromium/Brave/Chrome, and can be restored there by editing the PWA’s .desktop file to set: StartupWMClass=<same value as Icon> However, Edge now seems to ignore StartupWMClass completely on Wayland, breaking workspace separation and making task switching hard. Environment: Ubuntu 25.04 GNOME 48.0 / Mutter (Wayland) Kernel 6.14.0-29 Intel Iris Xe GPU Edge (latest stable, observed post 2025-09-13) Repro steps: Install any PWA (e.g. Outlook, Teams, Spotify) from Edge Launch it (from any profile) Observe that it appears grouped under the main Edge browser icon Expected: PWA shows under its own icon and window group like in Chromium-based browsers Actual: All PWAs are bundled into the main Edge window group Editing StartupWMClass in the .desktop file no longer helps This regression makes PWAs much harder to manage on Wayland. Please route to the Linux/Wayland team if possible. Thanks!254Views6likes6CommentsCritical Pen Hover & Stray Ink Issue on New Surface Pro 11 for Business with Slim Pen 2
Hello Microsoft Community and Support Staff, I am writing to report a critical and seemingly widespread issue with the pen input on the brand-new Surface Pro for Business, 13-inch (Intel model, often called Surface Pro 11 "Luna Lake"). The Core Problem: Pen Draws Without Touching the Screen When using the Surface Slim Pen 2, the device begins to register ink input while the pen is still hovering a few millimeters above the screen. It does not require any physical contact or pressure. This "hover-inking" makes handwriting completely unusable. As I write, any time I lift the pen to start a new letter or stroke, the pen continues to draw a line as it moves through the air to its next position. This results in messy, connected handwriting with unwanted "tails," completely defeating the purpose of having a premium inking device. This is Not a Defective Unit - It's a Replicable Problem Initially, I thought I had a faulty device. However, to isolate the issue, I have performed extensive testing: I have personally tested this on [3] brand-new Surface Pro 11 (Intel) devices. I have used [4] different Slim Pen 2s. The exact same hover-inking problem occurred on every single combination of device and pen. Furthermore, I have already performed all standard troubleshooting steps, including: Clean OS installation via Surface Recovery Image. Ensuring all Windows, driver, and firmware updates are installed. Running the Surface Diagnostic Toolkit (which reported no errors). However, the same issue continues to occur even after trying these methods. Additionally, it has been reported that the issue also appears on the latest Surface Pro 12-inch model with the Snapdragon X Plus, just like on the Surface Pro 11 that uses the Qualcomm Snapdragon X Elite instead of Intel’s Lunar Lake. (I do not own any Snapdragon devices myself. If you own a Snapdragon device and are experiencing the same issue, please share your feedback.)" Video Evidence: I have recorded a clear video demonstrating the problem. It shows the pen drawing while hovering on the Surface Pro 11 and makes unwanted tails on handwriting letters. Video Link: https://youtube.com/playlist?list=PLG_7BXFA-cL4evqe0RmRz--iFjDC1HVgT&si=EmEypaAqSyRozr67 Questions for Microsoft: Is this a known issue with the new Surface Pro 11 (Intel) model's firmware or drivers? What are the official steps to escalate this issue directly to the Surface engineering team for a fix? This is a major flaw in a flagship product that severely impacts its core functionality. I have submitted a formal bug report through the Feedback Hub, which can be found here: Feedback Hub Link: https://aka.ms/AAxzh27 I urge the Microsoft team to investigate this with high priority and release a firmware or software update to recalibrate the pen's Initial Activation Force (IAF). Thank you for your attention to this serious matter.25Views0likes0CommentsMS Edge - Sidebar and copilot not working on Linux Ubuntu v24 LTS
Sidebar not syncing or accepting new app additions (+). Copilot button is dead/inactive. Sidebar settings are well configured. Using the latest version of the Ubuntu OS and MS Edge. Functionality appears to be absent as product was released without full functionality....Lame!21KViews37likes56CommentsMica issues again (title bar + context menus)
Weird bug again - in both Stable/Dev the title bar mica effects are not working, but the dropdown & context menu (three dot settings) is. In Canary, the title bar mica effect *is* working, but the dropdown/context menu is not (solid white). I reported via feedback as well. Canary: Dev/Stable:81Views0likes2CommentsSynchronization issue
I have an active Microsoft 365 subscription. My wife and I share Microsoft To Do lists. We recently noticed a synchronization issue: When she creates/deletes/updates tasks, they sync to me. When I create/update tasks, they don’t sync to her. When I delete tasks, they are deleted for her. We’ve already signed out and back in, and tested on different devices and platforms. Permissions are correct, and everything used to work before.445Views4likes8CommentsProblem with the option to prevent customers managing their bookings
We have used Microsoft Bookings for several years to let our customers book services with us but we're noticing a trend that the customers tend to rebook their appointments an excessive amount of times which often leads to available spaces on group bookings being wasted. It also increases the admin time because each rebooking needs to be processed again so that the necessary preparations for the customer can be made. One idea we have to try and keep things under control would be to say that the customers should only book the service one time so that we can administer their bookings one time only and then if they miss their appointment time they could just "drop-in" because all the necessary preparations would have already been made for them. But I don't think this will change the behaviour with how the customers keep moving their bookings. What we really need is the option to prevent the customers from cancelling or rebooking their times themselves. I am aware that there is an option to "Let customers manage their appointments" but this feature seems to be broken! To disable the option you have to go into the calendar and select the group booking. In the pop-up window underneath the "Added Customers" you can disable the option to prevent the customers from managing their appointments. When you do this it takes away the reschedule and cancel buttons but it only works as a temporary measure because as soon as a new person books a place on the same group booking then the option becomes automatically enabled again! Then all the previous customers can also see the reschedule and cancel buttons again. It feels like this part of Microsoft Bookings is broken and unusable at the moment. The only way I could imagine it working at the moment is if a group booking runs out of free spaces and then nobody else would be able to book a place so if you manually disable the option at this point then would remain disabled for everybody. But until the appointment time runs out of spaces then people are just going to keep moving their bookings around. You could probably keep manually disabling the option when new bookings are made but this also adds to the admin time and it doesn't seem like a very practical workaround. Another idea we have had is to set a longer "minimum lead time" because this is another way to prevent people from cancelling and moving their bookings but it reduces the flexibility of when the services can be booked. But we're actually going to try this idea and see how it affects things along with changing the information to try and make the customers aware that they are being restricted to one booking. We hope that the option for the customers to manage their own bookings gets fixed soon. It also does not make much sense that it needs to be disabled per booking in the calendar? Shouldn't this be a feature that applies to every booking for a service instead? I've tried to disable the option on two different booking pages but the experience is just the same, the option just becomes automatically enabled again when a new booking is made.1.2KViews1like1CommentEdge Dev/Canary enterprise extension sync broken?
I noticed on my test system that setting up a new profile in Dev/Canary sync doesn't work correctly - specifically, extensions do not install properly. In my stable channel build everything is working, however when it attempts to sync to Dev/Canary only the "forced" extension I have enabled via policy shows/works, where as the others are not in the extension list, but are present in the AppData user data folder. I've attempted to reset sync and have everything get pulled down again, but the issue persists. I've tried clearing out the profile and re-installing Dev/Canary to see if having it force re-sync would help, but it does not. TLDR - syncing extensions to dev/canary with enterprise sync breaks any extension that is not 'forced' to install via policySolved87Views0likes2Comments