because these are automatically generated by Sql server and you cant drop them (as far as i know )

i think you can do one thing

1. Add a column in source table "archive_flag"

2. set archive_flag = 1 for six month data

3 inset data into dest. table where...

Are these Statisctics are manually created ??

I havent got much help from these deatils but it looks like the agent user doen't have access to the linked server.

Also refer this http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

post the complete error and query you are using in job.

its better to keep A DDL trigger just for future prospect.

You can also choose C2 Audit Trace , it is good option but the main limitation of the auditing is that it reduces the performance of the SQL Server. This...

If your Database is handling good amount of transactions , growth of log is expected.

Read Log Growing Pains[/url]

I would go with Mirroring

INSERT INTO LINKEDSERVER.Databasename.dbo.Tablename

Select * from DatabaseName.dbo.Tablename

Try this

DECLARE @availableSpace AS FLOAT

DECLARE @alertMessage AS Varchar(4000)

CREATE TABLE #tbldiskSpace

(

driveName VARCHAR(3),

freeSpace FLOAT

)

INSERT INTO #tbldiskSpace EXEC master..XP_FixedDrives

SELECT @availableSpace = ROUND((freeSpace)/1024,1) FROM #tbldiskSpace WHERE driveName = 'D'

SET @alertMessage = 'Free Space...

Paul White NZ (4/7/2010)

---

If your table is relatively small, something like this is simplest:

DECLARE @test-2

TABLE (

ID ...

hmm thats quite interesting, or i would say some poor SQL logic ;-).

Post the Stored Proc's script

these link can help you

http://www.sqlservercentral.com/articles/Integration+Services/61774/

http://www.sqlservercentral.com/Articles/SQL+Server+2005/SQL+Server+2005+-+SSIS/

Have you tested it ? i dont think you did.

Script is looking OK but better...