ok, If i have taken log backup every 30 min at principal server then what is frequency for Tlog apply...

Hi, i am going for high availability option not for report purpose,

Mirroring option- It is not possible for configure for different version because primary database is SQL 2000.

Ok..All published tables in transactional replication must contain a declared primary key.

In this...

Thanks Sujeet for your reply

As per business best is database should be 24x7 running.

Could you confirm, In transactional Replication should required for all tabled primary keys then only this replication...

MarkusB (11/22/2011)

---

Does this mean you have a table and a stored procedure with the same name?...

due to this error Table & SP does not allowed with same name dbo.upload_sales.

use AGRO

go

ALTER SCHEMA hjbhatt TRANSFER dbo.upload_sales

go

Msg 15151, Level 16, State 1, Line 1

Cannot find the object 'upload_sales', because it does not exist or you do not have permission.

I have execute this command but same issues..

ALTER SCHEMA dbo TRANSFER hjbhatt.upload_sales

Msg 15530, Level 16, State 1, Line 1

The object with name "upload_sales" already exists.

select * from dbo.upload_sales

Msg 208, Level...

Thanks --Mr.Jeff for your valuable reply....

I created clustred index after that it won't help aslo same issues, as you suggested me that is correct after creating clustred index.

Once drop clustred...

GilaMonster (11/12/2011)

---

Widen this index: IX_CMTS_IPADD nonclustered located on PRIMARY CMMAC. Add cpip as a second column.

Widen this index: IX_CMTS_IPADD_D nonclustered located on PRIMARY CMMAC. Add CPEIP, CPEMAC

Thanks for reply Gila,...

kindly find the attached Execution plan about that query.

I really sorry for the late replay...

10 Lacks Records Means - 1000000 Rows count.

Please Provide the solution

thanks

ananda

Hi, Thanks for your reply..

I have done as following steps, but It is not hope again same issues and query batch was not able to completed due to tempdb full...

DBCC SHOWCONTIG scanning 'CMTS_IPADD' table...

Table: 'CMTS_IPADD' (407149808); index ID: 0, database ID: 31

TABLE level scan performed.

- Pages Scanned................................: 13788

- Extents Scanned..............................: 1742

- Extent Switches..............................: 1741

- Avg. Pages per Extent........................: 7.9

-...

Thanks for your reply

Hi Campbell, Thanks for your reply and fesible table solution, minimized lot of table by using 3.5 normal form.

Create MeterMonitor table data will be storing huge records over time.

PointInTime DATETIME...