Hello Shuaib-641712 -

did you ever figure out how to do this? I am looking for the same tool.

Thanks!

Kevin

Thanks, Lowell - that's a lot easier than what I've been doing:

declare @sql varchar(4000)

declare @sql2 nvarchar(4000)

declare @targetServerName varchar(100)='targetMachine'

select @sql = 'N''create table [dirlist] ([listrecords] varchar(500)) insert [dirlist] EXEC master.dbo.xp_cmdshell ''''dir...

Thanks for this script - almost exactly what I was looking for. I do have one problem, though:

I need to run this for 50 very large databases to move...

Thanks for this script - see below (edited)