I have corrected the scores for people that answered syntax error. It's hard to QA all these questions and in this case,  I missed the single quote.

I know that many...

You could use a trigger to force it.

create trigger mytrig on Mytable for insert, update as

update mytable

 set myfield = upper(myfield)

 from inserted i

 where i.pk = mytable.pk

Assuming you know the PK and the fields

select a.code 'Code_a', b.code 'code_b', a.amount 'amount_a', b.amount 'amount_b'

 from MyTable a, MyTable b

 where a.code = 'a' and b.code = 'b'

If you want it...

It appears that you had some type of corruption in the SQL tables at the physical level. If chkdsk worked, then bcp out/bcp in , transfer to new db, etc,...

Part of the problem is the execution plans are based on the load on the server. Since I've managed people with both Oracle, DB2, and SQL Server, the SQL installations...

Did you assign the min and max to 5120?

Check sp_configure.

It should be all changes that were not committed. Does this not seem to be the case?

I don't usually recommend this, but I'd use a cursor for this. Assuming that recno is an actual field in your table, use that and run a loop. Actually you don't...

There are some things in SQL Server that are extremely intolerant of delays. Backups is one and tempdb may be another. Since it is used at a low level by...

Never tried it and I don't see the option in XP. I'll see if I can dig something up.

Good question. I'm not sure. I need to dig into the forum code a bit and see. It's from the InstantForum.com guys, so they'd need to support it.

You can use the GUI or ALTER DATABASE command to set the initial size higher.

Can't do it retroactively. You have to setup a process to check the space once a day or so and store it somewhere. I used to do this for backups...

It's been suggested and it's on our list. I agree with you, just a few things that are broken first. We'll get to it.

You should use IP or setup a local DNS to connect. Using the servername won't work across most VPNs. Only FQDNs.