The flat file would be used as the data source by a search platform for user searches on a site. The live data sits on a Sql box. I am...

"The process could not access database 'I:\test_repl.txt' on server 'NYSQLGRP03'."

Here is the code that I am using to create the subscription, I have already set the publication to allow heterogeneous...

SELECT 'Subtotal',pin,SUM(CONVERT(INT,callduration)) sum_callduration,SUM(CONVERT(FLOAT,charge)) sum_charge FROM #gmreport

GROUP BY pin

Insert these values in another temp table to get the result in the format that you want.

You should be able to setup a linked server from the sql 2008 to sql 2000 server, please take a look at this

http://msdn.microsoft.com/en-us/library/ms190479.aspx

Once the linked server is setup you...

Understood, Can you try the linked server solution. If that is not feasible can you post some sample data and also the package file, I can take a look in...

From what I understand, you might need a data conversion task between your source and destination in the package to make sure that the datatypes are the same.

The other approach...

Thanks for the correction. The background thread is spawned when TDE is enabled on the db. It runs during the initial encryption. I am quoting the article,

"When TDE is enabled...

I would use transactional replication, its pretty easy to set up from the GUI. Also this article explains the entire replication process in detail, http://msdn.microsoft.com/en-us/library/ms151198.aspx

And the reason I need that column is to satisfy a constraint on the table at the subscriber. So for eg. If modifieddate exists in a third table(on the subscriber)...

Pankaj Shere (5/20/2011)

---

Also if you are doing vertical partitioning all columns must be present on the subscriber. In my case they are not. So if table A is a publisher...

Also if you are doing vertical partitioning all columns must be present on the subscriber. In my case they are not. So if table A is a publisher and I...

The column names are different. I get an error when I start replication. "invalid column". Havent played much with service broker but will look into it. For now we are...

This can be done. You need to modify the delete procedure used by replication to delete if older than 6 months. The procedure can be found on the subscriber database...

Lowell, thanks for the response. I plan to put the trigger on the staging table on the subscriber, so it ll fire on the same server as the target table.

Also...

This is what I use to;

SQL job which runs a script every 15 mins and checks for latency. The job does the following:

1. Post a tracer token at the publisher

2....