Having played with RS for a few months myself I find it extremely good for a beta product.

As for your "page break after a group" gripe. Well you said it...

A couple of things to consider when setting up the maintenance plan,

1) What's the uptime requirement for the database?

2) How important is the data that is contained in the database,...

To set Global Variables and save the changed values you will need to open the package and save it. Doing this via the DTS Designer will preserve the layout but...

If the stored procedure are all in one file you can just run that file using OSQL. If they're in individual files you could do a bit of coding in...

Take a look at the Meta Data functions.

@@PROCID returns the ID of the current procedure, OBJECT_NAME() returns the name of the database object. Used together OBJECT_NAME(@@PROCID) gives you the name...

Don't use the '$' character in the name.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

If someone wanted to get really creative they could put togther a dynamic SQL statement based on syscolumns ...

Pass in a table name, retrieve the object...

You could also try horizontal partioning and placing the partitions on seperate filegroups which reside on different physical raid volumes. The same can be done with the indexes. Check the...

Is there any particular reason you are using the ROWLOCK hint?

If not remove it and let the server handle the locking.

From Books Online,

quote:

---