Re: Question about ms sql server side tracing(sp_trace_create procedure)

Dan Guzman (guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have searched through all the available sql server documentation and
I have not been able to find how we can prevent the sql server from
making system calls to write trace files to the file system using
sp_trace_create procedure.

My first guess is that the SQL Server service account doesn't have
permissions to the trace folder. There may also be related messages in
the error log. Perhaps your client can provide more details on the
hardening.

And I like to add that, either your client does not want you to run
sp_trace_xxx, in which case he has to accept that you can do a good
job in helping him with performance. Or he wants to you help you with
performance, in which case he should be cooperative and help you out.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Question about ms sql server side tracing(sp_trace_create procedure)
    ... making system calls to write trace files to the file system using ... My first guess is that the SQL Server service account doesn't have permissions to the trace folder. ... from creating the trace files on the file system. ...
    (microsoft.public.sqlserver.security)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)