- with simple recovery you can only go to the previous full backup ( and if you have a differential backup, you can also apply that).

- how did you...

:hehe:

declare @tmp table (UserName varchar(128) not null, EmailAddress varchar(128) not null primary key, TsRegistration datetime not null)

Insert into @tmp values ('alzdba', 'alzdba@dono.com', '2001-04-01 18:00:00.000')

Insert into @tmp values ('alzdba', 'alzdba1@dono.com', '2002-04-01...

For a couple of years I've had the pleasure to attend SQLPass in Seattle, Denver and Grapevine.

If you do the math on costs, you'll see the cost may even be...

will you toss in a T for the one with the highest added number ? :w00t:

Within the same major version of sqlserver a restore should never be an issue for user databases.

edited: SSC has some response problems, causing this reply to be executed a couple...

Within the same major version of sqlserver a restore should never be an issue for user databases.

edited: SSC has some response problems, causing this reply to be executed a couple...

Within the same major version of sqlserver a restore should never be an issue for user databases.

I'm glad it got sorted out, even with the misterious "for internal use" 😉

For best it should at least be added as a sidenote to the online rebuild in BOL.

Thanks...

I'll put in a virtual pint :w00t:

Let's hope for the code mismatch, even if in both sql2005 as wel as 2008.

I'll vote on Connect !

Problem is, we cannot trace/dump the...

You should compare the execution plans for the troublesome queries.

(you can save them and post them is this forum thread if you want to)

Your issue must have something to do...

Breathe 😀

Out with the bad air ... In with the good ....

go

I would guess it has something to do with the basic difference of an online rebuild compared to an offline rebuild: keeping it up to date with ongoing operations.

So it...

- Is your sql instance using Mixed authentication ?

- did you check for the password with your peers ?

- I would try a remote desktop connection, making sure you get...

- on the other hand, if the trigger fails, the whole transaction fails, so the insert will be undone !

- double check that the triggers are enabled !

SELECT OBJECT_NAME(parent_obj)...

start sqlprofiler and ask your .net dev to perform his (her) inserts.

Check the statements your profiler shows and you'll have your diagnose.