SQL
SQL
Lister les Tables d'une base MSSQL
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
Problème de restoring d'une base
SELECT name, state_desc FROM sys.databases WHERE name = 'EVO_CONFIG50004'
SELECT r.session_id, r.command, r.status, r.percent_complete, r.start_time,
db.name AS database_name, r.wait_type, r.wait_time, r.wait_resource
FROM sys.dm_exec_requests r JOIN sys.databases db ON r.database_id = db.database_id WHERE db.name = 'EVO_CONFIG50004'
EXEC xp_readerrorlog 0, 1, N'Database', N'Restore';
RESTORE DATABASE [EVO_CONFIG50004] WITH RECOVERY;