isa_sey (6/17/2009)

We restored our full backup WITH NORECOVERY, it was successful. then we restored our first differential backup WITH RECOVERY, it was also successful. But on our attemp...

Flip the order of the tables in the trigger and the the update occurs properly based on the clustered index on the table being updated even with the force plan....

However, you are forcing the order of the update by INSERTED, not the table you are updating. So, are you really breaking the quirky update that allows for a...

You know what they say, read the whole question.

Paul,

Check out the difference between the two pieces of code below and their behaviour:

CREATE TABLE dbo.[976231EF-DA13-4A8A-91DC-7D8931A2C14B]

(

row_id INT...

Two things.

One, with SQL Server 2005 and on tracking when objects are modified, I would be more inclined now to use ALTER instead of DROP/CREATE.

Two, I agree with deploying a...

My guess, little Snarky Malarky?

In fact it is at the top of the list for me right now.

I have noticed that sometimes it will show up in the Active Threads list and at other times it doesn't. Seems really strange.

By doing that, you have broken the log chain from the source database (client). About the only way I can see around this would be do shut SQL Server...

As stated earlier, you can only have one primary key. This key uniquely identifies a record in a table. It is possible to have other keys on other...

Actually, yes I do. Especially when someone else could have done it just as easily as asking a question here on SSC. 😉

You still have not answered the main question, how current does the data need to be for reporting purposes? Do the users really need up to the minute reporting...

Thought you said you knew how to use Google? 😉

Try starting here.

Right you are, back to ignoring it shall be.