Any machine that has the SQL management tools on it (Management studio and the like) will have profiler. You can profile the server from any machine that can see it.

To...

Bracket in the wrong place. This passes a syntax check.

CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS

IF EXISTS (SELECT 1 FROM inserted i inner join deleted d

on i.ESSN =...

Any query that you run, whether you select from...

Then SSN is what the join needs to be on.

You can't have 2 primary keys on a table. If you mean it's a 2-column primary key, then you need to use both.

So:

inserted.ESSN = deleted.ESSN AND inserted.SSN = deleted.SSN

The point...

Mostly complete.

If you want to insert into an errors table, do it right after the rollback transaction. You can also use the raiserror to send an error back to the...

Try something like this. Untested. Please test carefully.

CREATE TRIGGER trg_PreventInvalidHours ON works_on AFTER UPDATE AS

IF EXISTS (

SELECT 1 FROM inserted i inner join deleted d on i.<Primary Key Column>...

There's some problem with the time zones I think. For me the time shows 11:18, but it's actually 10:18. My timezone is set to GMT + 2, no DST

Find your latest backup and restore it.

Based on the error, I would guess that page 126 holds part of one of the system tables. CheckDB canot fix a DB if...

For all queries SQL executes, the plans are cached and reused. Adhoc or procedures.

Views by themselves do not have execution plans. When a view is queried, SQL expannds the view...

The DAC connection will let you read the base system tables, not change them.

You cannot (and should not) change the system tables in sQL 2005.

What are yuo tryng to do?...

Did the service restart? Are there any errors in the SQL error log from around the same time?

If you have access to SQL Profiler, run it against the SQL server while testing out your web page. You'll be able to see if the delete, insert or update...

Does this help you? Cube and Rollup

Like many things in SQL, it probably has a performance impact, but if you need the summary rows it produces, then you need the...

Group by without a distinct has the same effect as DISTINCT. sometimes there are minor differences behid the scenes, but usually not.

When you use GROUP BY, you're telling SQL you...