Lista baza i automatski attach

SELECT

d.name AS 'Database',

m.physical_name as mdf,

x.physical_name as ldf

into baze

FROM sys.master_files m

inner JOIN sys.databases d ON d.database_id = m.database_id and m.type_desc = 'ROWS'

inner join sys.master_files x on m.database_id = x.database_id and x.type_desc = 'LOG'

where m.physical_name like 'C:\datalab%'

--------------------------------------

declare @d char (30), @m varchar(100), @l varchar (100), @s varchar (max)

declare xPoz cursor local fast_forward for

select * from [192.168.16.116\SQLEXPRESS].[master].dbo.baze

open xPoz

fetch from xPoz into @d, @m, @l

while @@fetch_status = 0

begin

set @s = '

CREATE DATABASE ['+rtrim(@d)+'] ON 

( FILENAME = N'''+rtrim(@m)+''' ),

( FILENAME = N'''+rtrim(@l)+''' )

 FOR ATTACH

'

exec (@s)

fetch from xPoz into @d, @m, @l

end

close xPoz

deallocate xPop