Here's a script to show you the error... and give you something to toy with :

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_DemoB_DemoA]') AND  

You cannot set on casade delete for all those relations (circular relations) >>

c to b = fine

b to a = fine

c to a >> cascades on b, which cascades on...

You should be able to duplicate the behavior by using this (only for your personnal experience, and only if you have a low transactionnal environement)

DBCC FREEPROCCACHE --flush compiled plans

DBCC DROPCLEANBUFFERS --flush...

That's because the proccache (execution plans) are flushed after a restart.  So sql server has to recompile the objects and it also has to reread the data from disk.  After...

To move objects on other filegroups you simply need to change the clustered index filegroup.

PTut.Open STRSQLpt, CurrentProject.Connection, adOpenStatic, adLockOptimistic

if not pTot.eof then

Pi = PTut!ptid

PTfs = PTut!ptname

PTsf = PTut!pt

endif

PTut.Close

Replace the smiley face with a ")" without the quotes.

Start the profiler, see and playback the statements that should be doing the work.  Also show the execution plan while playing back the statements in QA.  Maybe there are some...

Great.. if only all users were like you .

I think it was a smart thing on his part to think about the hour change and the possible job failures (especially if he's not a programmer / dba).  However in...

Fires once per transaction. 

The tables deleted and inserted accessible from the trigger contain all the row(s) inserted or deleted (both tables are filled for an update query).

Post more details...

His best and almost only chance is to have the file in the recycle bin.  Other than that I would be very surprised that no sector were affected by the...

How about this :

Create the foreign key between master (PK) and childs(FK)

Create stating table with the same structure as the child table

Create an instead of trigger on the child...