Poniżej przedstawiam skrypt, który generuje kod do odłączenia (detach) wszystkich baz danych użytkownika.
03 | DECLARE @dbname as varchar(80) |
04 | PRINT '--SERVER NAME : ' + upper(@@servername) + '--> Begin script databases' |
05 | PRINT '----------------------------------------------' |
09 | DECLARE DatabaseNameList_cur CURSOR STATIC LOCAL FORWARD_ONLY |
11 | SELECT RTRIM(LTRIM([name])) |
14 | AND STATE_DESC='ONLINE'; |
16 | OPEN DatabaseNameList_cur |
18 | FETCH NEXT FROM DatabaseNameList_cur into @dbname |
21 | PRINT 'No database to backup...Please check your script!!!' |
24 | WHILE @@FETCH_STATUS = 0 |
27 | PRINT 'sp_detach_db ' + @dbname |
29 | PRINT 'print ''Detach of ' + upper(@dbname) + ' database successfully completed''' |
33 | FETCH NEXT FROM DatabaseNameList_cur INTO @dbname |
36 | CLOSE DatabaseNameList_cur |
37 | DEALLOCATE DatabaseNameList_cur |
39 | PRINT '----------------------------------------------' |
42 | PRINT 'print ''SERVER NAME : ' + upper(@@servername) + '--> All databases successfully detached''' |
