Move Up/Move Down?
Does anyone know how to implement a Move Up/Move Down capability in a datagrd? I believe the question would boil down to these questions:1. How do you allow the user to select a row in a datagrid?2. How do you identify that row in code?3. How do you swap the position of two rows (in the underlying datasource)?Thanks!
Try this link
http://msdn.microsoft.com/msdnmag/issues/05/03/CuttingEdge/default.aspxIt night helpGood luckGraeme
Thanks. I'll check it out and let you know......moving tempdb off the master device
Can there be any problem if I move the tempdb off the master device?
This is discussed in the Sybase FAQ:
Shawn Enderlin, DBA
Deniz Ata wrote:
> Can there be any problem if I move the tempdb off the master device?
> Deniz ATA
Take a risk.
Remove the whole thing from the master device.
I've used this script for years now, and it has never failed me. I...move tempdb off master device
I need to move tempdb off the master devices. What is the appropriate
step to accomplish this? Any issues with this?
check out this link, which i will guide you
> Hi all,
> I need to move tempdb off the master devices. What is the appropriate
> step to accomplish this? Any issues with this?
Why do you think you need to do this? Sybase tech support recommends
at least the original fragment on the master device; comp...move tempdb off of master device
What are the segment commands to drop tempdb from the master
device? I remember doing this in class but can't find it in
the online docs. I have assigned filespace to tempdb and
would like to move tempdb off the master device.
It's best to leave the small fragment of master device allocated to the tempdb database, though there's typically
nothing wrong with disabling future space allocations to the master device fragment. In this case you could use
sp_dropsegment to drop all 3 segments (default, system, logsegment) from the master device fragment....Move up/Move down buttons?
Hi,I'm trying to implement move up and move down buttons for a datagrid. The idea is that the user selects a row of the datagrid, then presses either the move up or the move down button to move the row up or down 1 row in the grid. If anyone has any ideas about how to implement such a feature, I would be grateful to hear about it.thanks.
Though I haven't tried this, it should work. Bind the datagrid to a datatable. When the user wants to move the selected row, create a new row at the desired place and then delete the old row from the datatable and rebind the datagrid. Che...Tempdb moved of master device
Extended tempdb onto a new device and removed the original 2mb of tempdb
that was on the master device.
Unfortunately new device I extended tempbdb onto is corrupt and server
won't recover since no tempdb.
I need to move tempdb back onto master device.
How do you do this ?
If you are able to create a new database then do the following.
0. sp_configure "allow update",1
1. create a new database new_tempdb ( 2MB ) to a new device.
2. select name,dbid from sysdatabases where name = "new_tempdb"
Say this is = 10
3. delete ...moving tempdb from the master device
Can there be any problem if I move the tempdb of the master device?
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
Deniz Ata wrote:
> Can there be any problem if I move the tempdb of the master device?
> Deniz ATA
It can make recovery a real pain. I recommend leaving it on the
master device (it's only 2mb) and altering it on to another device.
Preferrably a filesystem for better performance...Avoid moving tempdb off the master device?
Reading page 310 of the "Adminstrator's Guide to Sybase ASE 12.5" by
WordWare Publishing, it says that one should "avoid moving tempdb off
the master device" ... and continues... "Once tempdb is moved off the
master device, it is difficult and time-consuming to recover if a
problem occurs on the master device or the device to which tempdb is moved."
.... and yet on page 34 - 35 of the same book, it shows an example of
creating a device on /tmp. Granted that this is only an example, but the
idea of the author there was to use swap for ...How to move tempdb from master dat device
Can any body explain me how to seperate tempdb placement
Output of sp_helpdb tempdb as follows:
name db_size owner
dbid created status
------------------------ ------ --------------
tempdb 1002.0 MB sa
2 Mar 01, 2004 select into/bulkcopy/pllsort,
trunc log on chkpt
(0 rows affected)
name ...Moving tempdb from master dev to new dev
How can I do this move....???
Zul Azmi Ahmad wrote:
> Rabindranath Raj wrote:
> > How can I do this move....???
> > Thanks
Are you having trouble with the posting of notes?
On Mon, 13 Apr 1998 12:31:04 +0800,
Rabindranath Raj <firstname.lastname@example.org> wrote:
>Zul Azmi Ahmad wrote:
>> Rabindranath Raj wrote:
>> > How can I do this move....???
>> > Thanks
Rabindranath Raj wrote:
Is there any simple method, without re-install, to move tempdb from physical
disk device to memory devices?
Thanks in advance.
PD: ASE 188.8.131.52 for SCO UnixWare 7.
1) Delete entries from the sysusages for tempdb devices (other than
2) Create tempfs..
3) Disk init and alter tempdb again..
Remember to bounce the server between steps 1 and 2.
Step 1 is actually documented in more detail in the Troubleshooting guide -
Chapter 2 Encyclopedia of tasks, Other Useful Tasks, How to Reduce the Size
Can anyone help me?
I wrote to this forum last week and received a mixed reaction to my
'dilema'. I would appreciate more thoughts as I still think I should
seperate my tempdb from the master device. I know Sybase recommend not
doing this but the reason they give is for recovery, and as far as I see
it, if master is corrupt and I have to rebuild it, then I'll have to
re-create my databases anyway, unless I can restore from a clean backup.
Either way, master would be back to it's original state at some point in
the recovery period. (am I making sense, hope I'...Move my Master?
I have a mix of nw 6 and 5.1 servers. I'm upgrading all the servers to
eDirectory 8.7.3. I want move the Master of Root to a new server I'll be
building. How do I do this?
> I have a mix of nw 6 and 5.1 servers. I'm upgrading all the servers to
> eDirectory 8.7.3. I want move the Master of Root to a new server I'll be
> building. How do I do this?
The easiest way is to put a replica of [Root] on the new server, wait
for DS to complete the operation, and then change the replica type to
Once t...Moving tempdb
I need to remove tempdb from its current location, and reinstall using
less devices. Right now it is splattered over master, and two other
devices. I just wanted to make sure that I was not going to do any
permanent damage if I did it the following way:
1) backup master
delete sysusages where dbid=2
delete sysdatabases where dbid=2
create database tempdb on master=2,
Alan Chase wrote:
> I need to remove tempdb from its current location, and reinstall using
> less devices. Right now it is splattered ov...