Posts
Sort by recent activity
Bug: Insufficient error info w/dupe extended property defs
Consider the following trivial DDL:CREATE TABLE dbo.Widgets
(
widget_id UNIQUEIDENTIFIER NOT NULL
);
-- The first extended property works fine.
EXEC sys.sp_addextendedproperty N'MS_Des...
Apparent problem w/computed columns that use CLR UDTs.
I've run into some trouble with SQL Compare 6.1 and computed columns that involve CLR UDTs. Here are the steps to reproduce:
1. Create an assembly.
2. Create a user-defined type ("MyUDT") that refe...
Apparent problem w/DEFAULT constraints of NEWSEQUENTIALID()
When I try to synchronize this following scripted table:CREATE TABLE foo
(
foo_id UNIQUEIDENTIFIER CONSTRAINT default_foo_id DEFAULT NEWSEQUENTIALID() NOT NULL
);
I get the fo...
CHECK constraint dependencies upon user-defined functions?
I have a project that has a CLR assembly, several user-defined functions which call the assembly, as well as tables that have CHECK constraints which refer to those user-defined functions. I am usi...
System.NullReferenceException while parsing scripts
I'm trying out SQL Compare 6 and have run into a problem with the new scripts feature. We're investigating how we can integrate SQL Compare into our build process. I'm wondering if someone else has...