Skip to main content

Posts

Featured

Find Table Name Associated with a Trigger in SQL Server

 SELECT      t.name AS TriggerName,     OBJECT_NAME(t.parent_id) AS TableName FROM sys.triggers t WHERE t.name = 'your_trigger'; Replace ' your_trigger ' with the name of the trigger you want to find the associated table for. This query will return the trigger name along with the corresponding table name. By executing this query, you can identify the table name associated with a trigger in SQL Server.

Latest posts

Retrieve Triggers Information in SQL Server Database

Find all tables containing column with specified name

How to Set Session Timeout in ASP.NET

SQL Query: Drop Table if Exists

How to open multiple project in one Browser Window - Visual Studio

How to Restart IIS using command line

How to Import Intermediate and Root Certificates Using MMC - Microsoft Windows

Convert Raw HTML Format in ASP.NET MVC

Troubleshooting: Resolving Could not load file or assembly '[assemblyname]' Error and Its Dependencies

How to Compile CSS with Prepros for Efficient Web Development

How to Find the Latest Update Table Date with a SQL Query

Troubleshooting Visual Studio Debugger: Code Not Hitting Breakpoints

How to Find the Last Modified Date of Stored Procedures in SQL Server Instance

SQL Query: Generate DROP TABLE Statements for Tables Matching 'TESTPRD[_]%' Pattern

Find text in sql db or search sp, table, column name in sql

Debug stored procedure sql

Check data from temporary table sql

check data from @tablename sql

Converting Interface to Model in C# .NET MVC

invalid object name 'string_split'. sql

How to Check if a File Exists on a HTTPS Website

CsvReader c#

List to datatable c#

Roslyn C# - Roslyn Compiler in C#

Improve Your C# Application Logging with log4net

Understanding Sealed Classes in C#

MAC ADDRESS FIND IN WEB APPLICATION

Sending Email By Using Email Templates In ASP.NET WebForm