'GO'附近的语法不正确。 [英] Incorrect syntax near 'GO'.

问题描述

大家好，



我在托管上运行MSSQL脚本时遇到问题。我在命令提示符下使用aspnet_regsql创建了一个sql db。在我生成db的脚本之后。



当我尝试在我的主机上运行此脚本时。它在GO错误附近给出了错误的语法。



我正在尝试导入只是默认的aspnet_regsql的数据库。



我找不到问题。





我还制作了一个.bak文件。我试过这种方式。但是这次我们有这个错误：

Hello everyone ,

I have a problem about running my MSSQL script on my hosting. I created a sql db using aspnet_regsql on command prompt. After i generate db's script.

When i trying to run this script on my hosting. It's giving Incorrect syntax near "GO" error.

I'm trying import just default aspnet_regsql's db.

I can't find the problem.


Also i made a .bak file. I tried this way. But this time we have this error :

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'RESTORE' task on 'aspnetdb' SQL_DATABASE ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> The media family on device 'C:WindowsTEMPaspnetdb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE FILELIST is terminating abnormally.

推荐答案

我认为您的.sql文件存在格式问题。请参阅 [格式问题]

I think your .sql file has format issue. Refer [Format Issue]

这篇关于'GO'附近的语法不正确。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！