Okay, my head is clear... walk on the beach and lunch... and I still cannot make this query return anything... even when specifying "WHERE j.name like '%'", which should bring...

Not my morning

First it was a lost post... I posted a long response to another entry, and it was GONE... and now, two...

Mine, too!  I just ran it on an instance that is running replication, and get nothing... no rows returned.  So, now, I really DO have to figure it out.  Thanks...

Mine, too!  I just ran it on an instance that is running replication, and get nothing... no rows returned.  So, now, I really DO have to figure it out.  Thanks...

Just lost a long post on this, and no time to recreate it now.

I have never been successful with named instances because I always ended up having problems with third-party...

BTW, the advice above presumes that the package wasn't encrypted, in which case you may have to go back to CM and get the developer's copy.

just retrieve the package into the development environment and "save as" specifying the new format.  I just googled "compare two files" and got tons of hits... the first one being...

It fails with an error that the named DB already exists.

Jeff Gray hit it... if you are looking at cpu usage on task manager, you are seeing the just isn't clear.  You don't say what CPUs you're running, I presume...

it's been four hours and nobody has helped... I see you are online now.  Have you connected?  Was there anything going on before you could not connect?  Is it an...

Like I said, "I tested it".  It worked just fine.  My database was (is) set to full recovery mode and has NEVER been backed up.  Must be exceptions to the...

That's a great tip!  Thanks.  I hope MS comes out with something for SMO.  It would be nice to put this in place for all our 2000 DBs; but is...

2000 had a bug that when you exported (from one db to another, locial import) it does not use the path you setup like Gurpreet suggests.  You have to create...

just do the "DBCC SHRINKDATABASE ('<dbname>')" step provided below.

You don't care about backups or contents, right?  when you're done you just want the space back?

This works... I just tested it...

yes, SP4 is SS 2000, not 2005, and no, I am not aware of any issue with 2005 SPs.  But, AWE still gets "turned on"... (unless you're running a 64...