“Must declare the scalar variable” error in Toad for SQL
There are different execution needs depending on what you are doing. See when you need to use F5 and F9.
There are different execution needs depending on what you are doing. See when you need to use F5 and F9.
Error: Trying to install .NET Framework 3.5 Features on a Windows Server 2016, either through GUI or PowerShell, returns below error (truncated): “The request to add or remove features on the specified server failed. Installation of one or more roles, role services, or features failed. The source files could not be found.” Cause: .Net Framework…
Error: Refreshing Power BI report generates “The key didn’t match any rows in the table” error. Cause: Click “Edit Queries” button. If you do not see the error message, click “Refresh Preview” button. Once you have the error message, click “Go To Error“. Error message will remain, but you should have “Edit Settings” button now,…
Symptoms Did your SMS_OBJECT_REPLICATION_MANAGER component shows a lot or 6004 MessageIDs with the following description: “Object Replication Manager failed to process Object changes. These changes will be retried on next processing cycle.”? Cause By design, maybe. Resolution Run the following query in SQL Management Studio (Warning! modifying the database directly may not be supported by…
Symptoms You make changes to a package and update your distribution points. Shortly you receive error messages in Component Status for SMS_DESPOOLER component. Status message details is similar to the following: Cause The destination drive where site server is uncompressing the package is full. Resolution If you don’t know the drive where the package is…
While installing the latest “Forefront Client Security” product named Forefront Endpoint Protection 2010 (RC version), the prerequisites verification step displayed an error at the “Verifying restart is not required” step. And the error details: “An earlier software installation still has outstanding file rename operations pending. Before Setup can continue, you must restart the computer.” The…
I had to install a copy of SQL Server 2005 on a Windows Server 2003 R2 SP2 x64. During installation I got a strange error saying that SQLncli_x64.msi file is missing. I was pretty sure that I have the same ISO file as I did while installing SQL so many times before and without any…
Today I again learned a lesson I knew for some time but was hoping that I can forget it. The lesson was about: “Trust anyone. Test for yourself.” Having to install WSUS on a remote SQL 2005 that had WSUS database installed before, I asked one SQL guy if renaming the old WSUS database is…
If you receive the following error: “An error occurred while retrieving policy for this computer (0x80072EE7)” when Task Sequence Wizard starts, this can happen if you have DHCP or DNS problems. You should check if you can contact the DHCP server in order to get an IP address or you can configure a static IP…
I just spent half an hour trying to understand why my task sequence cannot find the files on a distribution point; although the TS runs normally, I see all available TSs and I can choose the one I need. Then I found why: I missed something I never missed before and that must not be…