Viewing 15 posts - 31 through 45 (of 104 total)
If the linkedservers were setup to use remote login then you can drop and recreate them. You can execute sp_helplinkedsrvlogin to find out remote logins.
February 21, 2006 at 8:28 am
Make sure the user logout and login, or reboot, to gain the new credential.
February 21, 2006 at 7:58 am
It seems the SQL login has the proper permission to server1.db1.owner.table. Make sure the Windows login has the same permission as SQL login.
February 21, 2006 at 7:47 am
Thank you all for your valuable insight, I really appreciate it.
Jimmy
February 21, 2006 at 7:26 am
Thanks to both of you. Are there anyone else would like to share your experience ?
Thanks...Jimmy
February 20, 2006 at 9:29 pm
I found the following VB code on the web that does what I need:
Option Explicit
'========================================================
' API Functions
'========================================================
Private Declare Function GetVersionEx Lib "kernel32" Alias "GetVersionExA" & _
(lpVersionInformation As OSVERSIONINFO) As...
September 14, 2005 at 10:30 am
Thanks for the reply. What I'm looking for is the client's OS, not the server's OS.
September 13, 2005 at 7:40 pm
exec msdb..sp_start_job @job_name='job_name', @server_name='server_name'
August 10, 2005 at 1:25 pm
If you plan to install SQL Server 2000 SP4, don't forget to install the hotfix that addresses the AWE issue. See KB article 899761.
August 10, 2005 at 1:20 pm
I found out that you can download the Bulk Export Task from:
August 10, 2005 at 9:36 am
Are you sure the sp is not running ? are you using sp_who2 to check for process blocking itself ?
FYI, SP4 now checks blocking spid for latch wait in...
August 4, 2005 at 10:12 am
We don't use AWE. So that's not a problem for me. My concern is that I have seen users who have installed SP4 and are experiencing query performance issues. Is that...
August 4, 2005 at 9:24 am
Have you run CHECKDB ? If not, run it at non-business hours.
July 26, 2005 at 11:11 am
Thanks for taking the time to reply. I really appreciate it.
In my case, I'm just creating a local partitioned view. Do I still need to turn on XACT_ABORT SET ?
Thanks...Jimmy
July 25, 2005 at 3:04 pm
Viewing 15 posts - 31 through 45 (of 104 total)