Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Select from sysfiles

4>  CREATE PROC sp_list_files_and_objects 5> AS 6> SELECT filename FROM sysfiles 7> SELECT name from sysobjects 8> RETURN 9> GO 1> 2> drop PROC sp_list_files_and_objects; 3> GO 1>