luni, 15 noiembrie 2010

restart id column

select max(EAT_ID)+1 from EPTOS.ENTITYASSIGNEDTHREADS;

alter table EPTOS.ENTITYASSIGNEDTHREADS alter column EAT_ID restart with 429163;

vineri, 22 ianuarie 2010

In order to access a different computer and if it doesn't work from TotalCmd or Remote Desktop, you have to follow these steps:

A
1. Go into My Computer
2. In Tools - > click Map network drive
3. In the dialog box appeared insert:
path to computer: \\fileserver\kit2
4. Click Connect using different user name and enter user and pass

B
Next time you want to log on to the computer, if the connection cannot be establish
1. In My Computer - right click -> Disconnect
2. use the same steps (A 1-4)

miercuri, 13 ianuarie 2010

My Wiki 1

Update DB

When I update project from CVS:
1. Check changelog.txt in order to see if DB schema has been updated.
2. If DB schema has been updated see which is the last update made.
3. In DbVis, go to the respective DB, into databasedescription table and see schemarevision field. Sort field descending.
4. In projects, search for the update doc and copy content of the doc
5. In DBvis, paste it into SQL Commander and click button Execute as SQL script.

Steps 4 and 5 repeat as long as necessary until the DB will be updated.