I'd say 80 to 90 percent of ours still use SQL Server 2000. We have just one using SQL Server 2008.

I had the same problem, different counts from sp_spaceused versus select count(*)

So I tried sp_spaceused with @updateusage = 'True', and I also ran DBCC UPDATEUSAGE for the table.

And the...

I ran count(*), and sp_spaceused on a table, got 9997796 with count(*) and 9997764 with sp_spaceused. I told it @updateusage = 'True'.

My first thought is 'corrupt table'. Comments...

That's a nice thought but not necessary - I just got 2 points credit on a different question - using totally false reasoning - so we're more than even !!

Thanks

I chose #1, or maybe #2, but either one is correct, and it told me I was wrong. I know the test developer couldn't have made a mistake so...

Does it mention anywhere that it doesn't work on SQL Server 2000 ? Does on 2005.

I'm confused. I get the same results from 'select * from duh' for both settings of ANSI_PADDING.

set ANSI_PADDING off

go

create table duh (

col1 varchar(50)

)

insert into duh select 'a '...

This didn't work for me initially. It duplicated a column four times. I had to modify the code as below:

Original line:

WHERE O1.Name = @Target_Table)...

I am going by how long the procedure or function takes to run, with resources available to the server being basically the same for the 'derived table' run and the...

Derived tables are cool as far as being able to write elegant code and reduce the quantity of code. I started using them for these reasons.

...