I second Jim's note. While each table moves, it will be locked by the server and unavailable unless you can rebuild online.

The nice thing is you can script this and...

Jack Corbett (7/18/2010)

---

Glad to see that Steve is running for the PASS board of directors. I don't think that there are any better candidates out there, especially ones that...

xp_cmdshell and T-SQL backup commands have nothing to do with one another.

T-SQL commands are run inside SQL Server, and you should be able to run them in single user mode.

Xp_cmdshell...

If I understand what you are saying, you are looking for an audit trail of what has heppened in your database? There is no log per se. There is a...

I don't think that Enterprise should run on Win 7. This doesn't list Win7 for Enterprise (which is what eval is based on, if I remember correctly)

http://msdn.microsoft.com/en-us/library/ms143506%28v=SQL.100%29.aspx#EEIA64

Developer is typically what...

I am sure they have done some work here, but I wonder if they've done any recently. The work Peter Spiro did on 7, rewriting all kinds of stuff has...

I'm rubber and you all are glue....

I like Gail's idea. Attach back to two servers, remove the filegroups from each that you don't like.

Interesting points, Paul.

One thing does come to mind. Has MS really done enough research on alternatives? The read-ahead mechanism seems designed to pre-fetch data and prevent further interrupts of the...

Paul White NZ (7/16/2010)

---

Tom.Thomson (7/16/2010)

---

...But a claim that any form of try-catch construct that alters the behaviour under some error conditions of code executed in the context of the try...

The first time you ran through this, it usually asks you to create a table. It does that, but to repeat it, you'd need that table in the sheet or...

I believe Gail is correct. The CTPs usually expire after a year of release. So I wouldn't expect the last CTP to be installable.

SQL 2008 Evaluation or SQL 2008 R2...

I tend to agree with what's listed above, but I'd be careful about not allowing reuse and using things like phone or email as PK values.

I have had re-used emails,...

I was quite a sight...

Kit G (7/16/2010)

---

Grant Fritchey (7/16/2010)

---

To know for sure you'd need to consult a lawyer. But since it's a non-exclusive license, I'm pretty sure that means you retain copyright. Just make...