Viewing 3 posts - 1 through 3 (of 3 total)
Someone might find this useful in future
I've gone with this approach.
Every db on my 4 production instances has a CopyCheck table.
EXECUTE sp_msforeachdb 'USE ?
IF DB_NAME() NOT IN(''master'',''msdb'',''tempdb'',''model'')
CREATE TABLE [dbo].[CopyCheck](
[last_update] [smalldatetime]...
September 20, 2010 at 11:28 pm
is there any issue in creating indexed views?
Why are u using copy database wizard?
Please explain.
Indexed views can only be created on writable databases and log shipping/mirroring doesn't allow that scenario....
March 30, 2010 at 10:08 pm
Its a fairly complex application, and has been under continual development for a number of years - but an external agency (government), and they believe all those indexes are required...
February 23, 2010 at 8:40 pm
Viewing 3 posts - 1 through 3 (of 3 total)