No. Only if there was a commit and then it go locked by another transaction. Within a transaction, changes made but not committed are immediately available. The...

Cliff,

You are right that READ_COMMITTED_SNAPSHOT being on or off changes outcomes, but just not in the case stated, because of the WAY it is stated. As long as the...

Bitbucket,

I understand your explation and I read the same information from BOL, etc. That doesn't change the fact that the way you framed the scenario, it makes no difference...

It seems that READ COMMITTED gives the same result. Transaction 2 cannot change the row until transaction 1 finishes, but within transaction 2 it sees any updates it has...

Some of us work in very large shops with many servers and 'Production' database instances. When referring to 'Production' instances, especially the really large ones (we have some with...

The comments Jesse refers to above are right on point. The problem with Grasshopper's in-line comments example is that too often they get left in the code when it...

Given the inconsistancies noted, I guess it brings home the point that one should be consistant in coding. Either use the -- convention to comment a line, or use...

That's right!

When I corrected the code to be

PRINT '1' -- /* ;PRINT '2' */ ;PRINT '3' /*

PRINT '4' --*/

--/*

PRINT '5'

--*/

/*

PRINT '6'

--/*

*/

PRINT '7'

--*/

PRINT '8'

the reply was

1

4

5

8

Using Studio 9.00.3042.00

PRINT '1' -- /* ;PRINT '2' */ ;PRINT '3' /* PRINT '4' --*/

--/*

PRINT '5'

--*/

/*

PRINT '6'

--/*

*/

PRINT '7'

--*/

PRINT '8'

yields a return of:

1

5

8

The parser only shows PRINT '1' , PRINT '5'...

TO Russell,

What version of management studio did you use? In studio 2005 I got 1, 5, 8. I triple checked the executed code to make sure it was...

From my perspective...

I have been a database developer, DBA, designer and architect for (too) many years on all major DB platforms. I architected and implemented a 7TB data warehouse...

DIRECT QUOTE FROM BOL: "By default, the Merge Agent uploads changes from the Subscriber to the Publisher and then downloads changes from the Publisher to the Subscriber"

Merge Replication is 2-way....

It makes no difference whether the systems are 32 or 64-bit. They will all talk to each other just fine. I am puzzled, though. You said you...

The ID for connection must have CONNECT privileges as well as read. Can you connect directly to this ID on the TEST server through Management Studio. If not,...

This seems to be a common occurrence in SQL Server 2005 jobs. There seems to be a bug in the job handling mechanism that makes it think there is...