How can we help you today? How can we help you today?
alex_sefrin

Activity overview

Latest activity by alex_sefrin

SQLDataCompare.Engine needs System.Threading.dll
We're currently using RedGate.SQLDataCompare.Engine 10.7. for our nightly VisualStudio tests (v13 update 4, .NET framework 4.0) to compare tables. After upgrading to 10.7 and Framework 4.0 we sudd...
3 followers 4 comments 0 votes
Collation is Latin1_General_CI_AS for both databases. Another problem is that in some statements the square brakets are missing now. new CREATE TRIGGER [dbo].[Adressen_Delete] ON dbo.Adressen FOR DELETE AS old CREATE TRIGGER [dbo].[Adressen_Delete] ON [dbo].[Adressen] FOR DELETE AS Re missing N: The N isn't missing on all ext. prop. I can't find a rule when it is missing. -- Extended Properties EXEC sp_addextendedproperty N'MS_Description', '0 = nicht speichern', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'AdressHistorieJN' GO EXEC sp_addextendedproperty N'MS_Description', N'Datum, an dem diese Adresse erstmals erfasst wurde', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'AnlageDatum' GO EXEC sp_addextendedproperty N'MS_Description', N'Ist diese Adresse eine Filiale?', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Filiale' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe1' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe2' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe3' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe4' GO EXEC sp_addextendedproperty N'MS_Description', 'weitere Gruppenzugehörigkeit (frei)', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Gruppe5' GO EXEC sp_addextendedproperty N'MS_Description', 'EDI: Internationale Nummer, die die Adresse eindeutig identifiziert. Format: Basis|RestNr und Prüfziffer', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'ILN' GO EXEC sp_addextendedproperty N'MS_Description', N'0=aktiv, 1=inaktiv, Adresse wird nicht mehr angezeigt bzw. benutzt für Exporte', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'InaktivJN' GO EXEC sp_addextendedproperty N'MS_Description', N'Ist diese Adresse ein Interessent?', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Interessent' GO EXEC sp_addextendedproperty N'MS_Description', N'URL der Website der Adresse', 'SCHEMA', N'dbo', 'TABLE', N'Adressen', 'COLUMN', N'Internet' GO I will create to dbs an try to reproduce the errors. / comments
Collation is Latin1_General_CI_AS for both databases. Another problem is that in some statements the square brakets are missing now. new CREATE TRIGGER [dbo].[Adressen_Delete] ON db...
0 votes
Extended Properties
I just installed the new version and suddenly getting lots of different objects. New: EXEC sp_addextendedproperty N'MS_Description', 'Auswertegruppennummer', 'SCHEMA', N'dbo', 'TABLE', N'Auswertegr...
2 followers 4 comments 0 votes
Hi Matthew, my tables have some delete triggers and they fire if I try to delete them in the wrong order. Kind regards, Alex / comments
Hi Matthew, my tables have some delete triggers and they fire if I try to delete them in the wrong order. Kind regards, Alex
0 votes
Orderd Data Compare?
Hi, is there a way to tell the synchronization in which table order it should delete/insert rows? I can‘t synchronize my databases because referential integrity problems. Thanks, Alex
3 followers 4 comments 0 votes