Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Angry Unanswered: Using xp_cmdshell to execute an SP

    Could someone help me, I need to execute a stored procedure using xp_cmdshell. I know the functionality exists, but cannot recall the syntax...and connot find it anywhere.

    Thanks!

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Executing a SP via xp_cmdshell is a very strange thing to want to do.
    Easiest way is probably to use isql which is well documented in bol.

    exec master..xp_cmdshell 'isql ...'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •