When the table is a heap, I think the order is quite random. When the table has a clustered index, I believe this to be in order of the clustered index....

I wouldnt' shrink the log just because of the shrinking. When you shrink the log, it will sooner or later need to grow again. This process is relative expensive and...

What is the exact error message you get?

I've seen such problems before. Mostly they could be solved by deleting the file SQL Server Enterprise Manager in the directory Documents and...

Something like this works just fine for me:

create table #t

(

 col1 varchar(123)

 , col2 varchar(123)

 , col3 varchar(123)

)

insert into #t (col2, col3) select '12.49', '2.51'

update #t set col1 = convert(varchar(123), convert(decimal(10,2),col2)+convert(varchar(123),col3))

select * from...

Well, just like the name says, an "After Insert" trigger fires after the Insert has taken place. So in your case, the trigger doesn't fire at all, because the PRIMARY...

In addition to Adam, you write, you've tried via EM. Have you yet tried it via Query Analyzer with an ALTER TABLE...DROP COLUMN statement?

Not sure if I understand correct, but why don't you use a query with an ORDER BY according to your columns?

hehe, before you get bored:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/indexedviews1.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Okay, let's start with some reading material.

First rule of thumb: Read BOL

Second: If you can get hand on "Inside SQL Server 2000", read...

One might find Joe Celko's books are good brainteasers, however there seems to be very little VB in them

What about having a look...

Yes, your best bet is to post it to newsgroups like

microsoft.public.access.* or

comp.databases.ms-access

See if this helps:

http://www.karaszi.com/sqlserver/info_generate_script.asp

If I understand right, have a look at this:

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/dynamic_sql.html

By any chance, see if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;842193

http://support.microsoft.com/default.aspx?scid=kb;EN-US;828396

http://support.microsoft.com/default.aspx?scid=kb;EN-US;820761

http://support.microsoft.com/default.aspx?scid=kb;EN-US;326842

If not (and you can afford it), I would follow Wesley's suggestion and reinstall the box, before you waste too...

http://www.microsoft.com/typography/ctfonts/WordRecognition.aspx