Windows Login

Technical Article

RE: OSQL batch files

  • Reply

Add -m-1to your osql parametersCreate your batch file like thisCALL batchfile.bat servername databasename scriptname1.sql IF ERRORLEVEL 1 GOTO ER CALL batchfile.bat servername databasename scriptname2.sql IF ERRORLEVEL 1 GOTO ER CALL batchfile.bat servername databasename scriptname3.sql IF ERRORLEVEL 1 GOTO ER GOTO EX :ER ECHO Error :EX

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-12-23

Blogs

EightKB 2024 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

By

I had a customer that was looking to document a restore that had occurred...

T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me

By

DIVERSIFY! We devote a lot of time to mastering the technology that we are...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers