SQL Server Shortcut to take Table Backup

  • Comments posted to this topic are about the item SQL Server Shortcut to take Table Backup


    Thanks & Regards,
    N.S.Sathish(SQL DBA)

  • That SP is very open to SQL Injection. I would strongly suggest making changes to lower the exposure.


    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • This isn't working for me. You state: "...if the system stored procedure is added on shortcut key "CTRL+3",we can take the table backup by selecting any tables and by pressing "CTRL+3" option."

    Select any table how? Pressing CTRL+3 emits the query text in the query edit window but the table selected in the object explorer pane is ignored so that pressing CTRL+3 gives the following results:

           Msg 201, Level 16, State 4, Procedure sp_TableBackup, Line 0
          Procedure or function 'sp_TableBackup' expects parameter '@tblname', which was not supplied.

    So please explain, step-by-step, exactly how to "selecting any tables" (sic) so that pressing CTRL+3 executes the stored procedure with the selected table name passed in as the parameter.

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

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