var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: "File not created" from sp_trace_create
I am getting a return code of 12 (""
File not created"") from sp_trace_create.
I have checked to ensure that the path is valid. I am using Windows Authentication and the Windows Administrator account.
SQL Server is using the Windows userid that I created for SQL Server. I have verified (at least tried to verify) that the user for SQL Server has access to the folder containing it.
The following is the relevant portion of what I am attempting.
I have tried other paths that also do not work.
DECLARE @RC int, @TraceId int
Exec @RC = sp_trace_create @TraceId OUTPUT, 0, N'C:\TraceFile'
Last edited by Sam Hobbs; 06-11-06 at
I used a path that was for a FAT partition and that worked, so it was a file permission problem. I don't know how to determine what path would be valid for the SQL Server account but that is a different question.