You are seeing exactly what I would expect. The JOIN and WHERE clauses are different parts of the query, and the JOIN is logically evaluated before the WHERE.

In a left...

I don't think any REAL DBA (i.e those who chose...

I can't see your blog comment Brandie, but look at the other articles in his blog... virtually every...

Is it your own job that is being found and therefore generating the email, which obviously isn't running when you execute it from SSMS?

Your strange/inconsistent results may be down to the fact that your IF statement had the incorrect OR in the where clause, but inside the body of the IF statement, you...

If think you've made the classic mistake with NOTs and ORs:-

set @results = (select count(*) from jobinfo

where [name] not like '%hbu%' OR [name] not like '%populate%')

should probably be

set...

I can't point you at anything that confirms what you are witnessing, but I can understand it (sort of).

When a transaction is written to the transaction log, it is either...

Use the system stored procedure sp_rename...

sp_rename 'old name', 'new name'

I think you need to provide a bit more of an explanation...

For example, why should 2.5 come after 4.1.2

If there is no network connection between the Server and the Local machine, then how are you going to move anything from the Server to the Local machine?

If you are running the whole script from the server, then this is the bit you need to change:-

select

@FileName = 'C:\Temp\SampleXMLOutput1.xml'

It needs to refer to the...

David... one of the replies in your link certainly indicates that the same issue exists in SQL2005.

It would appear that all Microsoft have done is to make the catching of...

The difference is the way this statement works:-

set @A=@A+@rev

When it is declared as a CHAR, it is a fixed 50 bytes, so you are trying to put 50 bytes +...

Just Google "clustering sql server" and you'll find a ton of good links.

The first one on my Google list was An Introduction to SQL Server Clustering by Brad McGehee

You said that you had removed FK constraints... was this on the publisher or subscriber? If you only removed them from the publisher, then you could be suffering from the...