Competition: What’s your favorite Redgate tool? Enter now.

Errors reported by Query Analyser

Brian DonahueBrian Donahue Posts: 6,590 New member
edited December 30, 2002 12:39PM in SQL Compare Previous Versions
Hi Crispin,

How was your Christmas holiday? Good, I hope. Thanks for the comments
about the website. We worked really hard on it.
Is your database case-sensitive, by any chance?

Regards,


Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

( +44 870 1600 037

* mailto:[email protected].com


"Crispin Horsfield" <[email protected]> wrote in message
news:[email protected]
> Hi
>
> Version: SQL Compare 2.02
>
> I was running an update on a remote server and got these errors (database
> name changed to xxxx):
>
--
>
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The object was renamed to 'LDefaultWebStyles'.
> Updating dbo.LHtmlTemplates
> Updating dbo.LWebFolders
> Server: Msg 2714, Level 16, State 4, Line 11
> There is already an object named 'DF__Temporary__intWe__00551192' in the
> database.
> Server: Msg 1750, Level 16, State 1, Line 11
> Could not create constraint. See previous errors.
>
> (1 row(s) affected)
>
> Server: Msg 4902, Level 16, State 1, Line 2
> Cannot alter table 'dbo.LWebFolders' because this table does not exist in
> database 'xxxxx'.
>
> (1 row(s) affected)
>
> Updating dbo.LWordFolders
> Server: Msg 2714, Level 16, State 4, Line 10
> There is already an object named 'DF__Temporary__intWo__1273C1CD' in the
> database.
> Server: Msg 1750, Level 16, State 1, Line 10
> Could not create constraint. See previous errors.
>
> (1 row(s) affected)
>
> Server: Msg 1906, Level 11, State 1, Line 2
> Cannot create an index on 'dbo.LWordFolders', because this table does not
> exist in database 'xxxxx'.
>
> (1 row(s) affected)
>
> Server: Msg 4902, Level 16, State 1, Line 3
> Cannot alter table 'dbo.LWordFolders' because this table does not exist in
> database
>
>
> the it runs OK for a while
>
> Creating triggers
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'CWordDocuments_DTrig'.
>
> (1 row(s) affected)
>
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'CWordDocuments_UTrig'.
>
> (1 row(s) affected)
>
> Server: Msg 2714, Level 16, State 4, Line 4
> There is already an object named 'CWordDocumentProperties_FK00' in the
> database.
> Server: Msg 1750, Level 16, State 1, Line 4
> Could not create constraint. See previous errors.
>
> (1 row(s) affected)
>
> The database update failed
>
>
> Any ideas?
>
> Have a good Christmas.
>
> Crispin Horsfield
> Caz Limited
>
> PS Like the new website
>
>
>
>
>
This discussion has been closed.