Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replicated Table

Status
Not open for further replies.
sendba

sendba

Programmer
Sep 7, 2005
113
US
All

Is there a way to drop and recreate indexes(including PRIMARY key) on a table which is used in Transactional Replication.
Please let me know

Thanks alot in advance

Sen
 
Sort by date Sort by votes
No, if you want to drop the index you will need to remove the table from replication. What is it you are trying to accomplish?

- Paul
- Database performance looks fine, it must be the Network!
 
Upvote 0 Downvote
I want to do a maintenace on the database.
 
Upvote 0 Downvote
you can use DBCC INDEXDEFRAG and DBCC DBREINDEX to rebuild indexes. Both commands will get rid of fragmentation.

Use DBCC SHOWCONTIG to view fragmentation of a table.

- Paul
- Database performance looks fine, it must be the Network!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AndrewWiggins99
  • Locked
  • Question
Read Only access on a specific table 1
Replies
3
Views
333
fredericofonseca
fredericofonseca
dgillz
  • Locked
  • Question
How to create login that has access to only certain tables in a database
Replies
4
Views
417
SQLBill
SQLBill
niall5098
  • Locked
  • Question
collation in table edit
Replies
1
Views
238
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Partioning a table with non-clustered index but no clustered index
Replies
0
Views
176
TheBugSlayer
TheBugSlayer
boanrb
  • Locked
  • Question
Table Creation: Referential Integrity
Replies
2
Views
211
boanrb
boanrb

Part and Inventory Search

Sponsor

Back
Top