Comments
Sort by recent activity
Thank you.
Enjoy your Christmas/New Years!
Aaron / comments
Thank you.
Enjoy your Christmas/New Years!
Aaron
Thanks that did it. I didn't have any snippets so I just deleted the file. I closed SQL Prompt and stared it again, then opened QA. QA had some error and closed immediately so I opened it again and it worked.
So far so good.
thanks. / comments
Thanks that did it. I didn't have any snippets so I just deleted the file. I closed SQL Prompt and stared it again, then opened QA. QA had some error and closed immediately so I opened it again and...
Version: 5.2.0.32
I have both .Net 1.1 and 2.0 installed. How do I know which version is being used?
The objects that I am seeing are tables, stored procedures, triggers... Basically I'm seeing a number of different objects in the upper window of different objects, but in the lower window the objects don't have any difference. Is there a difference that is not being shown? / comments
Version: 5.2.0.32
I have both .Net 1.1 and 2.0 installed. How do I know which version is being used?
The objects that I am seeing are tables, stored procedures, triggers... Basically I'm seeing a n...
Jonathan,
SQL Server Version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
I am not using encription in stored procedures.
Under the "Options" tab I have "Users's permissions and role memberships" selected.
Under "More Options" I have the following checked.
Force column order
Disable DDL triggers during synchronization
WITH NOCHECK
Filegroups, parition schemes, and partition functions
User properties
Is it possible that this is happening because I'm using a version of SQL Server with an old service pack? I am going to update this, but I can't do it until tonight.
I'll get an email out directly to you later today. / comments
Jonathan,
SQL Server Version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 379...
I think I just found something that I hadn't seen before. I was able to change to field to is used for CustomerOrder to the correct PK using a drop down in the top of the table definition popup window. I also now have left the "Drop primary key..." option un-checked and it seems to work better. I'll try some more tests now with the option checked again. / comments
I think I just found something that I hadn't seen before. I was able to change to field to is used for CustomerOrder to the correct PK using a drop down in the top of the table definition popup win...
I found something about one of the tables that I have a question about. On one side of the comparison the PK for CustomerOrder table is not recognized. Meaning that on one side of the Tables & Views tab the Key is set to custom and on the other side the Key is automatically set to the PK CustomerOrderID. Does this have anything to do with the problem? Why would the PK be recognized on one side and not on the other. / comments
I found something about one of the tables that I have a question about. On one side of the comparison the PK for CustomerOrder table is not recognized. Meaning that on one side of the Tables & View...
Here is the message I get, this is the first four lines of the window.
The following error message was returned from the SQL Server:
[3725] The constraint 'PK_CustomerOrder' is being referenced by table 'EmployeeCommissionShare', foreign key constraint 'FK_EmployeeCommissionShare_CustomerOrder'.
Could not drop constraint. See previous errors.
If I now remove this constraint manually and re-run the script it works. / comments
Here is the message I get, this is the first four lines of the window.
The following error message was returned from the SQL Server:
[3725] The constraint 'PK_CustomerOrder' is being referenced by ...
Yes, I do have both Disable foreign keys and Drop primary keys, indexes and unique constraints. / comments
Yes, I do have both Disable foreign keys and Drop primary keys, indexes and unique constraints.
Hello Brian,
I'm using version 5.2.0.40 and have the following options set.
Checked: Disable foreign keys
Checked: Drop primary keys, indexes, and unique constraints
Checked: Use transactions in SQL scripts
I do not have Disable DDL triggers checked.
Is there anything that I should change? / comments
Hello Brian,
I'm using version 5.2.0.40 and have the following options set.
Checked: Disable foreign keys
Checked: Drop primary keys, indexes, and unique constraints
Checked: Use transactions in SQ...
I just made this sync work by manually dropping the relationship between the two tables, but I still wonder why SQL Data Compare doesn't see this dependency and drop/re-create the constraint on it's own. / comments
I just made this sync work by manually dropping the relationship between the two tables, but I still wonder why SQL Data Compare doesn't see this dependency and drop/re-create the constraint on it'...