• i just create a view of a trace,a nd then scripted the view to be a table;

    CREATE VIEW sp_DMLTrace

    AS

    SELECT * FROM ::fn_trace_gettable('c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\MyDMLtrace2.trc', default)

    here's it's definition; does it match what you were using?

    CREATE TABLE [dbo].[SP_DMLTRACE] (

    [TEXTDATA] NTEXT NULL,

    [BINARYDATA] IMAGE NULL,

    [DATABASEID] INT NULL,

    [TRANSACTIONID] BIGINT NULL,

    [LINENUMBER] INT NULL,

    [NTUSERNAME] NVARCHAR(256) NULL,

    [NTDOMAINNAME] NVARCHAR(256) NULL,

    [HOSTNAME] NVARCHAR(256) NULL,

    [CLIENTPROCESSID] INT NULL,

    [APPLICATIONNAME] NVARCHAR(256) NULL,

    [LOGINNAME] NVARCHAR(256) NULL,

    [SPID] INT NULL,

    [DURATION] BIGINT NULL,

    [STARTTIME] DATETIME NULL,

    [ENDTIME] DATETIME NULL,

    [READS] BIGINT NULL,

    [WRITES] BIGINT NULL,

    [CPU] INT NULL,

    [PERMISSIONS] BIGINT NULL,

    [SEVERITY] INT NULL,

    [EVENTSUBCLASS] INT NULL,

    [OBJECTID] INT NULL,

    [SUCCESS] INT NULL,

    [INDEXID] INT NULL,

    [INTEGERDATA] INT NULL,

    [SERVERNAME] NVARCHAR(256) NULL,

    [EVENTCLASS] INT NULL,

    [OBJECTTYPE] INT NULL,

    [NESTLEVEL] INT NULL,

    [STATE] INT NULL,

    [ERROR] INT NULL,

    [MODE] INT NULL,

    [HANDLE] INT NULL,

    [OBJECTNAME] NVARCHAR(256) NULL,

    [DATABASENAME] NVARCHAR(256) NULL,

    [FILENAME] NVARCHAR(256) NULL,

    [OWNERNAME] NVARCHAR(256) NULL,

    [ROLENAME] NVARCHAR(256) NULL,

    [TARGETUSERNAME] NVARCHAR(256) NULL,

    [DBUSERNAME] NVARCHAR(256) NULL,

    [LOGINSID] IMAGE NULL,

    [TARGETLOGINNAME] NVARCHAR(256) NULL,

    [TARGETLOGINSID] IMAGE NULL,

    [COLUMNPERMISSIONS] INT NULL,

    [LINKEDSERVERNAME] NVARCHAR(256) NULL,

    [PROVIDERNAME] NVARCHAR(256) NULL,

    [METHODNAME] NVARCHAR(256) NULL,

    [ROWCOUNTS] BIGINT NULL,

    [REQUESTID] INT NULL,

    [XACTSEQUENCE] BIGINT NULL,

    [EVENTSEQUENCE] BIGINT NULL,

    [BIGINTDATA1] BIGINT NULL,

    [BIGINTDATA2] BIGINT NULL,

    [GUID] UNIQUEIDENTIFIER NULL,

    [INTEGERDATA2] INT NULL,

    [OBJECTID2] BIGINT NULL,

    [TYPE] INT NULL,

    [OWNERID] INT NULL,

    [PARENTNAME] NVARCHAR(256) NULL,

    [ISSYSTEM] INT NULL,

    [OFFSET] INT NULL,

    [SOURCEDATABASEID] INT NULL,

    [SQLHANDLE] IMAGE NULL,

    [SESSIONLOGINNAME] NVARCHAR(256) NULL,

    [PLANHANDLE] IMAGE NULL)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!