Thanks for your reply, I have setup transactional replication for selected database objects which are used reports.

I have concerns about the instances - the master database is 60GB (this is...

can you please elaborate on the advantages of log shipping vs replication.

Apart from reports I also want the searches to go against the same replicated database (slave)

Thanks

when I run the insert statement I get the following error.

Msg 491, Level 16, State 1, Line 1

A correlation name must be specified for the bulk rowset in the from...

Does adding 4GB RAM allow sql server 2000 (32bit) to grab more memory

how is this different from sql server 2000 with 64bit with 4 GB RAM

Thanks

I have removed the clustered index to an ID field and set the growth to MB instead of %. Monitoring the results right now.

Thanks Wandrag that helps

Thanks that works

My bad that I was not clear enough, the receipts pay off the EMPID until their balance is 0. In this example

1001 beg_balance is 250

1002 beg_balance is 350

1003 beg_balance...

Thanks for your response

Alloc Amt is calculated based on Priority and Alloc Percent from EMPPERCENTTABLE. For EMPID - 1001 and 1002 where priority is 1 so whatever gets paid will...

The attachment has DDL and DML statements for the example mentioned.

Thanks

Thanks CoetzeeW - I will play tool to know more.

Agreed that storage required for the index is less.

Does the index perform better on nullable column or not null column with default constraint? I always thought it is better to...

Got it to work with substring and patindex

SET FNAME = SUBSTRING(displayname, PATINDEX('%,%', displayname) + 2, DATALENGTH(displayname)),

LNAME = SUBSTRING(displayname, 1, PATINDEX('%,%', displayname) - 1)

Jeff, thanks for the response I didnt put the right way that I wanted I need something like below example

category desc ...

Thanks for the response, I didnt put the right way that I wanted I need something like below example

category desc ...