It worked until yesterday, so what has changed?

Were permissions changed on the remote server?

If being called through an Agent job did the Agent service account change?

If being called from a...

you can use a table lock, but then this:

will not be possible without using NOLOCK...

An index's size is dependent upon the size of the columns and the number of rows in an index. For instance a one column index of data type int...

I suggest you read this article by Jeff Moden, http://www.sqlservercentral.com/articles/62867/

What is the data in the source? I assume not 0's and 1's.

Can you be more specific about growing too large? If the volume of data included in the index is growing then the index will grow and as long as...

When getting the row you can specify the UPDLOCK hint on the select query which will allow users to read the row(s) selected, but not update them.

Object creation in tempdb will use up space in tempdb so those are part of the issue with tempdb usage. The SORT and HASH warnings are also things that...

Can you successfully query the linked server using any login?

Can you post your linked server configuration?

DDL and sample data with desired results certainly makes it easier to provide tested code, but I think something like this would work:

SELECT

*

FROM

...

sharon_sfy2k (7/10/2012)

---

sorry sir if make you confused....

EmpNo DateLog Timein TimeOut

001 ...

Can you post your linked server configuration?

When you say you run it in BIDS on the server, do you mean the SQL Server or the file server?

Since the job completes it doesn't sound like a permissions...

I'd use TABLOCK as specified in BOL(http://msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx)

Sure, I had column that delimited values in it and I wanted to split that column so that it created on row for each value. The original table was...