Thanks Tim

I was wondering if there is a way where by putting any LOCK hint etc I can still read that deleted (but uncommited row) from the master table.

Thanks for the help Brian and Prakash.

I have many jobs that run during that time but they have been running fine and this message was not coming earlier and we...

Thanks Pam, I have done it for now using the temp_table/identity route. I will check the other options too to see if they are better.

Sorry my qoestion got posted before I could complete it

In the spreadsheet in the first column there is some data say (table name) and in the second column there is...

Thanks for all the suggestion. we might have to reconsider about the idea of having a seperate lookup database. As suggested creating views would resolve the problem partially but the biggest hurdle remains the...

Thank you all for all the suggestion.

Although I mentioned only few table names as a sample for this purpose but I have more than 450 of these reference tables (that...

No it doesn't appear there.

Thanks

Thanks much Andrew, above mentioned code definitely helps.

Thanks Kishnan, Jimmy

For some reason under EM -- Properties ...... "startup service account" it doesn't show me any value (and it's grayed) for both service and agent (although I have registered...

Just to clear one thing, you may not see the exact same issue that is mentioned in the article example but the problem is pretty much...

Thanks PW

Looks like above problem is related to following issue and has resurfaced with SP4

http://support.microsoft.com/kb/321541/en-us.

(for some reason my latest posts to...

Someone who has SP4 installed on your server, Could you please run the above mentioned query on your server to see what result are you getting?

 If you are not getting...

Someone who has a latest SP4 insalled on your servers, Could you please run the above mentioned query and confirm what result are you getting.

If you are NOT getting the same...

PW,

If you will see the view create script it's not using "SELECT *".

The sample data that I mentioned here is simplified form (although the problem is same for both...

I totally agree with you Sergie, that 100 should not be equal to 200 in any version.

here are the results for the above query that you asked me to ckeck...