Sok esetben küzdök az alábbi vagy hasonló hibaüzenetekkel: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {D63B10C5-BB46-4990-A94F-E40B9D520160} and APPID {9CA88EE3-ACB7-47C8-AFC4-AB702511C276} to the user NT AUTHORITY\SYSTEM SID …

Ismét egy ki nem javított SQL Server hibába futottam bele. A történet alapját több, általam átnézett SQL Server szolgáltatja. Természetesen a tranzakciós log nem felesleges, csak nincs értelme egynél több file-nak, normális esetben. A probléma Van egy adatbázis, aminek két tranzakciós logja volt. Értelme ugyan nincs, …

I love when people set up alias for their SQL Server installation; and wondering why it is not working (Of course complaining to DBA’s that the SQL Server remote access is not enabled 😉). Well, remote access is just fine, alias as well… then what can be the problem? Let’s see in a real world scenario: Running an …

Hahh, my favourite infrastructure team built a development box and handed over to me. The first shocking error message I got: =================================== The Activity Monitor is unable to execute queries against server %s Activity Monitor for this instance will be placed into a paused state. Use the context …

This is a very funny error message 😊. I saw, you guys are looking for this, but it was published in Hungarian. Now I translate the article to English. You got this error message when you are trying to schedule an SSIS package. This occurs because of the different service packs for the SQL Server installation. You …