Forum Replies Created

Viewing 15 posts - 61 through 75 (of 131 total)

  • RE: Try catch in a SP

    nitinpatel31 (3/5/2009)

    It has some errors.

    - It is RAISERROR not RAISEERROR.

    - Function can be passed as argument.

    Use below code for it

    DECLARE @Error VARCHAR(150)

    SET @Error = ERROR_MESSAGE()

    RAISERROR (@Error,16,1)

    Thanks for your help. Now...

    March 5, 2009 at 7:42 am

    #954032

  • RE: Try catch in a SP

    nitinpatel31 (3/5/2009)

    Use RAISERROR statment inside CATCH block.

    How could I add the RAISEERROR stmt in the above CATCH block.

    If I add it before END CATCH stmt, it is showing the error___

    Msg...

    March 5, 2009 at 5:14 am

    #953922

  • RE: Try catch in a SP

    Hi,

    Thanks for you reply.

    But I didn't get what I want in the above code.

    I want to insert the errors into a error_log table when the insertion to a table fails....

    March 5, 2009 at 4:09 am

    #953897

  • RE: Try catch in a SP

    OK.... sorry....

    I found the problem.

    There is an extra ;(semicolon) came in the line ERROR_MESSAGE()

    It looks simple but I struggled to find out.

    Thanks for your help,

    Venki.

    March 5, 2009 at 2:31 am

    #953859

  • RE: Negative numbers......

    GilaMonster (2/20/2009)

    While it's not perfect, try using ISNUMERIC and see if there are any columns that it considers not numbers.

    Thanks GilaMonster.

    It is due to some nonnumeric data I believe. I...

    February 20, 2009 at 3:07 am

    #947381

  • RE: Schedule DTS package in SQL Server 2005

    Greg Charles (2/13/2009)

    You can't right-click on a package in SQL 2005 Management Studio and create a job like you could in SQL 2000 Enterprise Manager. In SQL 2005, you...

    February 13, 2009 at 12:18 pm

    #943880

  • RE: Schedule DTS package in SQL Server 2005

    Thanks a lot for your quick replies.

    I didn't change the DTS to SSIS. I kept as it is.

    When I am trying to schedule it i.e. I tried add it as...

    February 13, 2009 at 10:01 am

    #943765

  • RE: Table meta data

    Adi Cohn (2/13/2009)

    SQL Server doesn’t store this information. If you need to know who updated a table and when it was updated, you need to implement your own mechanism...

    February 13, 2009 at 2:09 am

    #943392

  • RE: Ignore apostrophe(') in SQL Server

    I am doing a vb program which requires this one.

    I will first taking that employee name into a variable and checking for apostrophe(') and if it is there then replace...

    February 11, 2009 at 1:23 am

    #941882

  • RE: Ignore apostrophe(') in SQL Server

    GSquared (2/9/2009)

    If you put two apostrophes in a row in that, SQL will allow it.

    Thanks for your response.

    But my question is I want to do it in single stmt.

    Actually, I...

    February 9, 2009 at 12:45 pm

    #940745

  • RE: problem with sizes

    Hi,

    I got a small doubt. Let me explain the process and then my doubt.

    I am tranferring the data from couple of tables to another table.

    I am using temporary tables called...

    February 2, 2009 at 8:18 am

    #936459

  • RE: problem with sizes

    Thanks a lot for your valuable suggestions.

    I am checking the data and sizes and adjust accordingly.

    Best wishes,

    Venki.

    January 29, 2009 at 6:11 am

    #934574

  • RE: problem with sizes

    steveb (1/29/2009)

    If the data size is to big for the column then the insert will fail.

    Otherwise if is the the same size or less then it will succeed.

    This does depend...

    January 29, 2009 at 4:33 am

    #934511

  • RE: Create database using Backup file

    steveb (11/19/2008)

    venki (11/19/2008)

    Perry Whittle (11/18/2008)

    venki

    you can of course also use the management studio if you prefer GUI interraction

    How can we do with SQL Server Management Studio?

    Right Click on databases node...

    January 9, 2009 at 5:41 am

    #924052

  • RE: SP for row count of tables

    Is the DBA unwilling to grant the VIEW DATABASE STATE permission to you? If so, that will limmit your options here.

    I am not sure I have this Permission. I...

    January 6, 2009 at 12:12 am

    #921587

Viewing 15 posts - 61 through 75 (of 131 total)