Activity overview
Latest activity by danboc
Computed columns and SQL prompt
Hi,
I guess this is a bug/feature request:
When SQL prompt expands an INSERT INTO command, it includes computed columns in the field list and the value list. As these fields cannot be updated there...
Hi Dan,
8.0.2 fixed the problem for us.
Daniel / comments
Hi Dan,
8.0.2 fixed the problem for us.
Daniel
Hi Peter, Hi David,
What I meant in my last post about there not being much point to an explicit value reseed is that the next sync will "fix" any discrepancies anyway, so why bother with an explicit value. What should be the primary concern is the "health" of the identity in the target table (i.e. executing a reseed WITHOUT an explicit value). An explicit reseed value is moot in the context of data syncing...
On the other hand if people really want the seeds to match then an explicit value should only be used if the tables are fully synced (both directions, all rows).
My tuppence.
Daniel
PS Thanks again for the attention to this matter. / comments
Hi Peter, Hi David,
What I meant in my last post about there not being much point to an explicit value reseed is that the next sync will "fix" any discrepancies anyway, so why bother with an explic...
Hi Peter,
There is still a problem. Example:
- SOURCE table has a current identity of 100;
- I choose row IDs 1-50 for the sync;
- At the end of the sync the CHECKIDENT will reseed with an explicit value of 100! If the TARGET table had IDs 101-200 then the next insert will crash.
My suggestion: Do not set an explicit value for the reseed. There is no point if you think about it.
Daniel / comments
Hi Peter,
There is still a problem. Example:
- SOURCE table has a current identity of 100;
- I choose row IDs 1-50 for the sync;
- At the end of the sync the CHECKIDENT will reseed with an explicit...
Hi Peter
Charles' first reply to me shows clearly how this happens and I can second the fact that it does happen... If there is anything you would like me to test on our site, please let me know.
On another note, I would like to point out your extraordinary support. Receiving a private build so quickly has really impressed me and my team! Keep up the good work!
Daniel / comments
Hi Peter
Charles' first reply to me shows clearly how this happens and I can second the fact that it does happen... If there is anything you would like me to test on our site, please let me know.
O...
Hey there cklaw,
Until we hear back from RedGate, we've written an SP which we run after compares. It basically goes through all our tables and reseeds them. I've attahced it below.
Have a good one!
D CREATE PROCEDURE [dbo].[usp_sys_mnt_ReseedAllTables]
AS
BEGIN
DECLARE @table NVARCHAR(4000), @column NVARCHAR(4000)
DECLARE row CURSOR FOR
SELECT a.name AS TableName,
b.name AS IdentityColumn
FROM sysobjects a
INNER JOIN syscolumns b
ON a.id = b.id
WHERE COLUMNPROPERTY(a.id, b.name, 'isIdentity') = 1
AND OBJECTPROPERTY(a.id, 'isTable') = 1
AND a.xtype='U'
AND a.category=0
ORDER BY a.name
OPEN row
WHILE 1=1
BEGIN
FETCH NEXT FROM row INTO @table, @column
IF @@FETCH_STATUS = -1
BREAK
PRINT @table
EXEC sp_executesql N'DBCC CHECKIDENT (@table, RESEED)', N'@table varchar(4000)', @table = @table
PRINT ''
END
CLOSE row
DEALLOCATE row
END
/ comments
Hey there cklaw,
Until we hear back from RedGate, we've written an SP which we run after compares. It basically goes through all our tables and reseeds them. I've attahced it below.
Have a good one...
DBCC CHECKIDENT post Sync
I am not sure this is a bug though it seems like one to me.
After syncing data for a table which has an identity column, SQL Compare will NOT run DBCC CHECKIDENT (RESEED) so that the next insert on...
Wow! That was a fast reply. And you want to know my preference?! I'm (as usual) very impressed.
I prefer double-click executes the comparison. I think that 99.9% of the time you want to run the comparison and double click is a lot faster then click project then click button.
Thanks again!
Daniel. / comments
Wow! That was a fast reply. And you want to know my preference?! I'm (as usual) very impressed.
I prefer double-click executes the comparison. I think that 99.9% of the time you want to run the com...
Double-click project
Hi,
A little niggle: When you double-click a project in sql compare you get the project settings. In data compare, when you double-click it performs the comparison.
I use both tools often and it ge...
Fonts
Hi,
Compare 8 is a great update to SQL Compare. I do have one question: is there anyway to change the font on the dif window? My eyes work better with fixed-width fonts...
Can this be changed?
Danbo