You can use some of the 3rd party tool to indentify the transaction details.

HTH

MAX DOP will not affect anything it is still dynamic and intend to use max available processor; it may also use fewer processor depnding on system workload.

see the extract from...

Andreea

I would like to drow your attention that when you restart the server tempdb will shrink and when the space is required it has to expand. Now expanding the tempdb...

I do not see much issue with respect to the fragmentation of the index. If you consider the largest page count in your repot than it will be around 10000...

If the database size is small than you can go with the 'Snapshot Replication' to achieve your goal. Which is also easy to maintain compare to other soultions.

Backup and restore...

Window authentication is better option and should be in the same domain; if not trusted domain should be there.

However, if tursted domain is not there you can use certifactes as...

Same question as QOD 9th July. Once more secure point 😉

IF YOUR DATABASE IS TEST THAN ONLY PROCEED.....

As this may have data loss.

Make sure you do have the backup of the database

You can simply do the following steps:

1. detach of...

check this...

http://support.microsoft.com/kb/240867#appliesto

HTH

I guess you need to start from a scratch... Because

1. OS rebuild will not find any entry for the other server in cluster i.e. OS level clustering will not be...

If you would like to capture all the actions on the instance refer "C2 Audit Mode Option".

HTH

The DROP INDEX statement does not apply to indexes created by defining PRIMARY KEY or UNIQUE constraints. To remove the constraint and corresponding index, use "ALTER TABLE" with the DROP...

search with AUTO_UPDATE_STATISTICS which is database property and can set by executing T-sql ALTER DATABASE command.

Also you can write a cursor for the same but sp_msforeachdb is good one.

HTH

I would prefer to bring down the databases before the movement and also make sure to have system as well as user database backup.

HTH

Me too getting "-1,0,1" but available answer is "-1,-0,1" :w00t: