August 24, 2018 at 5:37 am
Comments posted to this topic are about the item SQL Server Shortcut to take Table Backup
--
Thanks & Regards,
N.S.Sathish(SQL DBA)
August 24, 2018 at 11:51 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy