Thanks for letting me know that there may be issues with Identity columns. We have a lot of tables with identity columns, so we will watch for their replicated values....

Hi Lempster,

We have 11 databases and only 2 databases (not tables) that have data changing in them (get hit by the application). One of these two databases X (has about...

Thanks Lempster, for you valuable suggestions. There are just a couple of othere things that I wanted to find out.

1. We want to keep the replication going for about...

Thanks George!

Thanks a lot George for your valuable advise.

Just one thing...as we have not done this before. Are there any possible problems when we install sql server and restore on...

Thanks!

Yes three are several 'GO' in the individual jobs. I guess it would be ok to script them first and then deal with the 'GO' separators within the jobs. There...

Jack, that is what I was wondering too but I would not want to change the setting in the database.

If I look at the configuration related to parallelism on the...

Yes, I have been wanting to do that but have not been able to thus far as it is a PROD enviroment and because this happens sporadically. I might get...

Yes it is a web application and the code calling the procedure is c#. Typically there are many users on the system doing this kind of order creation when this...

I think I need to clarify that I am able to reproduce in a round about way the problem that is happening when the application is running. I did this...

Thanks Adi, it's good to know that there are no known bugs in scope_identity. The trouble with putting a debug is that it is only happening in the production environment...

Thanks!

We had locking problems in one of our databases due to the use of temp tables in stored procs. The reason for our problem was the use of ...

I tried all the four delimiters that show up in the window when selecting column delimiters, namely: coma, semicolon, tab and the vertical bar. None of these is in the...