Syntax error in SQLCMD SQL script?

Question

I'm currently trying to get a SQL script working for SQL Server 2005. I'm using SQLCMD to execute the script and it fails giving me an "Error: Syntax error at line 7 near command ':r'" error.

The script:

--Main Script--
SET NOCOUNT ON
GO

:on error exit

:r C:\Documents and Settings\ZSmith\My Documents\Scripts\CreateDatabase
:r C:\Documents and Settings\ZSmith\My Documents\Scripts\CreateTables

I can provide the other SQL scripts if needed but they function fine on their own. I'm just trying to automate the entire process.

Why the downvote? Could you at least tell me what I'm doing wrong? — DanteTheEgregore
– DanteTheEgregore, Commented Jul 3, 2013 at 15:54

marc_s · Accepted Answer · 2013-07-03 15:59:58Z

2

From what I know, you need to

put the SQL file name into double quotes - especially if the path contains spaces!
include the .sql extension on the file name

Try this:

:r "C:\Documents and Settings\ZSmith\My Documents\Scripts\CreateDatabase.sql"
:r "C:\Documents and Settings\ZSmith\My Documents\Scripts\CreateTables.sql"

answered Jul 3, 2013 at 15:59

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error in SQLCMD SQL script?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related