Base de Données SQL Server
Modification des options et reconfiguration forcée du serveur EXEC sp_configure 'show advanced options', 1 RECONFIGURE WITH OVERRIDE EXEC sp_configure 'xp_cmdshell', 1 RECONFIGURE WITH OVERRIDE Detection des verrous <code> select cmd, * from sys.sysprocesses where blocked > 0 </code> ===== Liste des tables ===== <code> SELECT name FROM sysobjects WHERE type='U' AND name LIKE '%' ORDER BY name ASC </code> ===== Liste des vues, commençant par VRAT_ et order by nasme ASC ===== <code> SELECT name FROM sysobjects WHERE type='V' AND name LIKE 'VRAT_%' ORDER BY name </code> ===== Selectionne la structure d'une vue ===== <code> select v.name, col.name NAME_COLUMN, typUser.name TYPE_COLUMN, col.max_length from sys.columns col inner join sys.views v on col.object_id = v.object_id