Something along these lines

use tempdb

create table comp

(

 c1 int not null

 , c2 int not null

 constraint pkcomp primary key(c1,c2)

)

insert into comp values(1,1)

alter table comp

 drop constraint pkcomp

go

alter table comp

 add c3 int null

go

update comp...

I would do this in some front end scripting language. That's much easier.

No, I just thought that it might be AS related, because I am not aware of CREATE ALIAS in T-SQL.

Farrell, you did nothing wrong. That's exactly what I meant with little annoaynce. Not that one should specify JOINs hints as normal way of doing business, but when you specify...

Aah, I see. I thought that it might be Analysis Services related, but then I saw you've posted it in the T-SQL section.

Sorry, i have no experience with RS...

"Should you install SP4 on your production servers that use AWE?"

Do you intend to use AWE after installing SP4 or not?

CREATE ALIAS in SQL Server?

Farrell,

AJ already mentioned that INNER JOIN is the default JOIN type. Try this

USE PUBS

SELECT

 r.royalty

 , t.title

 , t.type

 , t.price

FROM

 roysched r

INNER JOIN

 titles t

ON

 r.title_id = t.title_id

ORDER BY

 r.royalty

SELECT

 r.royalty

 , t.title

 , t.type

 , t.price

FROM

 roysched r

JOIN

 titles t

ON

 r.title_id =...

Ken Henderson's books are probably the one's I've learned the most from. And, yes, I confess, I really, really like "SQL for Smarties" by Joe Celko.

See if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

Can you post it here?

See if this helps: http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

Run Profiler to see what going on there.

http://www.orafaq.com might be a start. At least they have an active mailing list, that helped me getting started.

Good luck!

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true