SQl Assemblies

Clear/Alter assembly myassembly from 'E:\Training\SqlServerProject1\SqlServerProject1\bin\Debug\SqlServerProject1.dll'

create procedure Write2File @filename nvarchar(100),@msg nvarchar(100)

as

external name myassembly.[StoredProcedures].WritetoFile

//Permissions

alter DATABASE northwind set trustworthy on

EXEC sp_configure 'clr enabled' , '1';

reconfigure

exec Write2File 'E:\Training\textsql.txt','hello world'

--Triiger

DROP ASSEMBLY myassembly

Add Triiger:

using System;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.IO;

public partial class StoredProcedures

{

    [Microsoft.SqlServer.Server.SqlProcedure]

    public static void WritetoFile(string filename,string msg)

    {

        StreamWriter sw = new StreamWriter(filename,true);

        sw.WriteLine(msg);

        sw.Close();

        // Put your code here

    }

};