Triggers fire after every update. That's how they work. You can put code into the triggers so that they don't do whatever they do in certain cses, but that's all.

Perhaps...

Do we get a prize for answering correctly?

Remember that "_" is a single character wildcard in SQL, like "?" is in access.

Look in Books online under the section "Using the SQL Server Service Startup Options". It lists all of the command...

I did.

Create a SQL login on that server.

Give that login just the rights that it needs for what you are doing...

Firstly, there's no such thing as a before trigger. The two types in SQL are instead of and after.

A trigger will fire once per operation, not once per row. After...

That's good to hear.

Daily is perhaps overkill. CheckDB is a very intensive operation. Running it weekly, over a weekend is probably adequate.

Very, very bad idea. The mapping is fine, but it should be mapped...

No. It means SQL hasn't got the vaguest clue what this page is...

There should have been another line in the checkDB output saying what level was required to fix. What did it say?

Since you have no good backup, the only way to...

Brandie Tarvin (8/13/2008)

---

Curiousier and Curiousier... It is NOT there in the July 2006 version. The only code examples I see are:

A) with the Alter Table Alter column to set...

There is, it's just a little hidden. Right at the bottom of...

I may be miles off, but you haven't said which column to put the fk on. Maybe this?

Alter Table TableA

Add Constraint FK_TableA_TimeKey Foreign Key (TimeKey) References dbo.DimTime (TimeKey);

Neither should cause a table scan because you don't have a function on the column. If's functions on the columns that prevent index usage.

You may be prone to parameter sniffing...

The code flow is such that after the commit is reached, execution goes past the Errblock label and executes rollback. Of course, seeing as the transaction has just committed, there's...

Of course, then there's the question of why the application wants to know the columns of the indexes in the first place...