Problem solve

Where are triggers stored?

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.

This was last published in December 2002

Dig Deeper on Microsoft SQL Server Installation

All
News
Get Started
Evaluate
Manage
Problem Solve

Finding the right problem for SQL Server 2014's in-memory OLTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Cambridge Analytica-Facebook case shows need for ethical data mining

Ethical data collection practices are becoming even more important, as cases like Cambridge Analytica's misuse of Facebook data ...

Rethinking analytics processes spurs enterprise innovation

By taking a fresh look at the makeup of their analytics organizations, enterprises can innovate their business models and take ...

Diversified data sets for analytics deliver top results

Analytics teams should focus on data diversity to ensure that their projects deliver the most meaningful insights -- but they ...

SearchDataCenter

Guide to buying server performance monitoring software

Integration, storage and vendor support all affect whether a performance monitoring tool is right for an organization. Mull over ...

How IBM's data science team quickens users' AI projects

In this Q&A, IBM's Seth Dobrin discusses the rising user interest in machine learning and AI projects and the help inexperienced ...

IBM blockchain technology spotlights mainframes

IBM's blockchain offerings aim to ease enterprise IT concerns by combining Z system mainframe hardware with industry-specific ...

SearchDataManagement

GDPR data protection edicts make good data governance a must

The European Union's new GDPR law puts the onus on companies to ensure that their data governance and management practices enable...

GDPR rules can spur broader steps to protect sensitive data

Companies need to make compliance with GDPR's requirements on managing personal data a priority, but they should also work to ...

Data integrity protection spurs greater security spending

As hacking, ransomware and malware attacks mount, companies place big data protection and integrity among the primary reasons for...

SearchAWS

Amazon FreeRTOS aims to simplify, secure IoT deployment

Operational technology teams have been slow to update microcontroller software due to safety and logistics concerns, but Amazon ...

Test your knowledge of GDPR rights and AWS data protection

Is your enterprise GDPR-compliant? Take this quick quiz to test your knowledge of the EU regulation, as well as relevant AWS data...

Support for Node.js in AWS Lambda slowly, but surely, evolves

Developers who need the latest version of Node.js for a serverless platform might turn to Lambda rivals to meet that need. But ...

SearchOracle

Collaborate 18 to track progress of Oracle cloud database, apps

The Collaborate 18 conference will shine a light on Oracle cloud adoption and migration issues, and on the impact that such moves...

Oracle Autonomous Database debut heralds new cloud hopes

It wasn't the first in the cloud computing space, but Oracle is all in now. Key to the effort is a new Autonomous Database ...

Oracle cloud services aim to pull users out of IT comfort zone

Oracle has gone all-in on cloud computing and expanded its line of cloud services in the hopes users will make the jump. But ...

SearchContentManagement

How a digital transformation process helped curb reliance on paper

By moving on from paper, the North Carolina Court System and the Texas Animal Health Commission were able to accommodate ...

Intelligent information management is ready for AI, blockchain

A panel discussion at AIIM 2018 looked at how AI, cloud and blockchain will disrupt the intelligent information management space.

SharePoint 2019 on premises the talk of SharePoint Fest D.C.

This episode of the Pipeline podcast breaks down SharePoint users' concerns about data migration, on-premises version support, ...

SearchWindowsServer

Azure PowerShell cmdlets monitor, manage VMs

PowerShell gives administrators a way to customize reports that hone in on the details that matter to the business, such as the ...

Windows out-of-band patches overshadow April Patch Tuesday

Microsoft delivered out-of-band security patches to address the Total Meltdown and malware engine exploits as a precursor to its ...

Microsoft Project Honolulu shows promise but needs work

Microsoft Project Honolulu is still in the technical preview stage, but it needs to resolve a number of issues before it's a ...

For More Information

Related Resources

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.