Tara-1044200 (6/1/2010)

---

This disk is SAN configured with RAID5. I always think of keeping database files on multiuple drives hoping to have better performance but my network admin says that it...

So I guess the answer depends on how the linked server is setup. I'm betting the impersonate permission is causing your ability to use it.

Chances are your uninstall didn't uninstall cleanly or completely. Or the install upgraded a SQL Server component. I'd advise googling "Uninstall Deklarit" and see if you find any articles on...

I don't know what settings Marco used, but I created a Test sql account on a server, using Master as the default and granted no permissions.

The linked server does not...

mchofman (6/1/2010)

---

It is possible to run query at a linked server as another user with the EXECUTE AS statement. In the example below I login as user "Test" and I...

Every function included in a WHERE clause causes problems. It most instances, it can turn a...

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