If you need all the formating on the server side, can you post a bit of DDL

If you don't then join the tables...

Sorry for the bad news but downgrade restores are not possible.

As a workaround use DTS, bcp, or SSIS

Cheers,

I wonder how you changed the collation of all the columns! It is not a simple operation when those are using FK, Indexes, Check Constraints, statistics, etc ...

As expressed above...

Or redesign that sp into multiple sp(s) and let that developer choose the lower level one. In other words, modularize the code

Paul,

I believe that definitely a re-write is definitely the only posibility

If you can, keep us posted!

Create trigger tr_upd_employee on Employees for insert

as

if @@rowCount = 0 return

if Update ( TeamID )

 begin

 Insert into AuditTable ( EmlpoyeeID, OldTeam, NewTeam)

 select new.EmployeeID, ot.TeamName,  nt.TeamName

 from inserted new join deleted old...

Can you post some sample data... to help us a bit

Make sure also that the first statement of your proc is

SET NOCOUNT ON

There have been several post lately identifying poor performance with the ntile feature and some alternate methods have been proposed

ex: http://sqljunkies.com/WebLog/sqlbi/archive/2006/04/19/20482.aspx

Give that a shot!

Cheers,

I think you need to use the following :

insert #tmp

select * from openquery ( <linked_server> , 'SET FMTONLY ON; exec <db>.dbo.sp ''2006-03-13'', ''2006-03-14'', 1' )

I also think that saying never use select into is extreme. It has good qualities as expressed above in terms of log space and data migrations. It also can be...

He he ... You forgot to include <shameless plug> in your comments joe.

I have read your book and I have read others too and not everything is as cut and...

Can you post the code of the procs ?

Peter, can you come up with an example in which my solution doesn't give the right result? (Clue: the answer is no.)

assume first table has id =3 and fk...

By the way If you are expecting it to grow I would not shrink it at all!! you will incur in physical fragmentation next when it fills up and you...