In 2005 you could setup peer-to-peer which is also bi-directional.

There are (as with everything) tradeoffs for each replication type

There are problems.

1- you are using dynamic sql to call the stored procedure so you are open for sql injection.

2. If you use parameters and pass them as NULL you...

From your Post:

IF you replace 0x3E31DB24ED72CD49A8114462A66A0367 in the...

sounds like *A LOT* for increments 😉

Adam Bean (6/13/2008)

---

akshay1974 (6/13/2008)

---

The hex is the job_id for the job. You can query sysjobs and it will give you the name of the job.

e.g.

select * from msdb..sysjobs

where job_id...

The ability to raise "ANY"...

greysun75 (6/13/2008)

---

So how do I get around this if I am not sure which of the variables will contain values. The stored procedure is being called like this

Set rsResults...

The number of quotes does not makes sense. In addition you are using Temptables that do not seem to be declare elsewhere in the script ?

A "blank" variable is not a NULL value therefore coalesce will return a zero-length string and your "ANDs" will be false.

jagadish_sds (6/11/2008)

---

I want to compress the values and insert/update to table and when selecting the values I want to decompress it and select.

Is there any functions/methods available in sql server...

People tend to call that to an "audit" table which has the same structure than the normal table plus some extra metadata information like timestamp for the change, if the...

Seems like a client side issue. Nothing to do with SQL Server.

If you need to increase the search speed even further you could create an INDEXED VIEW and run your query on it.

the view definition would be like:

select fk_tbl_users_id, fk_tbl_visits_id, date,...

I don't understand why such an old and bad rated article is still alive in this site.

Another thing to consider is the posibility of "archiving" old data. It has been my experience that in many occassions we let the tables grow with data that is almost...