Post reply

sql cmd utility

  • July 17, 2009 at 1:39 am

    #207088

    Hi

    I have 10 scripts which I want to run them as batch. I tried running the batch from my system(which is sql server 2005 client) through command prompt. Its giving me error.

    but when I run directly on the server then the batch is running.

    Please help me how can i run the batch from my system which is not server for sql2005

    Thanks

  • July 17, 2009 at 2:15 am

    #1026051

    You've given us almost no information with which to help you. What is the error message? What are the scripts? How are you trying to call them from sqlcmd? Since we can't see what you're seeing, you're going to need to tell us all of this.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • July 21, 2009 at 4:03 am

    #1027489

    Wayne is rigth !!

    what are the errors ? Metion the errors and the script u had run

    Milesh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply