Thank you Michael, let me try the link you paste. I am trying to insert this data in the centralized table which will be used with different reports.

Thank you for reply Michael, i know that this the problem but i don't know how to fix this.

If you can point me to the right direction on where should...

Jeff, this is how the column in the stored procedure used:

CREATE PROC [dbo].[get_ConfigurationsResult]

@DescriptorID AS INTEGER,

@SetFacetName AS...

Jeff, thanks so much for your reply. One thing i don't understand and if you can explain is your comment on

300,000 rows returned to clog the proverbial pipe....

Is the log shipping the same as replication?

This is replication issue

Thank you for the reply, but it seems that i can't access that file. This is the error i am getting: 404 - File or directory not found

Unfortunatelly this is not an option, thanks for the blog.

Actually i made a mistake and posted a wrong information. SQL Job is actually created but there is nothing created for...

Thank you all, i found a way to do this using powershell

Thank you, so if i don't have a set list of file i still need xp_cmdshell? if it is, then i am out of luck, i can't turn on...

i actually founded .tuf file

After testing for several days in dev (sql 2008 SP1 ) i decided to implement log shipping in production ( sql 2008 SP2).

The problem is that i don't see a...

Thank you so much for your replies, i really appreciated!

Thanks for reply,

By saying replication is not working i mean that distribution db has more than 100 million commands nightly and it takes forever to distribute the commands to the...

Great!, Thank you so much for an explanations and links.