If the database is case insensitive, do you know why the vendor put an UPPER() function in the WHERE clause?

If you don't have the auditing set up to keep this info, then there's really no way you can go back and find out who changed your server properties. Sorry....

Better method... Not really.

Simplier (and not recommended) methods? Yes.

1) Set all DBs to Single User mode.

2) Take all DBs offline (will have to click the "Disconnect connected users"...

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...