Kupy, yes that would probably be a good idea to correlate the exists query back to the customer. It definitely would have been seen with sample data 😉

Edit: Sorry...

Okay, then I would go with Gail's recommendation of 12GB max memory. You don't want to go higher than that, well maybe 13GB would be okay - but, you'll...

Sure, there are a couple of options:

1) Database Mirroring and Database Snapshots (requires Enterprise Edition on the report server)

2) Transactional Replication - requires identifying specific tables (articles) to be published

3)...

If you add additional columns to the output, those changes will show up in SSIS but will not do anything. The new column(s) are ignored in the data flows...

Did you update the catalog on SQL Server 2000 by execute the instcat.sql file from the 2005 instance?

Nathan Davis (5/26/2009)

---

Moving the tables using synonyms sounds like it might possibly work. The set of tables I would move are mainly used in joins from the first set...

As has been noted in various articles and blogs - SQL Server does not like to give up memory once it has it. With this change, what will happen...

To add to what Jonathan has stated - find out if those LUN's are being presented from shared volumes. In other words, are the volumes (and disks) dedicated to...

One more thing - moving these tables to another database will require that the foreign keys be removed and managed through triggers instead of contraints. Make sure you understand...

How are you referencing those tables in your code? There might be a way to move those tables without re-coding. You could try creating a synonym for the...

Glad we could help and you were able to get it set. Jonathan was spot on with regards to x64 - and the requirement to set the max memory.

Execute just sp_configure. Scroll down in the results and find the setting for max server memory. Copy that entry into your command, which will be:

sp_configure 'max server memory...

Steve, I guess that answers the question then. At least it does for me 😀

Okay, you are talking about the steps to perform in a maintenance plan.

For system databases, you need the following:

Integrity Check

Backup System Database

Cleanup old backup files

The above should be...

I don't understand the question. What jobs - what order?

I have a maintenance plan for the system databases, and a separate plan for...