Any Idea to do it ?

[Kira]

when i add new code in any table
the code place in first rows
i need this code be in last page
sorry about my English

Exp

[MentaL]

[IMOS]

I'm not 100% on this but this may be happening because there may be existing duplicate values on that column. SQL Server Management gets confused and then just throws up new stuff at the top, either this or nothing wrong with it being placed at the top.

You can run a query to see if there are any values that are repeated:

--Finds duplicate data in a certain table row.
--imos
 
USE [SRO_VT_SHARD]
GO
SELECT ID, COUNT(ID) AS NumOccurrences
FROM _RefObjCommon --table name
GROUP BY ID
HAVING ( COUNT(ID) > 1 )

or if you want to arrange them from least to greatest or A-Z:

--imos: will sort any column from values 0-999.. or a-z
--ASC for numbers DESC for letters
USE SRO_VT_SHARD
GO
SELECT *
FROM _RefObjCommon --table name
ORDER BY ID ASC --column name and sort type

Hope it helps.

[Kira]

thx bro for try help me :)
i will try to find any thing to do it from option

[Statiic]

_RefObjCommon > Design > right click ID Column Set a primary key > Column Properties > Indetity Spercification > (Is Indetity) set "Yes" done. same with others tables like _RefObjChar And _RefObjItem

when u use a db created in mssql 2008 r2 and the owner convert to sql 2005 primary key and indexes is removed automatic

[Kira]

i use 2008 r2 bro but i will try this way

Edit: Ur way work fine with me on SQLServer 2008 R2
Ty My Teacher

[arabianfox]

_RefObjCommon > Design > right click ID Column Set a primary key > Column Properties > Indetity Spercification > (Is Indetity) set "Yes" done. same with others tables like _RefObjChar And _RefObjItem

when u use a db created in mssql 2008 r2 and the owner convert to sql 2005 primary key and indexes is removed automatic

Then ?!!!

[Kira]

Then ?!!!

Save and close ur table and open it again
and will work with u
don't forget to give Like to my Teacher Statiic

[arabianfox]

Save what?? "save text file" ?!

didn't work here with me

[Kira]

Save the change on table first
and wait statiic he will answer
maybe i am wrong
but it work with me one SqlServer 2008 R2

[Statiic]

Then ?!!!

go Tools > Options... > Designers > and Clean "Prevent saving changes that require table re-creation" done! ^^

[arabianfox]

now i must "like" and say thanks,works great here.

[Kira]

now i must "like" and say thanks,works great here.

i told you he will answer
luv my teacher

[arabianfox]

many thanks Statiic and another question is this method also for tables (Refpackageitem - Refscrapofpackageitem)

Coz they has the same problem at ID and index columns

and many thanks for your help..

[RevoLand]

i late to reply?

----
i get a new idea from this thread, we know how to make auto increement the column or whatever
so if we try it in RefObjCommon or like this tables to dont get error while adding avatars & etc can we success?

[Statiic]

many thanks Statiic and another question is this method also for tables (Refpackageitem - Refscrapofpackageitem)

Coz they has the same problem at ID and index columns

and many thanks for your help..

yes but Refscrapofpackageitem do this process in the last column "[Index]"