Are you making us do your homework for you?

Why dont you make an attempt and we can guide you through?

You could do custom paging. If you google there are plenty of articles describing how you can do it In brief, you only retrieve the 10 records for the page...

(1) Did you delete she subscriber?

(2) Did you use the "Disable Publishing" wizard to disable the replication?

you need to do both of the above for proper disabling. also make...

There is a "scripts" section in this website. You might find some code similar to what you want over there. Why reinvent the wheel?

If all the 46 fields go to 46 different tables in DB2 then yes you would write 46 different update statements. You could group updates to multiple fields from same...

can you do a PRINT @fyear just before the IF loop to see what is the value the variable has?

SELECT * FROM my_table where DATEDIFF(month,created_date, GETDATE()) <= 12

check out DATEDIFF in BOL for more options.

We have a T-Rep in our system and over 300 tables being replicated under one publication. Our DB size is around 160 GB. And we have no issues as such....

If its not a big table, you could drop it from subscription, truncate the table from subscriber, and add it back to the subscription. then start the snapshot agent. It...

It depends on your DB. If you have large tables you might want to put them in a separate file group or sep drive. Obviously log will be on a...

(1) Keep the Db in simple mode

(2) You can create a job to truncate the log and let it run every minute or after every 2 minutes.

also if you...

I am not sure if you can get the current LSN during a restore. First of all you cannot even connect to the db. I am not sure if you...

you could use a CASE statement. check outBOL for syntax. aproxly:

SELECT

...

CASE WHEN startdate=Enddate THEN 1 ELSE 0 END

FROM

...

I have done something like this recently and it still took 5 hrs for 1 bil records. so expect at least that much time frame. It also depends on the...

whoa 500 BIL records????

Is this a one time process or a routine one?

I would recommend doinng a BULK INSERT or BCP for this. It will be significantly faster. You could...