Msg 3728 and 3727

Tue, 30 Jun 2009 15:50:40 Z

Hi, I have this error when executing the command

D:\ROP\EPM.Aguas.ROP\EPM.Aguas.ROP.DatabaseComparison\Database3\sql\debug>sqlcmd
-S localhost -d EPM_ROP_JUNIO_25_CONCAMBIOSDESDEDESARROLLO -i Database3.sql

Changed database context to 'master'.
Changed database context to 'EPM_ROP_JUNIO_25_CONCAMBIOSDESDEDESARROLLO'.
Dropping ROP.FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados...
Msg 3728, Level 16, State 1, Server C-LVALENCIA1, Line 1
'FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados' is not a constraint.
Msg 3727, Level 16, State 1, Server C-LVALENCIA1, Line 1
Could not drop constraint. See previous errors.

The error is on these lines of the script

PRINT N'Dropping ROP.FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados...';

GO
ALTER TABLE [ROP].[CaudalesLodoPrimario] DROP CONSTRAINT [FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados];

MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/

Msg 3728 and 3727

Tue, 30 Jun 2009 16:00:13 Z

These error messages are coming from SQL server. Looks like you were executing the deployment scripts by using sqlcmd against your local Sql instance.

If you want to deploy your database project to a target server, you can try using Deploy menu in the project (with deployment settings in the properties page). Or you can go thru the command line tool VSDBCMD.

--Joyce

Msg 3728 and 3727

Tue, 30 Jun 2009 16:42:59 Z

where can I find that command tool?

MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/

Msg 3728 and 3727

Tue, 30 Jun 2009 17:04:58 Z

If you are using GDR or GDR R2, you should be able to find it at <VS installation path>\VSTSDB\Deploy\