can you post the exact error message or error picture as an attachment??

Did you use SQL Login? and check the Authentication mode.

The error message indicated a different user and you specify that the Job owner is sa..

Do you remember what is the Security Context you have provided while configuring replication.

Also...

You should be able to connect from another PC in the workgroup by using your system IP Address and the TCP Port of the SQL Server.

So something like this...

Look at the SQL Server Error Log and find what is reported in that, post it here, until which it is blind guessing. There can be any reason due to...

Is there an estimate of how many records you are going to move per batch or per Day etc...

As you have mentioned you have certain criteria that needs to meet....

You seem to be starting with SQL Server.

Follow a good T SQL Server programming book and then practise that on AdventureWorks2008.

It would be better to post real time...

From the explanation you have given, I would suggest, try running the Longest running report individually (schedule it that way) and run the other 27 odd reports each one after...

Use this.

CREATE TABLE #Temp ( ID INT IDENTITY(1,1) NOT NULL, code INT, [name] VARCHAR(50), shortcode VARCHAR(50),

program VARCHAR(50) )

INSERT INTO #Temp

SELECT code,name,shortcode,program FROM ffout

INSERT INTO dbo.table1

SELECT code,name,shortcode FROM #Temp

INSERT...

What is the Datatype you have? Is it Timestamp Datatype or Datatime Datatype that you are using as a timestamp.

You can implement it using Database Partitioning.

Follow the link http://www.learnsqlwithbru.com/Database%20Partitioning%20in%20SQL%20Server%202005.htm

SQL Server Error Logs must have the information. Check it.

Have not tried that any time, but I would surely test this and...

Yes guys,

I din't have time to create the table, populate data and look at the results.

Thanks for correcting me.

Change the Query and include the Columns Names like this

USE

[NDP-MWD]

SET IDENTITY_INSERT [NDP-MWD].dbo.[Comments] ON

INSERT INTO NDP-MWD.dbo.Comments ( COL1,COL2,COL3,COL4........ )

Select COL1,COL2,COL3,COL4........ FROM NDM-MWD.dbo.Comments

SET IDENTITY_INSERT [NDP-MWD].dbo.[Comments] OFF

Copy pasting the SQL code in the Post would have been better if posted using CODE TAGS for easier readability.

Any way, you are still asking the same question about Indexes,...