Table partitioning is probably the way to go, but another method could be using Views and/or Stored Procedures with two different tables.  Depending on Referential Integrity issues, you could truncate...

Jez: Sorry, I confused you with the original poster

James.

No, he is looking for the definition of the table(s) you are querying, something like this:

CREATE TABE myTable (

Col1 varchar(10),

Col2 datetime not null)

etc.  If you don't have the table definition...

I'd like to offer the price I won, ANTS Profiler Pro from RedGate, to anyone willing to make a $100 donation to Katie.  the ANST Profiler looks like a great...

Well nvarchar(50) shouldn't make a difference.  Unless your willing to post the DDL (Data Definition Language) for the Table and Trigger I doubt you'll get much more help. 

The best way...

What is the data type of the column FINISHTIME?  Since it doesn't appear to be a syntax error, posting the definition of the entire table the trigger is assigned to...

The problem is the Insert trigger fires only once for the batch of records inserted, not once for each record in the batch.  Most inserts are "single" record inserts unless...

When you executed sp_adduser where you physically in the database BBSTest?  (i.e. was BBSTest the active database when you ran the command).  Even though the login has a default DB...

My first 4 years in the military was as an MP working a SCIF sites in Germany.  These were 12 hour shifts on site.  That time did not include travel...

I've never given it a lot of thought.  I started out in the military where 12 hours days 7 days a week is the norm.  After 15 years I retired and...

I don't know if it has to do with the time, but I have experienced it also.  I know several other folks have also complained about the problem inside various...

Here are some commands that should help you accomplish what you want.  You should try to use "real" SQL commands rather than the wizards whenever possible. 

Use Server Management Studio...

You MUST change the location of the database files during the restore.  By default it tries to use the path recorded in the backup and since your development and production...

Don't do a bulk import.  Use a SQL Connection Object, a Flat File source object and then multiple transformation objects (one for each table you will transform into).  Each transformation...

There are an awful lot of variables that you have not covered in your request.  This task should be realtively simple for DTS to handle.  Open a connection to the...