Have you been able to connect to them before?

If so, what recently changed on the computer? Service Packs? Other updates? New programs? Uninstall of old programs?

If not, try re-installing the...

She's not asking for the log file. Do you know how to do a deadlock graph?

If not, let us know and we can walk you through it. If so, please...

Try re-writing your code in ANSI style joins.

UPDATE W

SET TableNumber = T.TableNumber,

LineNumber = T.LineNumber,

.....

UnitNumber = T.UnitNumber

FROM [LINKED SERVER].DATABASE.dbo.TABLE1 AS W

INNER JOIN [LINKEDSERVER].DATABASE.dbo.temporaryTABLE AS T

ON W.IdentityID = T.IdentityID

The method you...

To use "Execute AS," I'm pretty sure you need Sysadmin access or you need to be executing a proc that has that phrase *in* the code.

If you only have read...

NULLIF? That's the first time I've heard of that function. I'm glad I read this thread.

Is this a one time thing or something you'll be doing more than once?

If more than once, I suggest using SSIS to create a package that you can kick off...

It sounds to me that you're going about this the wrong way. You're focused on a single solution to the problem (i.e., that it was indexes) without actually checking the...

Sorry it took so long for me to reply. Been busy at work.

On that screen shot you took, you forgot to check a box right above the path information you're...

Sorry, my company blocks that site. Can you attach the image to your next post?

This is why we asked about versions. Workstation...

Are you sure they're hitting the correct instance? Because if there's both a named and a default on that server, they're no longer hitting the proper instance.

They may also need...

chaudharyabhijit (5/20/2010)

---

I have a similar problem where i am saving data in a csv file from a table. I need to upload the csv file to the ftp server everyday...

Greg Roberts-134214 (5/17/2010)

---

Unfortunately, a test envioronement will not provide any impact as this is a user in the finance department building his own reports, and he thinks execution times over...

Log onto the server. Right-Click My Computer and go to Manage. Many file locks can be found under Shared Folders -> Shares or Shared FOlders -> Open Files. Sometimes, though,...

Unable to delete is different from unable to find.

Check the file locks.