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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-11-29 : 12:34:56
|
| Hi, I have a rebuild index (optimization) plan set up. However I want to manipulate it by taking additional log backups after 1/2 the job is done. Generating a script (by right-clicking on maintenance plan) doesnt generate the actual Rebuild index command. How does SQL Server perform this action? Can I see anywhere the exact command it is doing?Thanks,Sarat. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 12:36:45
|
| You can use the profiler to see the sql probably.==========================================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. |
 |
|
|
|
|
|
Generating SQL Script for Jobs