Is the identity column your primary key? if so i would not delete it, Identity columns can...

I am not sure if I understand this statement/question,

However regarding PKs -- All published tables in...

Transactional replication supports upto 1000 columns per table, what is the error message thar you are getting?

You will need to post the query that is causing problems and the table structures, the specs of your machine dont mean anything by themselves

There are no direct replacments for those functions in SSIS 2005, I also am an informatica developer so i understand the issues.

In SSIS i would either write an update stored...

It seems from the error message that there is a problem with the data type for the Delete_Flag_Out column.

Check that you are using the correct data type in the data...

try using

select system_user

This is quite an open-ended question, the things i would check are;

Read up on normalisation and make sure your database in normalised to at least 3NF

http://en.wikipedia.org/wiki/Database_normalization

that you use the...

yes it is possible, obviously it will only convert the numeric part of the nvachar string

We have been using Scrum for a couple of years now to manage our Agile development

We were all a bit reluctant to change the way that we were working, but...

Could you post the execution plan for the query?

How many rows are in the table?

Also, do you really need all the columns for the tabel (select *) it will...

(X64)

Michael Valentine Jones (6/22/2009)

Sorry if my irony wasn't thick enough to detect, but just for the record I do think databases should be normalized. :blush:

I recently asked a...

Be aware that the peer to peer feature is only available on Enterprise Edition of SQL server,

I personally favour merge replication for this scenario as it...

Jeff Moden (6/22/2009)

jeffrey yao (6/20/2009)

Michael Valentine Jones (6/18/2009)

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko...