Microsoft can't be bothered to fix it...

I just got one too!

Gordon-265412 (3/26/2008)

---

rbarryyoung (3/24/2008)

You had it right about it parsing before-hand. SQL 2005 parser is just a little bit more tolerant of schema changes mid-batch than SQL 2000 is. ...

Paul Randal (8/14/2009)

---

Ok - this has now been proven to be a bug inside MS, with a simple repro. Alex - let me know if you want to push for...

Paul Randal (8/14/2009)

---

Ok - this has now been proven to be a bug inside MS, with a simple repro. Alex - let me know if you want to push for...

Gail, thanks for...

Paul Randal (8/14/2009)

---

ok - in that case if it only happens under load with concurrent executions of the SP, then I'd say it's definitely a bug. The index rebuild code...

Thanks for you help with this!

CHECKDB on model, tempdb and my db all return no errors.

> put a 'GO' between the DBCC DBREINDEX and the insert so they're not in...

Thanks for your reply.

I've already stopped and started the server, then tried again, and it's made no difference.

The command:

DBCC CHECKDB (model ) WITH NO_INFOMSGS, ALL_ERRORMSGS

just produces:

Command(s) completed successfully.

I'm...

Brilliant - that's it. (I actually tried that without the quotes).

Thanks!

> I am not fond of cursors and advocate doing anything possible to replace the cursor

What do you gain by handling the looping yourself rather than just using a cursor?...

Jeffrey Williams (10/27/2008)

---

alex (10/27/2008)

---

Garadin (10/9/2008)

---

I was super excited about it, and while it may just be that I'm so used to coding without it that I can't appreciate it yet,...

Garadin (10/9/2008)

---

I was super excited about it, and while it may just be that I'm so used to coding without it that I can't appreciate it yet, so far it...

Thanks.

Ian Scarlett (9/17/2008)

---

Unless you use an ORDER BY, the sequence is not guaranteed.

SQL Server will choose what index to use based on the actual query.

If you were to add a...