You are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts to fail. This issue occurs when...

Setup.exe can be patched dynamically on the fly One of the drawbacks of the sql server 2005 setup was that if there was any bug detected in the code of the setup.exe , the patching of the setup.exe was difficult and at times next to impossible. ...

Salient Features of Sql Server 2008 (Katmai) Setup Minimize the MSI code for setup and use MSI code for what it does the best. In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause...

Consider a scenario where on an Active Passive Cluster, while uninstalling an instance of sql2000 patched with Service Pack 4, we see the following error after you click next on the screen where we enter the Virtual Server name. 'The specified virtual...

In this presentation, you will learn about how you could manage SQL resources using resource governer. To view the video in better quality please click on the link: - http://channel9.msdn.com/posts/Managin-SQL-resources-using-resource-governer ...

Connectivity fails while executing queries against SQL through VBA code ************************************************************* When we execute queries against the SQL through VBA code generates the below error - and fails to complete the code execution...

In this video blog we would walk you through a feature introduced from SQL server 2008 i.e. Sparse Columns. Sparse columns are just an ordinary columns that have an optimized storage for null values. It reduces the space requirements for null values...

Consider the scenario where SQL server 2000 IA 64 setup on a SQL server cluster fails with the following error ERROR MESSAGE: Microsoft SQL Server Setup --------------------------- An error occurred while creating virtual server resources for clustering...

In this presentation , you will learn about what are implicit conversions. What can be their implications in the SQL query executions. To see the video in better quality or download please click on the link: - http://channel9.msdn.com/posts/Implicit...

Recently we came across a situation where one of the customer was trying to restore a Database backup using SSMS and while going to Options tab UI failed with the error:   "Length cannot be less than zero. Parameter name: length"  ...

By default, merge replication processes data changes on a row-by-row basis. In many circumstances this is appropriate, but for some applications, it is essential that related rows be processed as a unit. The logical records feature of merge replication...

It is not recommended that you use Outlook 2002 or Outlook 2003 together with SQL Mail and with Internet mail servers that use SMTP or POP3. More info on this is available at http://support.microsoft.com/?id=897349 . Below is a practical workaround if...

For additional details check the link below: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/09/29/end-of-support-for-sql-server-7-0.aspx?wa=wsignin1.0 Regards, SQLServerFAQ

  Issue ================   Recently we encountered an issue where customer performed a planned failover for a mirrored database and after the failover the new principal went into suspect mode because of some reason (which is outside the scope...

If you have multiple full, differential and transaction log backups, there are chances you may end up facing the error below during the restore process. “ This differential backup cannot be restored because the database has not been restored to the correct...