1
kudos
spam Kudos Remove

Control database management tasks from command line - SQLCMD

published 593 days, 1 hour, 25 minutes ago posted by sasa 601 days, 3 hours, 39 minutes ago
Thursday, June 24, 2010 12:41:12 PM GMT Wednesday, June 16, 2010 10:26:49 AM GMT
If you remember ISQL or OSQL then you should continue using SQLCmd from SQL Server 2005 onwards, an useful utility lets you enter TSQL statements, system procedures, and script files at the command prompt. Not only as a command line from outside of SQL process, you can run this tool from SSMS Query Editor in SQLCMD mode, in a Windows script file or even in an operating system (Cmd.exe) job step of a SQL Server Agent job. In the recent connection with a client about Database upgrade project, it has...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: behaviour changes, Best Practices, code, command prompt, execution, SQL Server, sqlcmd, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup