Comments
Sort by recent activity
Well, 11 monthes passed since i reported this problem. It's not fixed. Can you let us know if you ever have plans to fix it?
Fix is as hard as adding SET IDENTITY_INSERT ON statement to generated script.. It's very frustrating that it makes such a big problem for RedGate to fix. / comments
Well, 11 monthes passed since i reported this problem. It's not fixed. Can you let us know if you ever have plans to fix it?
Fix is as hard as adding SET IDENTITY_INSERT ON statement to generated ...
Hello Anu.
Here's sample script which creates table: CREATE TABLE Test
(
TestId INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
Name NVARCHAR(MAX) NOT NULL
)
GO
INSERT INTO Test(Name) VALUES ('Name1')
GO
INSERT INTO Test(Name) VALUES ('Name2')
GO
INSERT INTO Test(Name) VALUES ('Name2')
GO
INSERT INTO Test(Name) VALUES ('Name4')
GO
DELETE FROM Test WHERE TestId = 1
GO
DELETE FROM Test WHERE TestId = 3
GO
SELECT * FROM Test
GO
After running this, you have two rows in table "Test":
TestId Name
2 Name2
4 Name4
Now, right-click TestId column in SMSS's Object Explorer and "Smart Rename..." it to "Id". After script ran, try selecting from "Test". What you get is:
Id Name
1 Name2
2 Name4
As you can see, values of identity column just renamed are screwed.
Regards,
Dmitry Gokun / comments
Hello Anu.
Here's sample script which creates table:CREATE TABLE Test
(
TestId INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
Name NVARCHAR(MAX) NOT NULL
)
GO
INSERT ...
Hello Eddie,
thanks for picking up this ..
Regards,
Dmitry / comments
Hello Eddie,
thanks for picking up this ..
Regards,
Dmitry