What is wrong here in following screen shot?
closed as off-topic by Jon Seigel, RolandoMySQLDBA, Max Vernon, Mark Storey-Smith, Michael - sqlbot Nov 24 '13 at 22:02
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jon Seigel, RolandoMySQLDBA, Max Vernon, Mark Storey-Smith, Michael - sqlbot
Are you 100% sure that this is SQL Server 2008? This behavior suggests SQL Server 2000.
The SQL Server 2000 syntax was
Try that. If that works, when you get into the server check the compatibility level of all your databases in addition to running
The screenshot looks strange.
First of all, SQLCMD don't work with SQL Server 2000.
Among this, parameter
I tried the script like yours on SQL Server 2005 and 2008 and it works fine.
Additional information according to SQLCMD usage can be found here: