I was sure there had to be a way to do this.

Thanks!

Thanks so much for you help, George. I really appreciate it along with what I've learned from this experience.

We're pretty fexible here, so if I ask him to cancel...

The last_wait _type = LCK_M_U

I noticed when running sp_who2 that there was a value in [BlkBy], which I assume means "blocked by" - I also assumed that the value referred...

@George:

I've run this script in SSMS multiple times and it just runs and runs. I left it for over an hour and decided to cancel the query.

Point taken...

Perhaps a stupid question, but...is it possible that index fragmentation could have an impact on running the backup? The main table in this database has

avg_fragmentation_in_percent = 98.84678748

fragment_count =...

FYI - I have found a solution for this through some online digging...I'm not sure what kind of side effects it may have(?).

I restarted the integration services to Logon as...

Just an update: I purchased the 2008 Dev version and should have it delivered tomorrow. With S&H it came to just over $100. A little more than...

Jeff, thanks for your reply. I had believed and hoped that was the case. Thanks for eliminating that concern for me. 🙂

Cheers.

I don't see the options "Import Data" or "Export Data" under the expression version of Management Studio either.

Should we be seeing that in Express?

Sorry, I should add that I was able to create the catalog "mycatalog"....its creating the index that I had a problem with.

That said, I copied the table from adventureworks to...

Since the full version is not free, I did some more research and found a potential solution using Express, but with the Advanced Services included. I've installed that and...

The folder is there, John. Thanks for your feedback, I appreciate it. I'll try installing the full version of MS tonight. I hope its free as well....