Category Archives: SQL Server

Find all workflows where a field is used (Onprem only)

I have a customer with a TON of workflows and custom fields. I needed to figure out everywhere that a field was used in the workflows. After doing some Poking around in the database I created a simple SQL statement … Continue reading

Posted in CRM 2013, CRM 2015, CRM 2016, Development, Onpremise, SQL, SQL 2005, SQL 2008, SQL 2012, SQL Server | Leave a comment

AsyncOperationBase Table: Here we go again

It never fails, all is going good and then one of our QA environments (on premise) is having Workflow issues. I needed to look into what was happening on the SQL Server to understand what needed to happen. However, the … Continue reading

Posted in Onpremise, performance, SQL, SQL 2005, SQL 2008, SQL 2012, SQL Server | Leave a comment

SQL Server: The instance name must be the same as computer name

Saturday, 11 October 2008 Posted by David Jennaway at 10:11 This is something I’ve posted about on newsgroups, but one of my colleagues encountered it recently, and I think it deserves a blog entry. The CRM Environment Diagnostics Wizard may … Continue reading

Posted in SQL 2005, SQL 2008 | Leave a comment

Debugging CRM Plug-ins, Stored Procedures & Custom Workflow Activities

by Danny Varghese 02.24.09 Whether it’s developing CRM plug-ins, custom workflow activities, or writing stored procedures against the CRM database, the most useful tool I’ve used is the Microsoft Visual Studio Debugger. The debugger allows developers to step through the … Continue reading

Posted in SQL 2005, SQL 2008, SQL Integration Services | Leave a comment

Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008

Microsoft SQL Server® 2008 contains a variety of features that, when implemented properly, can improve the performance of a Microsoft Dynamics® CRM 4.0 implementation and secure the data within that deployment. These Microsoft SQL Server 2008 features include: – Compression … Continue reading

Posted in performance, SQL 2008 | Leave a comment

SQL Server: The instance name must be the same as computer name

Posted by David Jennaway on Saturday, 11 October 2008 This is something I’ve posted about on newsgroups, but one of my colleagues encountered it recently, and I think it deserves a blog entry. The CRM Environment Diagnostics Wizard may throw … Continue reading

Posted in SQL 2005 | Leave a comment

SQL Timeouts in CRM – Generic SQL Error

David Jennaway – Microsoft Dynamics CRM I often find myself answering forum posts about SQL errors (the most common error is ‘Generic SQL Error’). By far the most likely cause of this error is a timeout when accessing SQL server. … Continue reading

Posted in SQL 2005 | Leave a comment

Integrating CRM using SQL Integration Services (SSIS)

Darren Liu of the Microsoft Dynamics Team has an alternative approach of integrating with MSCRM using the new SQL Integration Services which replaced the SQL 2000’s DTS. If you are good with SQL and a C# programmer this is an … Continue reading

Posted in SQL 2005, SQL Integration Services | Leave a comment