Errors reported by Query Analyser

Brian Donahue

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:brian.donahue@red-gate.com


"Crispin Horsfield" <crispin@cazonline.com> wrote in message
news:OhQaJW0qCHA.1156@server53...
> 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
>
>
>
>
>