SQL Server 2008 Profiler - How to filter trace to only display events from one database ?

Create New template and follow below steps on "Trace Properties" window-

1 - Click on the "Events Selection" tab
2 - Click on the "Show All Columns" check box
3 - Click on the "Column Filters..." button
4 - Select "DatabaseName", click on the plus icon to Like in the right-hand side pane, and type your database name.

Thanks

SQL SERVER 2008 – Database diagram support objects cannot be installed because this database does not have a valid owner

Full Error : Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

Solution : You can fix this error if you have full permission of database -

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

GO 

Thanks