Application may fail with buffer size error when we move the SQL Server CE database between Desktop Windows OS and WM/WCE.

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 the buffer size. The default size can be increased on initialization by modifying the ssce: max buffer size property. [ The default…

1

Parsing larger XML file using “sp_OACreate” returns incorrect values

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 the objects  created else it might run out of memory causing the application…

1

You get an error when you attempts to save SSIS packages to the MSDB package store if the network packet size >=16388 Bytes

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 0x80004005 (Communication link failure).The SQL statement that was issued has failed. Attempting to…

4

Who owns my job and who runs it?

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 (could be a domain account or SQL). Now, the…

1

Connection leak , its symptoms and troubleshooting

  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.com/en-us/library/8xx3tyca(vs.71).aspx http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;191572 Connection leak basically happens when we open a connection to the database from our application and forget to close it, or…

0

Things to know before developing MS XML applications.

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 side by side. Which means that you system might have…

1

SQL Connectivity errors related to SPN and troubleshooting them.

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‘ 4) Cannot generate SSPI context We get these errors when we use windows authentication and there is…

3