Symptoms If we move the SQL Server CE database from one platform to another platform, the application may fail with the following error message Exception type: System.Data.SqlServerCe.SqlCeException Message: SQL Server Compact has exceeded...

sp_OACreate is a way to instantiate OLE / COM objects inside of SQL Server in the MemToLeave area of the server’s address space, or out of process in dllhost.exe. Whenever you instantiate a COM object using sp_OACreate method you need to destroy...

In SQL Server 2005 if you configure network packet size to 16388 or greater, and attempts to save SSIS packages to the MSDB package store, It will fail with the following error message: The SaveToSQLServer method has encountered OLE DB error code...

There has usually been confusion over who owns the SQL Agent job and who runs executes the steps. Let’s look at combination of scenario where we try to set-up a package as SQL Agent job. Scenario A: Job owner is a login which is a sys-admin ...

  To know about connection leak you first need to have a basic idea of connection pooling. If you are not sure about connection pooling please visit the following link –: http://msdn.microsoft.com/en-us/library/ms810829.aspx http://msdn.microsoft...

XML is a method for putting structured data in a text file . Microsoft XML Core Services (MSXML)  adhere to the XML 1.0 standard. MSXML can be installed both in replace mode and side by side. For example, starting MSXML4 all the versions are installed...

You might get the following error when there is any issue related to a SPN in the environment: 1) Login failed for user ‘null’ 2) Login failed for user ‘’ 3) Login failed for user 'NT Authority\Anonymous Logon‘ ...