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