SQL Server Shortcut to take Table Backup

• sathieshsql

  Mr or Mrs. 500

  Points: 531

  More actions

  August 24, 2018 at 5:37 am

  #408304

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

  --

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

• Thom A

  SSC Guru

  Points: 99142

  More actions

  August 24, 2018 at 6:03 am

  #2003183

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

  Thom~

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

• bmills-568012

  Grasshopper

  Points: 15

  More actions

  August 24, 2018 at 11:51 am

  #2003256

  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.