CODEWITHSUNDEEP
sqlsql-server
Andrew Vogel
Andrew Vogel

Reputation: 266

'Printing' from a SQL 2008 R2 trigger

If I have PRINT 'something' in a trigger, where does that output go?

I'm using SQL Server 2008R2

Upvotes: 2

Views: 2925

Answers (2)

Dustin Laine
Dustin Laine

Reputation: 38533

It print statement will bubble up to the query that initiated the trigger to execute. From which it will return to the client, SSMS, ADO, etc.

Upvotes: 2

bobs
bobs

Reputation: 22204

It depends on where you run the triggering statement. In Management Studio window, you will see the trigger output in the Messages tab.

Upvotes: 0

Related Questions