Question: How to Assign Multiple Variables in a Single T-SQL Query?
SQL SERVER – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
While playing with my virtual machines, I screwed up something and my SQL service for my named instance was failing to start. Let us learn about a startup error.
When I tried to start via services.msc, here was the error
SQL SERVER – Message: “Please wait for the System Event Notification Service” When Trying to Logoff from RDP Session
I must tell you that there could be many reasons for this behavior, but in this blog, I would talk about a cause which was due to SQL Server. Let us learn about how to fix error related to the Notification Service.
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
One of my blog reader told that they are having trouble with linked server to AD. SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server. Let us learn about error related to OLE DB Provider.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
Recently, one of my clients contacted me to understand why they are seeing such messages in their application event log. Where it says The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
Due to development challenge people still use SQL 2012 in production. In one of the case a client told me that their application vendor has not approved SQL 2014 and above, so they were forced to install SQL 2012. There were getting below error while trying to install SQL Server 2012. Let us learn how to fix error while enabling windows feature.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
Due to my connect with my many clients, learning never stops for me. Almost every day someone sends me email for quick 55 minute consultation. You can read more about it over here about how to fix error related to SQL Catalog.