It could work, but IMHO, it's a bad move. At least to move everything. You could move some stuff, but I'd like someone nearby I could call in a pinch....

jgrubb,

nice synopsis and I think you've hit it. It works well in places, just be aware of what you're getting (and missing).

There are definitely people posting interview or homework questions. Please feel free to call them on it if you don't want to answer.

And participate where you can. Don't feel bad...

Sorry for the late note.

Seeing the paper result, but not holding it is interesting. And it's a good compromise, perhaps the best we'll ever get.

I read in one place that...

Gail has it correct. It will use more space, because it rebuilds things, but MDF files will grow only if you run out of space inside the current MDF files...

I'd agree with Michael. Go through the maintenance plan wizard for a start.

It comes and goes in waves. Plenty of new people being thrown into SQL Server every day, struggling to learn.

Most people aren't like those of you that answer questions. They're...

I doubt I'm more biased than anyone else that doesn't work for a vendor of a platform, or doesn't belive in Open Source.

I've made my living off SQL Server, but...

I've tried two things. One, give each developer their own schema on a central server and then "change object owner" when things move to the point where we want them...

Marios,

What are you trying to do? They usually perform separate actions, but if you are looking to just update another server, I might recommend looking at Service Broker.

Typically there's a utility with the hardware vendor that can check this, but it's an OS level task, not something you can see from SQL.

As mentioned, contact your Windows admin.

Not likely to hit Phoenix, but Vegas would work. Orlando, Dallas are other locations they've used.

This help?

http://www.sqlservercentral.com/scripts/SQL+2000/Permissions/

This is almost always hardware. Freezing like this could be bad hardware, strange drivers, anything like that.

If you have rights in the database, you should be able to browse the objects.

You don't necessarily get these rights all the time. Someone could have removed rights to all...