Sqlcmd with Timeout Error

Question

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

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

jezemine SSCrazy Eights Points: 8059 More actions · Answer 1

this surprises me. Are you sure you are checking ERRORLEVEL correctly?

can you post the relevant part of your batch script?

---------------------------------------
elsasoft.org

Sql Junkie-204042 Hall of Fame Points: 3874 More actions · Answer 2

Put this in a .sql file

SET NOCOUNT ON

DECLARE @DelayLength char(8)

SET @DelayLength = '00:00:50' -- delay for 50 seconds

WAITFOR DELAY @DelayLength

Put this in a batch file and run is a dos window

@ECHO OFF

sqlcmd -E -S {ServerName} -d {DatabaseName} -t 5 -b -V 1 -i {ScriptFileName With path created above}

ECHO %ERRORLEVEL%

jezemine SSCrazy Eights Points: 8059 More actions · Answer 3

sure enough. this pretty much sucks for automating your scripts I have to say.

this issue has been raised before here on ssc and not answered:

if I were you I would post it on one of the ms newsgroups and someone from the sql server tools team may answer. here for example:

---------------------------------------
elsasoft.org