Viewing 15 posts - 7,921 through 7,935 (of 9,715 total)
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
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...
June 1, 2010 at 8:45 am
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...
June 1, 2010 at 8:43 am
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...
June 1, 2010 at 8:37 am
Sorry, my company blocks that site. Can you attach the image to your next post?
May 25, 2010 at 4:21 am
pobeda (5/22/2010)
Updated sql server to SP 3, did not help. So, Management studio on my PC older then on the server right now.
This is why we asked about versions. Workstation...
May 24, 2010 at 4:17 am
Viewing 15 posts - 7,921 through 7,935 (of 9,715 total)