Any Idea to do it ?

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
http://forum.ragezone.com/attachment...1&d=1334704151
Exp

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:

Code:

---

--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:

Code:

---

--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.

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

_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

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 :D:

Quote:

---

Originally Posted by 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

---

http://img9.imageshack.us/img9/2510/12203979.png

Then ?!!!

Quote:

---

Originally Posted by arabianfox

http://img9.imageshack.us/img9/2510/12203979.png

Then ?!!!

---

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

Save what?? "save text file" ?!

didn't work here with me

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

Quote:

---

Originally Posted by arabianfox

http://img9.imageshack.us/img9/2510/12203979.png

Then ?!!!

---

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

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

Quote:

---

Originally Posted by arabianfox

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

---

i told you he will answer :ott1:
luv my teacher :thumbup:

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..

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?

Quote:

---

Originally Posted by 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..

---

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