Which query, the one that Grant gave as sample? Give your query for better understanding.

My question is that when i run this query,...

The query is performing what is it supposed to be doing.

The mistake in your query is that you must be using something like a derived table or a temp...

Is the job disabled? Disabled jobs would not run at the schedule time.

Jeff is right, and he also answered the list of 3 things you wanted.

Google, Yahoo, Bing.............. Bingo! 😉

Look at the Authentication Mode of your Server is it set to Mixed Mode?

select authmode=case serverproperty('IsIntegratedSecurityOnly')

when 1 then 'Windows Mode' Else 'Mixed Mode' end

Run that command and see what does...

That's good Scott. Appreciate for taking time and sharing your experience.

I'd be working all business days. :w00t: That's a problem being a consultant.

Go to My Account --> Click on Forums Control Panel and in the next page Edit Signature.

Welcome ! 🙂

Waiting.

Just 2 more days and my wife is returning from India 😀

SQL Server 2008 64 Bit on Windows Server 2008 R2 Enterprise.

Yes that must have been the case..

Well, I tested and this is what I have.

In Snapshot Replication you can't do the initial setup with a different column names, you can only start with a different...

Please read the Best practice article below and post some test data, since that provides us to see what error you are getting. It enables us to test a readily...

Increasing disk space is not the issue you need to address. First address what is the reason the performance is slow? Are all queries slow or a particular one is...