Typically not. But you will need to explain what you mean here. Disabling the local security policy could leave your...

Please post table scripts, index definitions, and sample data. Also, please provide a sample of the output you are seeing, and the desired output.

Thanks. That is what I thought.

Jeff Moden (1/16/2010)

---

Heh... maybe I should turn it into an article... the question does come up often enough. That's how my very first article was born... the one on...

GilaMonster (1/16/2010)

---

3) The only indexes that can be created against table variables are primary key and unique constraints (and even then, people don't usually bother)

It's not a problem with 10...

Thanks Gail for finishing this one up and explaining in great detail.

GilaMonster (1/16/2010)

---

Will be lost.

If the minimum level to repair is repair_allow_data_loss,...

crainlee2 (1/15/2010)

---

Thanks for your reply, Jason.

And thanks for your indisputable reply, Gail. It will end all debate on the subject. In answer to your "Why?" question, it's because this particular...

You're welcome

Jeff Moden (1/15/2010)

---

CirquedeSQLeil (1/15/2010)

---

This article may be of use. That, and this article[/url]. Gail delves into comparing the differences of an inner join v. in and in v....

This article may be of use. That, and this article[/url]. Gail delves into comparing the differences of an inner join v. in and in v. exists. Though...

Go for the combination. A nightly sp_updatestats followed up by a weekly or monthly fullscan.

Is the Browser service running?

Can you connect to it by IpAddress/Port?

Any additional error info from the Application Event log?

Peter, Nice article.

Winston,

Try doing it as Jeff has just explained. Create multiple procs, from one of which you will call the other. I think that will probably satisfy the issue...