You can do the alter through EM, then hit the script button and get the script. Then don't save your changes and you'll have the script.

Knowing what is inaccurate and what is accurate is critical. IF you look at the results, can you tell which section of the code is not working?

Follow ninja's advice above.

I stand corrected. Finish time looks to be the correct time.

First, I'll say that I've always been a good employee (from the employer's point of view) and usually they want me to stay, so I'm fairly up front when I...

Marc,

My understanding is the backup is valid when you start it. The reason is that as pages are grabbed through the backup process, they are marked as a part of...

Can't speak for SQL Server, but when we had backups on DB/2 and Oracle, they did do a copy/split of the disks on the SAN and there was a brief...

Very interesting and thanks for sharing.

And I'll see about writing the letter. Easier for me to say it than do it, though I've composed a few in my head. If...

Jeff,

Thanks, and I didn't check that page. You can send a note to MS from that page, which lets them know of an inaccuracy. Since I've written lots of junk...

Fill a QOD slot?

Not sure myself, but probably better programmers that I have some use for it. Or maybe it's just the math PhD in Redmond wanted to get the...

I'd have thought AWE would be needed for this. Did you set AWE on in SQL Server?

Did you change the account usinig Enterprise Manager/Config manager? If not, you could be missing permissions.

Thanks for the update

I think you have things a little out of order.

I'm not sure you need to disconnect from the domain, but wouldn't you create all the partitions and copy the files,...

You can set the default file to be the NDF in the database properties. Then you can move the tables that experience growth to the new file by recreating their...

Very nice. Hope you had good boots for the outing.

We've got a blizzard in Denver today. Stuck in the house all day, horses locked up because of the 30+mph winds...