Download: Download snippet as check_alldatabase_sysfiles.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!
create table ##check_alldatabase_sysfiles( [svrname] [nvarchar] (128) NULL , dbname nvarchar(128), [fileid] [smallint] NOT NULL , [groupid] [smallint] NOT NULL , [size] [int] NOT NULL , [maxsize] [int] NOT NULL , [growth] [int] NOT NULL , [status] [int] NOT NULL , [perf] [int] NOT NULL , [name] [nchar] (128) NOT NULL , [filename] [nchar] (260) NOT NULL ) exec sp_MSforeachdb @command1 = ' use [?]; insert into ##check_alldatabase_sysfiles select @@servername as srvname, db_name() as dbname, * from sysfiles; ' select * from ##check_alldatabase_sysfiles; drop table ##check_alldatabase_sysfiles;
Create a free my code stock.com account now.
my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!Find out more and register now
You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.