- Joined
- Oct 16, 2008
- Messages
- 2,639
- Reaction score
- 945
[Guide] How to get the Items ID list
- Open SQL Server Management Studio
- Login with sa
- Expand DR2_def
- Expand Tables
- Right click on "TB_DefItem"
- click Edit All Rows
- ItemNo = ID of the item
FAQ:
Q: I don't see the "Edit All rows option, what should i do?"
A: Easy, click "Tools>Options" Click in SQL Server Object Explorer and than in the "Table and View Options" change the value 200 to 0