Will Microsoft stop the support if I use undocumented Procedures

Question

Hi, 

During a recent search I found out that Microsoft says that that it does not support the use of undocumented procedures in production. It says that to ensure the performance and stability we should use only the documented stuff. 

1. Does that mean, if I use undocumented procedure (it could be simple as sp_MSForeachDB) It is considered as a violation to the the agreement?
2. Will use of undocumented features harm the support we receive? (I understand MSFT may not support if our server crashes, slowed down because of the use of those procedures, but it is a different story) 

What the official position of Microsoft?

   

---

Cheers, Preethiviraj Kulasingham

Answer 1

Related discussion: "With regard to these undocumented stored procedures can I
legally use them in my programs? "

I would not use them in production. I would use them as ad-hoc scripts in my DBA work.

WHILE loop with dynamic SQL is an easy replacement for sp_MSforeachxxx:

http://www.sqlusa.com/bestpractices2008/rebuild-all-indexes/

---

Kalman Toth SQL SERVER & BI TRAINING