How can we help you today? How can we help you today?
Oleg
Activity overview Badges (0) Posts (18) Comments (19)

Comments

Sort by recent activity
Hi Michelle, this is a last started query SELECT so.name AS TableName, sys.schemas.name AS TableOwner, cc.name AS ConstraintName, cc.object_id AS Constraint_id, cc.is_not_for_replication AS NotForReplication, cc.is_not_trusted AS WithNoCheck, cc.is_disabled AS Disabled, sc.name AS ColumnName, cc.parent_column_id AS colid, cc.definition AS Text FROM sys.check_constraints cc WITH (NOLOCK) INNER JOIN sys.objects so WITH (NOLOCK) ON so.object_id=cc.parent_object_id LEFT JOIN sys.schemas WITH (NOLOCK) ON sys.schemas.schema_id=so.schema_id LEFT JOIN sys.columns sc WITH (NOLOCK) ON sc.column_id=cc.parent_column_id AND sc.object_id=cc.parent_object_id ORDER BY so.name, cc.name These are results of executing query by the same user as in SQLCompare intfiles dbo CK_intfiles 162815642 0 0 0 type 3 NULL These results under sa: intfiles dbo CK_intfiles 162815642 0 0 0 type 3 ([type] = N't1' or [type] = N't2' or [type] = N't3') profile_types dbo CK_profile_types 1075691080 0 1 0 type_id 3 ([type_id]>(0) AND [type_id]<=(9)) / comments
  1. Community
  2. SQL Compare 8 beta
  3. Registering database
Hi Michelle, this is a last started query SELECT so.name AS TableName, sys.schemas.name AS TableOwner, cc.name AS ConstraintName, cc.object_id AS Constraint_id, cc.is_not_for_replication AS NotForR...
0 votes
Hi Dan, oh, it seems will be very useful product. Btw, are you going to send some gifts for beta testers? Regards, Oleg. / comments
  1. Community
  2. SQL Response Beta
  3. SQL Response 1.0 Beta
Hi Dan, oh, it seems will be very useful product. Btw, are you going to send some gifts for beta testers? Regards, Oleg.
0 votes
Hi, after patching its working good. I checked all ways. Regards / comments
  1. Community
  2. SQL Compare 6 Beta
  3. First start
Hi, after patching its working good. I checked all ways. Regards
0 votes
Hi Andras, I'd like to add: SQL compare 5 is working good in my case but SQLCompare 6 is not. Are useful catched queries? Regards, Oleg. / comments
  1. Community
  2. SQL Compare 6 Beta
  3. First start
Hi Andras, I'd like to add: SQL compare 5 is working good in my case but SQLCompare 6 is not. Are useful catched queries? Regards, Oleg.
0 votes
Hi Andras, I will try to catch this. Regards, Oleg. / comments
  1. Community
  2. SQL Compare 6 Beta
  3. First start
