SP gets the database file path for violent migration server

ALTER PROCEDURE [dbo]. [Usp_showallfilename]
As
BEGIN

DECLARE @px INT = 0
DECLARE @dbname VARCHAR (30)
DECLARE @sql VARCHAR (MAX)
IF object_id (' tempdb.. #dbs ', ' U ') is not NULL
DROP TABLE #dbs
IF object_id (' tempdb.. #tbfname ', ' U ') is not NULL
DROP TABLE #tbfname
CREATE TABLE #tbfname
(
ID INT IDENTITY (1, 1),
dbname VARCHAR (40),
FName VARCHAR (200)
)
SELECT id = IDENTITY (INT, +),
Name
Into #dbs
From Master.sys.databases DB
WHERE db.database_id > 4
and Db.name not in (' ReportServer ',
' ReportServerTempDB ')
while (@px < (SELECT MAX (ID)
From #dbs
) )
BEGIN
SELECT TOP 1
@dbname = #dbs. Name
From #dbs
SET @sql = ' use ' + @dbname
+ ' SELECT ' [email protected] + ', filename from Sys.sysfiles '
INSERT #tbfname EXEC (@sql)
SET @px = @px + 1
DELETE #dbs
WHERE name = @dbname
END
SELECT *
From #tbfname
END

SP gets the database file path for violent migration server