Good one. Always thought insert with insert into..but never thought default values could be used to insert identity value for an identity column.

My job also runs every 10 minutes and never had issues. It generally takes less than a second to complete. Command in job is -

EXEC dbo.sp_MSdistribution_cleanup @min_distretention...

Check for Distribution clean up: distribution job in scheduled jobs and run it.

Buxton69 (7/1/2008)

---

In the schedule tab choose to run monthly and then select for example 'on the 1st day of every 12 months'

You can then set it to run from which...

You can run SQL profiler for detailed report or run sp_who2 or dbcc inputbuffer(spid) for...

I tested it more than 10 times and it never returned 10% back approx. It...

Thanks John and Ken for these scripts. Both are good and are worth keeping it handy.

WOW.......Jul 21, 2008 question on June 18,2008.

Thanks.

Good question but bad wording. I said yes and lost a point. After insert no matter how many times you execute these select statements you get same result.

--select...

I wondered who could have replied MySQL.

Resource...

Not possible.

Try this.

ALTER TABLE tablename

ALTER COLUMN columnname COLLATE default

WHERE SalariedFlag = 'true' for bit would not work in 2000 but since it says use Adventureworks, it clear that the question is for SQL 2005.