Hi Prateek,

Check this article

http://support.microsoft.com/default.aspx?scid=kb;en-us;176480

Well it doesnot really elaborate on the internal logic and implications of AND and WHERE clauses for Outer Joins but it does throw little light...

Well if you are running the insert and update statements inside a Stored Procedure then related inserts and updates on tbl1 could be done in the same procedure under the same...

use sp_addlinkedserver Stored Procedure to connect to the database you want to accessdata from and you should be able to access data between any number of instances like

select * from...

My goodness I am so ignorant, I thought Left Outer Join itself is been replaced with some other syntax  based on what I heard, I now believe that I am...

Oops, I do not see any sample. Can U pls check again.

Thanks

Thanks Steve,

Well, yes my server is exposed to Internet, but only a section of known people know about its details, its basically a staging server on which we are testing...

Rob,

what does  '0700' refer to in your SQL Query? I mean what part of the date?

Well I believe I posted this thread at a wrong place, at the same time I do won't open a duplicate of this thread in some other forum, so can...

As a matter of fact I donot have any jobs running on my server. It is a fresh install and it only has a single database running on it.

Yeah it is for SA passsword, Well I am wondering what virus can change the Database Server Password, some light on this would be very helpful.

Thanks

What if the above statement is used inside a cursor like

declare mycur cursor for

SELECT * FROM MyTable WITH (ROWLOCK, UPDLOCK)

Do we still need to include it in a transaction for...

Well its always a personal choice beyond anything in this issue, as Bit most of the times is basically used to toggle between two values so char(1) would be optimal...

Exactly I too meant the same, Thanks for elaborating. I believe hawg already has the solution for it.

Hi Ryan,

Well you definitely need to have this wrapped in a transaction however you may want to check if you have proper error handling taken care after insert and update...

Yes I too feel, the syntax is fine, however there should be some issue with the query, I do not see any place where a END is missing.