What figure does sp_spaceused show as database_size in the first result set?

The second result set only shows what space has been allocated to objects in the database (data, indexes). ...

It's a pain isn't it!

Telephone interview just to find out your personality, but you are rejected because your answers were too brief! How does that reflect your personality?

Obviously you...

duplicate post here

please don't cross post

It would be much better if you could provide some sample data and expected results.

No problems - glad we got there in the end!

I did wonder when you said 'no, we don't have any trigger' whether that meant ' I haven't added any triggers'...

in the database where you get the message, can you run these and post the results

select * from sys.server_triggers

select * from sys.triggers

You don't have a 'GO' somewhere in the proc do you?

Could you post the code that you are using to create/alter?

OK.

From that data we can see that the Headcount for 200901 (which I guess means January 2009) is 18315 - what do you expect the 'monthly average' for that to...

have you got a DDL trigger on CREATE/ALTER?

Good...

what does your underlying data look like?

Can you post some sample data - I guess the Period is a date?

the error simply is complaining that the positioned update failed to update a row

However I'm sure this cursor can be better written - can you post table definition for table...

Not using an ALTER statement no.

Simplest way is to make a copy of the table with the identity seeded at 5, copy the data into it (using IDENTITY_INSERT ON), drop...

Why can't you use ORDER BY?

try this

declare @items1 table (item varchar(100))

declare @items2 table (item varchar(100))

insert into @items1

select 'Cost Evaluation Sheet'

union select 'Decision Gate...

If there is a firewall between you and the server then now is definitely the time to check if that is your issue.

Not surprised the ping didn't work - that's...