I did try unchecking List databases when listing everything, but

that did not work.  

I just installed PromptSQL and I'm getting mixed results.

When I 'space' after a verb like from or join, I get a list of databases instead of tables or procedures.

What am I missing here???

I don't see that these techniques as good a simple backup and restore which has no downtime?

Where is the evidence that they are any faster?

I would like to suggest that the article should have included you basic backup and restore as your first choice for moving databases.

There is no down time on your source...

I just installed the April CTP of SQL 2005, but it still has the same problem.  Enterprise Manager 2000 errors out with a "mmc.exe - Application Error" when you right click on...

You are not alone. It happened to me, too.

I just installed the new SQL 2005 CTP on a Virtual Machine, but I would like to install SQL 2005 it along...

I am surprised and dissapointed that Table Partitioning is not in the Standard Edition.  I wonder if there is any chance that Microsoft might reconsider that one? 

I want to express the opinion that the best way, by far, to backup and restore master is to copy the master.mdf and maslog.ldf files.  Either buy a product that will...

DTSbackup 2000 will do what you want and a lot more. We have been using it to move lots of packages around to different machines. There is nothing that I...

Increase your log to a couple gigs.

Change your recovery mode to simple.

Shrink the file in chunks, as shown before.

If you can create a test database, you can try your shrinks and cancel them if they take more than an hour or two.

Try a truncate only first,...

How often you run maintenance on the table may be more improtant than whether the index is clustered or non clustered.

Run DBCC SHOWCONTIG  and if the table is less that 80% contigious,...

My DBIDs are not the same. This is no problem. I have been doing it for years.

I don't know what problems you may run into with DBIDs that are in...

I restore databases from a production server to test and development servers a couple times a week and have nerver had a problem with DBIDs.

The managment of DTS packages to various servers and to structured files can be done by going to sqldts.com and downloading the DTS2000Backup program.

It does it all, and it's free,...