The only reason to add the GUID to the clustered index is to make it unique...is that the reason for adding this column to the clustered index.

I GENERALLY prefer to...

Here is a starting point...I use this to restore databases to my DR server...

Good Luck

ALTER PROCEDURE[dbo].[P_RestoreDatabase_DBName]

AS

SET NOCOUNT ON

DECLARE@DBNameVARCHAR( 64 )='DBName'

DECLARE@DirNameVARCHAR( 256 )

DECLARE@FileNameVARCHAR( 256 ),

@FileDateDATETIME,

@MaxFileDateDATETIME,

@DBRestoreSizeBIGINT,

@DBRestoreLSNNUMERIC( 25, 0 )

DECLARE@sqlVARCHAR( 5000...

Here is the simples solution:

1. Have two separate databases and two separate web servers servicing the requests

2. Have the users login to a third common website

3. Redirect the users to...

1. Do the restore to a different database name

2. then rename/drop the old database

3. Rename the new database to the correct DB name

Getting events in the default trace saying missing column statistics on a column...

1.The column is the primary key column ( identity ), with a primary key

2. Auto Create statistics is...