Viewing 15 posts - 7,921 through 7,935 (of 9,720 total)
Describ the steps you're taking to read the error log, please.
Also, is the log file hard drive full? Have you recently run a diskscan to verify all the sectors are...
June 2, 2010 at 8:21 am
Tara-1044200 (6/1/2010)
June 2, 2010 at 8:18 am
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.
June 2, 2010 at 8:12 am
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...
June 2, 2010 at 8:09 am
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...
June 1, 2010 at 11:32 am
mchofman (6/1/2010)
June 1, 2010 at 11:21 am
mberry 51447 (6/1/2010)
somehow I dont believe that use of the UPPER function is causing this.
Every function included in a WHERE clause causes problems. It most instances, it can turn a...
June 1, 2010 at 11:11 am
mberry 51447 (6/1/2010)
Nope it is SQL_Latin1_General_CP1_CI_AS
If the database is case insensitive, do you know why the vendor put an UPPER() function in the WHERE clause?
June 1, 2010 at 10:55 am
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....
June 1, 2010 at 10:28 am
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"...
June 1, 2010 at 10:24 am
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...
June 1, 2010 at 10:19 am
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...
June 1, 2010 at 9:01 am
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...
June 1, 2010 at 8:59 am
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...
June 1, 2010 at 8:54 am
elutin (6/1/2010)
SET @Package = NULLIF(@Package, '**SELECT ALL**')
NULLIF? That's the first time I've heard of that function. I'm glad I read this thread.
June 1, 2010 at 8:50 am
Viewing 15 posts - 7,921 through 7,935 (of 9,720 total)