﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SQL Server 2005 Strategies  / SQLCMD.exe returning error code 1 while creating database(.sql and .bin files). / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sun, 19 May 2013 23:14:26 GMT</lastBuildDate><ttl>20</ttl><item><title>SQLCMD.exe returning error code 1 while creating database(.sql and .bin files).</title><link>http://www.sqlservercentral.com/Forums/Topic1381351-361-1.aspx</link><description>Hi,   I am using SQL Server 2005 Express edition to create Database instance(Named Instance) and create database(executing .sql and .bin file) on the named instance.   In the above case i succeeded in creation of database instance(Named instance) but while creating database on the instance i am getting error code 1. Note:- For creating database instance i am using OSQL.exe and SQLCMD.exe. Using OSQL.exe i am executing .sql files and using SQLCMD.exe i am executing .bin files.But i am not facing any issue with OSQL.exe i am facing issue with SQLCMD.exe.Following command i am executing using SQLCMD.exeC:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.exe -S \InstanceName -d DatabaseName -i C:\database.bin the above command returns error code 1.If any body knows the root cause please help me ASAP.Thanks in Advance.</description><pubDate>Mon, 05 Nov 2012 20:31:43 GMT</pubDate><dc:creator>reddy.reddappa</dc:creator></item></channel></rss>