Are you using the same account for the object explorer and for the query window?

I didn't ask if you re-connected. I asked if you refreshed.

No, you didn't say distinct, but it is in his original query and is useless when you add something like row_number to the select list.

Post your code. Otherwise, all we can do is guess. It saves time for everyone involved if you post the code.

The first guess is that the new job is doing something different such as trying to access server resources that the proxy account doesn't have access to or accessing another...

Any reason why you're not connecting with Query Analyzer?

Actually, PatIndex does need the wildcards as it performs a pattern search much like the keyword LIKE. Without the wildcards, the entire strings would have to be exact matches. You...

Since you are using SS 2005, you can do the following as well:

Select Field1, Field2, Field2, ..... FieldN From dbo.a

Except

Select Field1, Field2, Field2, ..... FieldN From dbo.b

This will compare the...

My first thoughts when I read this was that it was a really great thing for those of you that built this site. You've seen your hard work turn into...

Then you wouldn't be using a Shared Scalable Database. This isn't just generic label for a concept, it is specific functionality in SQL Server 2005. According to the limitations of Database...

As we say in my hood, "True dat!!"

In some cases it is necessary.

This will give you an error:

Exec sp_executesql 'Select @@ServerName'

This won't:

Exec