Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-05-03 : 00:28:52
|
| We have new indexes on 2-tables were in place to be created.This is ok for creation.(Offcourse, Full backup prior to the index and Tlogs will be safeguarded).How to revert them in the event user complains. (I Know Simply remove the Created indexes and this will not solve my problem)What would be the aftermath problems after creation of this index in place and what kind of Remedial steps needs to be taken.Can anyone address please. Many thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-03 : 01:45:54
|
| If they cause a problem (and there's no reason they should) simply drop the indexes that you created. Nothing more to it.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Index Creation and thereafter