List out all triggers in a SQL Server database

Execute the below query to get the list of triggers SELECT sysobjects.name AS trigger_name ,USER_NAME(sysobjects.uid) AS trigger_owner ,s.name AS table_schema ,OBJECT_NAME(parent_obj) AS table_name ,OBJECTPROPERTY( id, ‘ExecIsUpdateTrigger’) AS isupdate ,OBJECTPROPERTY( id, ‘ExecIsDeleteTrigger’) AS isdelete ,OBJECTPROPERTY( id, ‘ExecIsInsertTrigger’) AS isinsert ,OBJECTPROPERTY( id, ‘ExecIsAfterTrigger’) AS isafter ,OBJECTPROPERTY( id,… Read More

Search a text in whole database in SQL Server

exec SearchText ‘SearchText’, 0   Create  PROCEDURE [dbo].[SearchText] @DataToFind NVARCHAR(4000), @ExactMatch BIT = 0 AS SET NOCOUNT ON DECLARE @Temp TABLE(RowId INT IDENTITY(1,1), SchemaName sysname, TableName sysname, ColumnName SysName, DataType VARCHAR(100), DataFound BIT) INSERT  INTO @Temp(TableName,SchemaName, ColumnName, DataType) SELECT  C.Table_Name,C.TABLE_SCHEMA, C.Column_Name, C.Data_Type FROM    Information_Schema.Columns AS… Read More

Ports to be opened before installing Microsoft Dynamics CRM 2016

When you install Microsoft Dynamic CRM  with SQL Server you may come across this error The SQL Server ‘SQLServerUsedforCRM’ is unavailable. System.ComponentModel.Win32Exception (0x80004005): The network path was not found at Microsoft.Crm.Setup.Common.Utility.NetworkUtility.GetJoinDomainName(String server) at Microsoft.Crm.Setup.Server.CrmSqlDomainValidator.InternalCheck(IDictionary parameters)   On the CRM server unblock these ports  80,135,136,139,443,445,123,137,138,445,1025 On… Read More

Resolved:- No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’. Make sure the provider is registered in the ‘entityFramework’ section of the application config file.

No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’. Make sure the provider is registered in the ‘entityFramework’ section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information. Solution:- Install Entity Framework using NuGet, right click on Reference and click… Read More

The connection string ‘Connect’ in the application’s configuration file does not contain the required providerName attribute.\

<connectionStrings> <clear/> <add name=”ApplicationServices” connectionString=”Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True”/> </connectionStrings>   Solution:-   You’re missing the following piece of code after the connectionString attribute (assuming that you’re using SQL): providerName=”System.Data.SqlClient”   Change to <connectionStrings> <clear/> <add name=”ApplicationServices” connectionString=”Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True” providerName=”System.Data.SqlClient” /> </connectionStrings>