Registre depuració SQLServer

Taula

DROP TABLE DMB;
CREATE TABLE DMB
(
    ID int IDENTITY(1,1) PRIMARY KEY ,
    Texte nvarchar(4000),
    "Data" DateTime    
);

Procediment

CREATE PROC [dbo].[sp_debug]
@texte nvarchar(4000)			
as
begin
  insert into DMB ("Texte","Data") values (@texte,GETDATE())
end

Crida

exec sp_debug 'Registre'