Hi Andras, I will try to catch this. Regards, Oleg.
0 votes
Hi Andras, here are 2 statements 1 -- last for win auth. SELECT so.name AS TableName, sys.schemas.name AS TableOwner, cc.name AS ConstraintName, cc.object_id AS Constraint_id, cc.is_not_for_replication AS NotForReplication, cc.is_not_trusted AS WithNoCheck, cc.is_disabled AS Disabled, sc.name AS ColumnName, cc.parent_column_id AS colid, cc.definition AS Text FROM sys.check_constraints cc WITH (NOLOCK) INNER JOIN sys.objects so WITH (NOLOCK) ON so.object_id=cc.parent_object_id LEFT JOIN sys.schemas WITH (NOLOCK) ON sys.schemas.schema_id=so.schema_id LEFT JOIN sys.columns sc ON sc.column_id=cc.parent_column_id AND sc.object_id=cc.parent_object_id ORDER BY so.name, cc.name 2 -- last for sql auth user sa SELECT object_id AS id, definition AS text, 1 AS colid, 1 AS number, CONVERT(bit, 0) AS Encrypted, CONVERT(bit, OBJECTPROPERTY(object_id, N'IsDefaultCnst')) AS IsDefault, CONVERT(bit, ISNULL(OBJECTPROPERTY(object_id, N'ExecIsQuotedIdentOn'),0)) AS QuotedIdentifier, NULL AS ctext FROM sys.sql_modules WITH (NOLOCK) WHERE (OBJECTPROPERTY(object_id, N'IsProcedure')<>0 OR OBJECTPROPERTY(object_id, N'IsView')<>0 OR OBJECTPROPERTY(object_id, N'IsTrigger')<>0 OR OBJECTPROPERTY(object_id, N'IsInlineFunction')<>0 OR OBJECTPROPERTY(object_id, N'IsScalarFunction')<>0 OR OBJECTPROPERTY(object_id, N'IsTableFunction')<>0 OR OBJECTPROPERTY(object_id, N'IsDefaultCnst')<>0 OR object_id IN (SELECT object_id FROM sys.triggers WHERE parent_class=0) ) UNION ALL SELECT object_id AS id, definition AS text, parent_column_id AS colid, 0 AS number, CAST(0 as bit) AS Encrypted, CAST(1 as bit) AS IsDefault, CONVERT(bit, ISNULL(OBJECTPROPERTY(object_id, N'ExecIsQuotedIdentOn'),0)) AS QuotedIdentifier, NULL AS ctext FROM sys.default_constraints WITH (NOLOCK) UNION ALL SELECT object_id AS id, definition AS text, CAST(1 as int) AS colid, procedure_number AS number, CAST(0 as bit) AS Encrypted, CAST(0 as bit) AS IsDefault, CONVERT(bit, ISNULL(OBJECTPROPERTY(object_id, N'ExecIsQuotedIdentOn'),0)) AS QuotedIdentifier, NULL AS ctext FROM sys.numbered_procedures WITH (NOLOCK) ORDER BY id, colid, number / comments
  1. Community
  2. SQL Compare 6 Beta
  3. First start
Hi Andras, here are 2 statements 1 -- last for win auth. SELECT so.name AS TableName, sys.schemas.name AS TableOwner, cc.name AS ConstraintName, cc.object_id AS Constraint_id, cc.is_not_for_replic...
0 votes
I compare 2 the same databases. SQL Compare 6 1. Using Windows Auth. for both db SQL Compare aborting, Registering databases SQL-SRV1.db87-Reading constraints, Unable to cast object of type 'System.DBNull' to type 'System.String' 2. Using SQL Server auth. for both db, user sa (!) SQL Compare aborting, Registering databases SQL-SRV1.db87-Reading object text, Object reference not set to an instance of an object. SQL Compare 5 1. Using Windows Auth. for both db SQL Compare aborting, Registering databases SQL-SRV1.db87-Reading constraints, Specified cast is not valid. 2. Using SQL Server auth. for both db, user sa (!) All ok, dbs compared successfully. (!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!) Note. Windows user is not an admin on the sql server machine. Regards, Oleg. / comments
  1. Community
  2. SQL Compare 6 Beta
  3. First start
I compare 2 the same databases.SQL Compare 6 1. Using Windows Auth. for both db SQL Compare aborting, Registering databases SQL-SRV1.db87-Reading constraints, Unable to cast object of type 'System....
0 votes
Ok, Johnatan. I'd like to add only: The this SQL Compare behavoiur is different for Windows authentication and SQL authentication. / comments
  1. Community
  2. SQL Compare 6 Beta
  3. First start
Ok, Johnatan. I'd like to add only: The this SQL Compare behavoiur is different for Windows authentication and SQL authentication.
0 votes
On Another machine: SQL Compare aborting, Registering databases SQL-SRV1.db87-Reading constraints, Unable to cast object of type 'System.DBNull' to type 'System.String' / comments
  1. Community
  2. SQL Compare 6 Beta
  3. Cannot compare
On Another machine: SQL Compare aborting, Registering databases SQL-SRV1.db87-Reading constraints, Unable to cast object of type 'System.DBNull' to type 'System.String'
0 votes
Total activity
49
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
12