Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nancyd1111
  • Content: Threads
  • Order by date
  1. nancyd1111

    xp_cmdshell

    Hi, I am trying to erase a file using xp_cmdshell and my filename is stored in a variable. Can you tell me how I allow xp_cmdshell to interpret my filename instead of taking it as a literal? Thanks in advaince! ------------------------------------------------------- set @filename =...
  2. nancyd1111

    Identifying a TraceID

    If I have executed a stored procedure to create a trace file, how is it that at a later point I identify the TraceID of this newly created file so that I can stop and close the trace? If I try to delete a .trc file and it hasn't been closed, I get a sharing violation message, which is expected...
  3. nancyd1111

    Using variables in built-in stored procedures

    I'm trying to pass in a varible to a stored proc and I'm not having success. If I don't use a variable, a trace file is created. If I use a variable, the trace file is not created. Any idea why? This works when I hard code the drive and filename: exec @rs = sp_trace_create @traceid output...

Part and Inventory Search

Back
Top