Save SQL Table in dll

Basics what you need... The assemblies can be found in c:\program files\Microsoft SQL Server\XXX\SDK\Assemblies\... (XXX = Version of your SQL Server installed.) ONLY BACKS UP DATABASE< NOT A SINGLE TABLE

Imports System.IO
Imports Microsoft.SqlServer.Management
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Server
Imports Microsoft.SqlServer.Management.Common
Imports Microsoft.SqlServer.Management.Smo.Agent
Imports Microsoft.SqlServer.Management.Smo.Broker
Imports Microsoft.SqlServer.Management.Smo.Mail
Imports Microsoft.SqlServer.Management.Smo.RegisteredServers
Imports Microsoft.SqlServer.Management.Smo.Wmi

Private Class BackupDatabase
   Public Sub CreateBackup()            
            ' Create a new Instance of Backup.            
            Dim bckupDatabase As New Backup
            ' Create an Instance of the action that needs to run.
            bckupDatabase.Action = BackupActionType.Database
            ' Create a new Instance of the Server where the database is located
            Dim myServer As Server = New Server("YOURSERVERNAMEHERE")
            ' Set your database to the database which you want to backup.
            Dim myDatabase As Database = myServer.Databases("YOURDATABASENAME")
            ' Sets the current database to be used by the BackupActionType.
            bckupDatabase.Database = myDatabase.Name
            ' This I used with a folder browser dialog and to verify when the text box contains
            ' C:\ or C:\Folder so it automatically sets the slash correctly You could remove
            ' method and replace it with your own if you want the location statically. 
            Dim int As Integer = txtLocation.Text.Length

            If int = 3 Then
                bckupDatabase.Devices.AddDevice(txtLocation.Text + "\BACKUPDATABASENAME.dll", DeviceType.File)
            ElseIf int > 3 Then
                bckupDatabase.Devices.AddDevice(txtLocation.Text + "BACKUPDATABASENAME.dll", DeviceType.File)
            End If

            bckupDatabase.BackupSetName = "TYPE DATABASE BACKUP NAME HERE"
            bckupDatabase.BackupSetDescription = "TYPE DATABASE BACKUP DESCRIPTION (eg. Full Bacup) HERE"
            bckupDatabase.Initialize = False

            AddHandler bckupDatabase.PercentComplete, AddressOf CompletionStatusInPercent
            AddHandler bckupDatabase.Complete, AddressOf Backup_Completed

            bckupDatabase.SqlBackup(myServer)
        Catch ex As Exception
            MessageBox.Show(ex.Message & ex.StackTrace)
        End Try
    End Sub

    Private Sub CompletionStatusInPercent(sender As Object, args As PercentCompleteEventArgs)
        txtStatusLog.Text = String.Format("Percent completed: {0}%.", args.Percent)
    End Sub

    Private Sub Backup_Completed(sender As Object, args As ServerMessageEventArgs)
        txtStatusLog.Text = txtStatusLog.Text & vbNewLine & ("Success...Backup completed.")
        txtStatusLog.Text = txtStatusLog.Text & vbNewLine & (args.Error.Message)
    End Sub
End Class

First of all, I want to thank you very much for your answers.

to be more clear, I'll explain my need, currently I'm using sql server express (data size is limited), I have to make a backup of a table that will be large to free up space, I thought to save it as a DLL to prohibit visibility and modification

waiting for your proposals

I'm failing to understand how the data size is limited in a SQL 2008 database (WHAT SIZE IS YOUR DATABASE? 10GB + ???) If so then that explains it... I have created databases that exceed 1GB up to 6GB but the database consisted of files and such... Anyway save the table data using a class containing a List object, then use xml serializer to save it as a file with your own extension with an encryption... That might work

I added one of my unfinished projects on dropbox that will give you the idea...

DROP BOX LINK TO PROJECT[^]

But bare in mind if and when your data file becomes huge the slower it will respond to retrieval of data!!!