Select All Database
select * from master..sysdatabases
Select record in Xml format
select * from Table_name for xml auto,type
See design of table
EXEC sp_help tm_task
See the File and folder of hard Drive
EXEC xp_dirtree 'Subdirectories', 'depth' , 'file'
EXEC xp_dirtree 'E:\', 2, 1
No comments:
Post a Comment