just found this link

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/36935326-b52e-4d14-9114-2b1f52ad05fd

Elliott,

you said

peer-to-peer replication is not typically used in cluster configurations because the database files are on shared storage and onyl one server may be in control of the shared...

wow, Elliott!

really thankfull for your information.

just have a question, why you don't like peer-to-peer in this configuration?

i already have sql enterprise and it can be setup in a breeze.

thanks again.

Elliott,

Thanks man for all your time.

I think i'm not explaining it right.

I'm trying to have an environment with 2 sql servers. traffic will go to sql1 all the time...

Thanks Elliott.

Site1 has 90% of the users so i what i was thinking is sql1 would take all the requests from site1 and site2.

If sql1 is down, all the requests...

Thanks ColdCoffee for the reply.

I don't see the sql statement that says 'select count(*) from' in your statement.

when i execute your statement it gives me an error that says 'invalid...

any inputs on why it is failing?

i'm sorry GilaMonster

i hope this time is the correct one

(171 row(s) affected)

Table 'Menu_Descriptions'. Scan count 1, logical reads 2, physical reads 1, read-ahead reads 0, lob logical reads 0, lob...

Attached.

Thanks

Below is the Statistics

Client Execution Time09:05:43

Query Profile Statistics

Number of INSERT, DELETE and UPDATE statements00.0000

Rows affected by INSERT, DELETE, or UPDATE statements00.0000

Number of SELECT statements...

We moved the database to a windows 2008 64bit, sql 2008 for testing and it ran fine! actually the database has 15 million records, and when we executed the query/stored...

thanks guys for trying to help

how can i get the execution plan and the statistics i/o?

thanks