Viewing 15 posts - 16 through 30 (of 38 total)
Hey this is what i get from sql server agent log
7/15/02 4:46:37 PM - ? [129] SQLServerAgent starting under Windows NT service control
7/15/02 4:46:37 PM - ! [298] SQLServer Error:...
July 15, 2002 at 3:11 pm
antares,
thank you very much buddy. without your help we would have been lost. I was able to create those missing indexes. now system is running very fast....
July 1, 2002 at 2:22 pm
ok This is what i see..can you tell me if you see anything unusual here?
StmtText ...
June 19, 2002 at 8:59 am
i did copy the query from the trace into QA and looks like its giving the same result, the query just keeps trying and trying with no result. What is...
June 18, 2002 at 6:47 pm
i have been using query analyzer extensively, so sorry about the previous question. What you are saying is, i should test the query and see where the problem is? I...
June 18, 2002 at 4:02 pm
I think the page file was very small. For instance our RAM size is 1GB but our Page file size was only 512MB. I have increased the page file on...
June 18, 2002 at 3:13 pm
Thanks for the prompt reply antares. This brings to my second question, how would i update table B with the data being updated on table A?
March 5, 2002 at 2:18 pm
I tried installing the Oracle 8.1 client to the SQL server NT box and configured the client to talk to the Oracle on the Unix box. Still it shows up...
February 19, 2002 at 1:39 pm
i think i have installed oracle 8.1 client. with sql*net i am able to connect to the database which is on a unix box and i am able to test...
February 19, 2002 at 12:59 pm
ok..now after i do all the steps mentioned by you. I go to enterprise manager in SQL server 7.0 and click on the linked server, it shows the tables icon....
February 19, 2002 at 11:44 am
this is the error message i am getting..
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: The Oracle(tm) client...
February 19, 2002 at 10:08 am
guys, i tried all the options....i did use the addlinkedserver and addlinkedsrvlogin stored procedures...still no luck...i am getting the same error...please advise...
February 19, 2002 at 9:24 am
steven, i was able to create the linked server using sp_addlinkedserver...however, what's the syntax for sp_addlinkedsrvlogin? i do not seem to get the syntax anywhere...also what registry key do i...
February 19, 2002 at 9:05 am
No one knows how to go about this? i have SQL*NET configured to the Oracle database on my PC. I want to know how to create the linked server?
February 19, 2002 at 8:14 am
Yes Antre, i wish to have Oracle database as a linked server in my SQL Server. How do i go about that?
February 14, 2002 at 11:15 am
Viewing 15 posts - 16 through 30 (of 38 total)