DBREINDEX in stored procedure 
Author Message
 DBREINDEX in stored procedure
Hi

It is possible to run Update Statistics using predefined stored procedure
sp_updatestats (for all tables in database). Mayby exist the same mechanism
for DBCC DBREINDEX or for DBCC INDEXDEFRAG ?

Marek



Tue, 20 Jul 2004 22:25:27 GMT
 DBREINDEX in stored procedure

No - there's no predefined SPs for either of these commands.

--
Paul Randal
DBCC, SQL Server Storage Engine
Microsoft, Redmond, WA

This posting is provided "AS IS" with no warranties, and confers no rights.

Quote:
> Hi

> It is possible to run Update Statistics using predefined stored procedure
> sp_updatestats (for all tables in database). Mayby exist the same
mechanism
> for DBCC DBREINDEX or for DBCC INDEXDEFRAG ?

> Marek



Wed, 21 Jul 2004 00:09:48 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Calling a Java Stored Procedure from another Java Stored Stored Procedure

2. return select values in stored procedure to a calling stored procedure

3. Stored procedures calling stored procedures....

4. Stored procedures calling stored procedures

5. Many Simple Stored Procedures VS. Few Complex Stored Procedures

6. Stored Procedure using another Stored Procedure

7. Stored procedures calling stored procedures....

8. using SQL stored procedure results in stored procedure

9. Stored procedure calls multiple stored procedures

10. executing system stored procedures within a stored procedure

11. Calling a Stored Procedure from within a Stored Procedure

12. Using Stored Procedure's results in a Stored Procedure


 
Powered by phpBB® Forum Software