Problem solve

Where are triggers stored?

Published: 10 Dec 2002

Where are triggers stored in SQL Server? Is it in a folder named triggers?

Triggers, like all objects, are stored within SQL Server in the database they were created in. The text of the...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

object creation is stored in syscomments. SQL Server doesn't utilize folders.

For More Information

Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
The Best SQL Web Links
Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

Dig Deeper on Microsoft SQL Server Installation

SearchBusinessAnalytics

Hyperconverged Analytics a new experience for Tibco users

Tibco CTO Nelson Petracek discusses the motivation for developing the vendor's new analytics experience as well challenges of ...

Certificates important to the data science learning path

While data science certificates have value in the professional world, candidates must make them a piece of a larger drive for ...

Spotfire 11 release marks launch of new Tibco BI ecosystem

The combination of latest Spotfire update and a new streaming data engine marks the launch of Tibco's new analytics ecosystem ...

SearchDataCenter

Discover the main differences between COTS vs. GOTS

When admins compare government versus commercial software options, they must consider cost, use cases and available support as ...

6 steps for effective real-time monitoring across hybrid IT

Infrastructure monitoring can span multiple stakeholders, data center sites and metrics. Use the five W's to establish a ...

IBM roadmap promises a 1,121-qubit quantum computer by 2023

IBM outlined plans to deliver a series of quantum computers over the next three years culminating with IBM Quantum Condor, a ...

SearchDataManagement

Ahana releases managed Cloud for Presto service

New Ahana cloud system brings a managed service to market that integrates data management and visualization capabilities to aid ...

Pandemic exposes difficulty of data management in education

Limited resources and a shift to remote learning have shown the inequalities across school districts when it comes to data ...

Aerospike Connect improves integrations with NoSQL database

Aerospike updates connectors for popular data query and event streaming tools, including Kafka, Spark, Pulsar and soon Presto, ...

SearchAWS

New Amazon grocery stores run on computer vision, apps

Amazon dives deeper into the grocery business with its first 'new concept' grocery store, driven by automation, computer vision ...

Amazon's sustainability initiatives: Half empty or half full?

Amazon's public perception and investment profile are at stake as altruism and self-interest mix in its efforts to become a more ...

How Amazon launched the warehouse robotics industry

In 2012, the warehouse robotics industry consisted of Kiva Systems, the sole supplier to serve all e-commerce companies. When ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchContentManagement

How businesses can best build a WordPress knowledge base

A WordPress knowledge base can be useful for companies that want an easy-to-use and customizable product with many plugins that ...

Knowledge bases benefit customer service, call center training

Knowledge bases provide call center agents with training documents and answers to frequently asked questions as they continue to ...

Box Shield, mobile app upgrades on the way

Among a slew of coming upgrades, Box Inc. goes after Microsoft's government business with FedRAMP High certification.

SearchWindowsServer

Microsoft Ignite 2020 conference coverage

This Microsoft Ignite guide compiles news from the online event, including upcoming products and how they might address some of ...

What admins should know about Microsoft Windows Terminal

There's a new terminal that puts a different spin on the traditional command-line tools used by Windows administrators with ...

SharePoint gets multiple fixes for September Patch Tuesday

There were no zero-days or public disclosures from Microsoft this month, but patches for SharePoint and Exchange should get ...

For More Information

Fine-grained auditing in SQL Server?

Schema-level trigger to alter a session automatically

Calling a stored procedure from a trigger

Trigger that will not fire when certain column is updated

Please create a username to comment.

Hyperconverged Analytics a new experience for Tibco users

Certificates important to the data science learning path

Spotfire 11 release marks launch of new Tibco BI ecosystem

Discover the main differences between COTS vs. GOTS

6 steps for effective real-time monitoring across hybrid IT

IBM roadmap promises a 1,121-qubit quantum computer by 2023

Ahana releases managed Cloud for Presto service

Pandemic exposes difficulty of data management in education

Aerospike Connect improves integrations with NoSQL database

New Amazon grocery stores run on computer vision, apps

Amazon's sustainability initiatives: Half empty or half full?

How Amazon launched the warehouse robotics industry

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

How businesses can best build a WordPress knowledge base

Knowledge bases benefit customer service, call center training

Box Shield, mobile app upgrades on the way

Microsoft Ignite 2020 conference coverage

What admins should know about Microsoft Windows Terminal

SharePoint gets multiple fixes for September Patch Tuesday

For More Information

Dig Deeper on Microsoft SQL Server Installation

Fine-grained auditing in SQL Server?

Schema-level trigger to alter a session automatically

Calling a stored procedure from a trigger

Trigger that will not fire when certain column is updated

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.