But Beware: Avoid loose ends as this will create multiple connections when running tasks parallel. You have to create a chain from BEGIN TRAN to COMMIT, otherwise it will fail.

alter database your_db set single_user with rollback immediatewhen you're done restoring your db, just restore the original state with this statement:

alter database your_db set multi_user

However, if single_user is not an option for you, you can still kill all connections with this script (which is not that safe btw):

DECLARE @dbname sysname
SET @dbname = 'your_db'

DECLARE @spid int
SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname)
WHILE @spid IS NOT NULL
BEGIN
EXECUTE ('KILL ' + @spid)
SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid > @spid
END
 

:setvar checkSQLCMD "checkSQLCMD"
GO
IF ('$(checkSQLCMD)' = '$' + '(checkSQLCMD)') RAISERROR ('This script must be run in SQLCMD mode.', 20, 1) WITH LOG
GO
SELECT 'This part executes only in SQLCMD mode!'

[ValidationProperty("Text")]
public class CustomControl : CheckboxList
    { yadayada... }

to the class definiton of the control to tell the ASP.Net validation framework what value to validate...simple, huh? Just replace the "Text" in the live above with the Property of your custom control to be validated.

There are only 2 preconditions: 7-zip installed and xp-cmdshell enabled (see this).

USE MASTER

CREATE procedure spBackupAndFtpDB
@FTPServer    varchar(128) ,
@FTPUser    varchar(128) ,
@FTPPWD        varchar(128) ,
@FTPPath    varchar(128) = '/' ,
@DBList            varchar(MAX),
@Delimiter    varchar(MAX) = ',',
@ZipBackup    bit = 1,
@DelteLocalFiles bit = 1,
@workdir    varchar(128) = 'C:\Windows\Temp\',
@7zipdir    varchar(255) = 'C:\Program Files\7-zip\'

as
    -- deal with special characters for echo commands
    select @FTPServer = replace(replace(replace(@FTPServer, '|', '^|'),'<','^<'),'>','^>')
    select @FTPUser = replace(replace(replace(@FTPUser, '|', '^|'),'<','^<'),'>','^>')
    select @FTPPWD = replace(replace(replace(@FTPPWD, '|', '^|'),'<','^<'),'>','^>')
    select @FTPPath = replace(replace(replace(@FTPPath, '|', '^|'),'<','^<'),'>','^>')
    
    declare    @cmd varchar(1000)
    declare @workfilename varchar(128)
    
    DECLARE @SourceFile varchar(255)
    
    create table #a (id int identity(1,1), s varchar(1000))
           

    --start loop
    DECLARE @CSVString varchar(MAX);
    SET @CSVString = @DBList

    DECLARE @pos INT;
    DECLARE @DB VARCHAR(MAX);

    SELECT @pos = 1;

    WHILE @pos!= 0
    BEGIN
        SET @pos = CHARINDEX(@Delimiter,@CSVString);
        IF @pos != 0
            SET @DB = LTRIM(RTRIM(LEFT(@CSVString, @pos - 1)));
        ELSE
            SET @DB = LTRIM(RTRIM(@CSVString));

        IF( LEN(@DB) > 0)
        BEGIN

            --backup    
            SET @SourceFile = @DB + CONVERT(VARCHAR(6), GETDATE(), 12) + '.bak'
            SELECT @cmd = 'BACKUP DATABASE [' +   @DB + '] TO  DISK = N''' + @workdir + @SourceFile + ''' WITH NOFORMAT, INIT,  NAME = N''' + @DB + '-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD,  STATS = 100'
            EXEC (@cmd)



            --compress
            IF @ZipBackup = 1 BEGIN
                SELECT @cmd = '"' + @7zipdir +'7z" a ' + @workdir + @SourceFile + '.7z ' + @workdir + @SourceFile
                print @cmd
                insert #a
                exec master..xp_cmdshell @cmd
               
                IF @DelteLocalFiles = 1
                BEGIN
                    --remove backup
                    SELECT @cmd = 'del "' + @workdir + @SourceFile + '"'
                    print @cmd
                    insert #a
                    exec master..xp_cmdshell @cmd
                END
           
                --set zipped sourcefile
                SELECT @SourceFile = @SourceFile + '.7z'
            END
           
           

            --ftp
            select @workfilename = 'ftpcmd.txt'
           
            select    @cmd = 'echo '                    + 'open ' + @FTPServer
                    + ' > ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + @FTPUser
                    + '>> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + @FTPPWD
                    + '>> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + 'put ' + @workdir + @SourceFile + ' ' + @FTPPath + @SourceFile
                    + ' >> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + 'quit'
                    + ' >> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
           
            print @cmd
            select @cmd = 'ftp -s:' + @workdir + @workfilename
           
            insert #a
            exec master..xp_cmdshell @cmd

           
--Not logged in.
--Login failed.
--File not found

            IF @DelteLocalFiles = 1
            BEGIN
                --remove backup
                SELECT @cmd = 'del "' + @workdir + @SourceFile + '"'
                print @cmd
                insert #a
                exec master..xp_cmdshell @cmd
            END
           
           
            --report results
            SELECT id, ouputtmp = s FROM #a WHERE s IS NOT NULL
           
            IF EXISTS(SELECT * FROM #a WHERE s LIKE '%Not logged in%' OR s LIKE '%Login failed%' OR s LIKE '%File not found%' OR s like '%WARNINGS for files%')
            BEGIN
                SET @cmd = 'An Error occured during Backup and FTP. Details: '
                SELECT @cmd = @cmd + '; ' + ISNULL(s, '') FROM #a WHERE s IS NOT NULL
                RAISERROR (@cmd, -- Message text.
                   16, -- Severity.
                   1 -- State.
                   );
            END
           

        END

        SET @CSVString = RIGHT(@CSVString, LEN(@CSVString) - @pos);
    END
    
    
    RETURN 0
    
go

Note: No Codebehind needed! And jsut add a little .js and .css found here and my menu was able to render without a <form> tag. Hooray. That saved the day!

(SELECT STUFF((SELECT ', ' + Type FROM dbo.Reactor r FOR XML PATH('')),1,1,''))

namespace Data
{
    using System.Data.Linq.Mapping;
    using System.Data.Linq;
    using System.Reflection;
    partial class MyDataContext
    {

...

}