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 |
|
Studentsql
Starting Member
3 Posts |
 Posted - 2003-06-03 : 21:06:49
|
| I need to know the procedure on how to re-organize sql server 7 database. I need it badly. please help me.I cant find any article about it. thank you in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-03 : 21:12:47
|
| What do you mean by re-organize?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Studentsql
Starting Member
3 Posts |
Posted - 2003-06-03 : 21:21:40
|
| re-organize is like defragmentation. Because some tables are not in their proper order or some are missing, thats why there is a need to re-organize |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-03 : 21:25:04
|
| Please see DBCC DBREINDEX in SQL Server Books Online. It provides all of the details needed to "re-organize" your database.This is also sort of a double post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=26746[/url]Tara |
|
|
|
|
|
|
how to re-organize sql server 7 database?