This happened twice to me. Don't know why, but somehow this *.msc file became corrupted. Jim's method is probably the quickest one to get back on track.

Not that I know much about DTS, but I once tried this and it is really simple with DTS. If you need this on a regular basis like daily, schedule...

This also is likely to happen when you have complex calculations to do. I have seen mainframe listing using log() and ln() stuff just to work around this impreciseness.

Fortunately...

truncating the table has the same effect

set nocount on

if object_id('idt') is not null

drop table idt

go

create table idt(

col1 int identity(1,1) primary key )

go

insert into idt default values

select * from idt

truncate table...

set nocount on

if object_id('test_q') is not null

drop table test_q

go

create table test_q(

m char(3),

b char(3),

l char(3)

)

insert into test_q (m,b,l) values('10','10','1')

insert into test_q (m,b,l) values('10','10','2')

insert into test_q (m,b,l) values('10A','10','2')

insert into test_q...

select * from test_q order by left(m,2),b,l

results in

m    b           l          

---- ----------- -----------

10   10          1

10   10          2

10A  10          2

10   10          3

(4 row(s) affected)

One way would be

if object_id('test_q') is not null

drop table test_q

go

create table test_q(

m char(3),

b int,

l int

)

insert into test_q (m,b,l) values('10',10,1)

insert into test_q (m,b,l) values('10',10,2)

insert into test_q (m,b,l) values('10A',10,2)

insert into test_q...

Andy, just made the experience that copy and paste of a username does NOT work in Mozilla like in IE. Mozilla pastes as plain text while IE keep the hyperlink...

Just call him noeld

Might be another reason to stay away from EM

As for me, it's completely okay without them

Thanks for the info.

SQL 2k improved greatly on caching dynamic statement. So no suprise with SQL 7 being less efficient.

Once again Notepad

QA code formatting is lost when copying.

Maybe we should opt for Word as editor

Did you create it in the master db?

I don't know of a *general* setting for this. Are you sure you always check this option when generating a script?