Explain the role of Triggers in SQL Server database, while also addressing the right way to use them in the database management system.
