1- You create your partitioned table

2- You populate your partitioned table by moving the data you have in your non-partitioned table.

mmhhh.... money? like it happend to me about seven years ago? 😉

and... how much free space do you have in drive C:?

:w00t: I respectfully disagree 🙂

is anybody going to ask if the indexes are unique or non-unique? 😉

Something doesn't makes sense to me, having storedprocs and views referencing your offending table should not prevent you from making changes to that table.

anthony.green (9/17/2008)

---

Hi Guys and Gals

We are experimenting in upgrading our Sybase version from 8 to 10.

Playing with Sybase Central on unloading and reloading databases.

With this we found that we could...

Going back to the original question about encryption methods please keep in mind there are vendors out there eager to sell you encryption-appliances like Ingrian, etc.

You are going to find...

I'm in agreement with Adonia but I would characterize Metalink as a Knowledge Base rather than a simple user forum.

T-SQL syntax for restore is easily available on books online.

No restore is possible if other users are connected to the database.

problem is... I'm not sure I understand what you mean, could you please clarify?

Yes, I'm refering to SSIS packages.

are you lazy or what? 😀 Script would be fully dependent of the structure of your tables, how could a...

Nice! 😀

Nope. Script your changes, apply your changes in each target environment -no silver bullet.