[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can Triggers and Stored Procs operate across databases on the same server?

Posted on 2014-08-22
3
Medium Priority
?
186 Views
Last Modified: 2014-08-22
Can Triggers and Stored Procs operate across databases on the same server?
0
Comment
Question by:HLRosenberger
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 2000 total points
ID: 40279501
Yes you can use dbname.dbo.table to reference a table in a another database from a stored procedure or trigger in a different database

Is this what you mean?
0
 
LVL 1

Author Comment

by:HLRosenberger
ID: 40279511
yes.  thanks!
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 40279513
thanks.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

865 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question