SQL Server Performance

xp[_]cmdSheel is not working properly

Discussion in 'General Developer Questions' started by dineshasanka, Jan 10, 2007.

  1. dineshasanka Moderator

    I run a query. See my query below,

    master..xp[_]cmdshell 'FIND  "2007-01-19" "e:mssql7logerrorlog"'[code]
    The above script is working fine in sql server 2000 server but it is not working in sql server 7. Do you known the reason?
    Advance Thanks
    I am posting this on half of S. Ramesh, as he is unable to post this
    Contributing Editor, Writer & Forums Moderator
    Visit my Blog at
  2. sramesh New Member

    Thanks dinesh

    S. Ramesh
  3. Adriaan New Member

    As your query is effectively running a command from an OS prompt, the Windows account under which your SQL Server instance is running needs to have sufficient OS-level permission on the e:mssql7log folder.

    So I would assume there are differences at the Windows level between the SQL 7.0 and SQL 2000 instances.
  4. MohammedU New Member

    As Adrian mentioned it could be permission issue...

    He can try the following...

    exec master.dbo.xp_readerrorlog -1, 'e:mssql7logerrorlog', '2007-01-09'

    Mohammed U.
  5. sramesh New Member

    Thanks Mohanmmed. Now my problem solved.

    S. Ramesh

Share This Page