what is wrong with putting the data into one table as Gail mentioned?

is seems like you are making things difficult for yourself

Use SQL Server express 2005 and you can use Merge replication to sync up the databases when the laptops are connected to network.

Then change the password, and follow the advice provided to prevent it from happening again

Injection attacks don't need to happen on INSERT statements, they change the nature of the Statement so can happen on select.

you say that you are using some...

could be a sql injection attack.

what sort of access does your web pages have to your database?

are you using strored procedures or in-line sql to make the database calls?

Informatica is a much more robust Enterprise wide ETL tool.

SSIS has similar functionality but does not perform as well.

In informatica you map the data flows on the field level, so...

Have to agree with the others, change to Stored Procs, give your Application access to these only and no access to the underlying tables..

svhanda (4/30/2008)

---

Hi steve...

Thanks for reply..

no table don't have...

You can not do an aggregate in the set list of an UPDATE statement ,

set CounterPart = count(*)

You must be getting this error when inserting the data into a table,

are you able to post the procedure that you use to insert the data?

RonKyle (5/1/2008)

---

In the example above, the four tables I showed with a natural key have 3, 17, 12 and 9 rows respectively. When I got here a year ago, the...

karthikeyan (11/22/2007)

---

I want to know UK people cultures. if i came to UK, then i will pick up your people culture easily. Say for example how to behave with man...

RonKyle (4/30/2008)

---

Because of privacy issues regarding the SSN, I would never recommend using it as a PK. When used as a PK, it will exist as in FK in...

so EMP_ID =100 needs to have different values for Comp_Id,

4567, 9876 ?

do the tables have a primary key?

Save it as a BLOB / Binary data type,...