I want to move my tempdb database from master deivce. If u can please let me know how to do step-by-step.Also how can i move make a new segment of particular database as the default so that whenever any new table is created it is created on that segment not to the default because here i do'nt want to give a segment name in create table syntax.
Never remove the 2MB fragment of tempdb from the master device. Just disable it. This will make recovery easy.
1. Update sysusages set segmap = 0 where dbid=2 and lstart = 0
2. Use sp_dropsegment to remove all active segment on this part of tempdb (system, default and syslog)