Viewing 15 posts - 31 through 45 (of 97 total)
October 27, 2009 at 2:48 pm
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!591.entry
and if we want to export into xls we can use the below query but we have to give heading Name onexcelTargetfile.xls file before running this query:
INSERT...
October 26, 2009 at 1:49 pm
it will clean up every after "Distribution clean up: distribution” job runs.
http://www.replicationanswers.com/TransactionalOptimisation.asp
HTH
Vinay
October 22, 2009 at 10:32 am
Right...
I would backup and restore on subsriber and set up the replication with nosync( subsriber is already having data)...
my one cent.
Thanx.
Vinay
August 27, 2009 at 2:47 pm
I would say it could be something (might be Network) causing this issue.
Before commenting on anything we have to investigate the system completely like
1. what DTS is doing?
2. at that...
August 27, 2009 at 2:43 pm
my suggessions would be:
1.you can use replication (snapshot/transactional)?
2. use bcp that will be fast for small tables if your transfer is not very frequent(once a day) and less records?
but replication...
August 27, 2009 at 2:38 pm
If you have more then 255 columns if possible go for log shipping or other technique.
For replication: normalize the tables(as you stated) and replicate both tables.
HTH
Vinay
August 27, 2009 at 2:29 pm
Here is BOL:
"Subscriptions expire and are dropped if not synchronized in the following number of hours/days
Set the number of hours for snapshot and transactional publication, or the number of days...
August 27, 2009 at 2:02 pm
August 9, 2009 at 6:53 pm
Thank you all for all your comments....
This is my first post QOD to Sql server central...We have some sql server 2000 setup which we migrated from older version (I know...
August 7, 2009 at 8:21 am
July 22, 2009 at 10:29 am
July 22, 2009 at 10:27 am
That is ok.... what is your issue, dont recompile or free cache. its not always good specially on sql server 2000 its batch recompile where as on sql server 2005...
June 15, 2009 at 2:48 pm
Viewing 15 posts - 31 through 45 (of 97 total)