I use Redgate SQL Compare to build full schema copies of databases. Here is the process:

1) Create a brand new empty database

2) Run SQL Compare and select the existing...

Was the database recently restored from another system?

What happens when you try to access the maintenance plans from SSMS on the cluster? Why do you say it is not working - and therefore, the upgrade did...

If you install SSMS 2008, you can use the filter option to filter the list of tables to only those you want and script them.

Or, if you install Powershell and...

The version that shows up there may not reflect the current version. To validate the client tools you need to look at the properties of the executables and dll's.

GilaMonster (6/17/2009)

---

Florian Reischl (6/17/2009)

---

@Jeffrey:

Erm... Just played with this nullbuster. This might be an important information for you:

This feature works find on SSE2k5 but it does not work anymore on SSE2k8...

I would recommend not using a single file device and continue using multiple files. The problem you are going to run into is very simple. Part of your...

What kind of maintenance would that be? Let's think about this...

Update Statistics? Nope, no tables there that we would want to update.

Rebuild/Reorganize Indexes? Again, nothing there to...

SA (6/17/2009)

---

I agree, though would again recommend discrete usuage.

I recently purged ~ 26GB staging data from 31 GB database and didn't want to leave 26GB of free space in the...

How are you determining that the client tools have not been upgraded?

SA (6/17/2009)

---

What if the following steps are performed

1. Shrink database to required size (include enough room to rebuild all indexes)

2. Rebuild all indexes

3. Backup database

4. Drop the database

5. Create new...

GSquared (6/17/2009)

---

I used Cache about 5 years ago, for one project. My main issue with it was the nearly complete lack of tools for building and managing the database,...

GSquared (6/17/2009)

---

Actually, some of the uses I've seen for Cache (http://www.intersystems.com/cache/) are quite functional. It's a pain to work with, at least what little I've done and from what...

Florian Reischl (6/17/2009)

---

Well,...

Florian Reischl (6/17/2009)

---

@Jeffrey:

Erm... Just played with this nullbuster. This might be an important information for you:

This feature works find on SSE2k5 but it does not work anymore on SSE2k8 for...