Post reply

How to read transaction

  • July 18, 2012 at 11:43 am

    #264017

    Hello

    I need to read transaction

    I wrote store procedure and in that i need to import data in one table so when i run my store proc, the log says it loaded by when i check that table there is nothing on that.

    so i need to read transaction.

    is there anyway in sql server, i read transaction, what exactly happen when i run my store proc

    please reply me. Thanks in advance

  • July 18, 2012 at 11:58 am

    #1514413

    If you are calling your stored procedure directly from SSMS then you could add some debug information into the procedure. Such as "select count(*) from inputtable".

    If you are calling the stored procedure from an application then you can use SQL Profiler to see what sql statements are being sent from the application to your procedure.

    regards

    david

  • July 18, 2012 at 12:09 pm

    #1514423

    use @@rowcount after your insert statement to check if there is any data inserted

    Refer this link:

    http://technet.microsoft.com/en-us/library/ms187316.aspx

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

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

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