View SQLServer Linked Server Processes

FAQ

Profile

View SQLServer Linked Server Processes

Database Help (Home) -> Programming

Next: Error with Microsoft.SqlServer.BatchParser

Author

Message

Alan Z. Scharf

External

Since: Feb 03, 2007
Posts: 13

(Msg. 1) Posted: Wed Jan 24, 2007 2:43 am Post subject: View SQLServer Linked Server Processes Archived from groups: microsoft>public>sqlserver>programming (more info?)

Hi, Is there a way I can view SQLServer processing steps while it is connecting to a linked server? I'm trying to track down a problem of sporadically not connecting to Linked Server to Access mdb. Thanks. Alan. >> Stay informed about: View SQLServer Linked Server Processes

Uri Dimant

External

Since: Aug 24, 2003
Posts: 1744

(Msg. 2) Posted: Wed Jan 24, 2007 10:38 am Post subject: Re: View SQLServer Linked Server Processes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Alan No, bu can you tell us what is the error you are getting? "Alan Z. Scharf" wrote in message > Hi, > > Is there a way I can view SQLServer processing steps while it is > connecting to a linked server? > > I'm trying to track down a problem of sporadically not connecting to > Linked Server to Access mdb. > > Thanks. > > Alan. > >> Stay informed about: View SQLServer Linked Server Processes

Alan Z. Scharf

External

Since: Feb 03, 2007
Posts: 13

(Msg. 3) Posted: Wed Jan 24, 2007 10:38 am Post subject: Re: View SQLServer Linked Server Processes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Uri, 1. The error sent to me by client is below. I checked the Event ID in EventID.net, but couldn't really glean anything from that. 2. I believe there is a way to view the process, becausue I did it about a year ago per advice of someone else in this newsgroup. I had done this specifically to show an IT manager that SQLServer connected to a linked Access mdb server via IP. You could see that IP step in viewing the process trace. However, I forgot how to do this. I don't remember if it was a live viewer or some log. I can't find the methodology I used. Thanks again. Alan Got this in Event Viewer: Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 1/23/2007 Time: 11:03:41 AM User: PERMAL\JamesC Computer: PMLNYCSQL01 Description: Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 79 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 00 00 00 00 13 00 00 00 ........ 0008: 0c 00 00 00 50 00 4d 00 ....P.M. 0010: 4c 00 4e 00 59 00 43 00 L.N.Y.C. 0018: 53 00 51 00 4c 00 30 00 S.Q.L.0. 0020: 31 00 00 00 07 00 00 00 1....... 0028: 6d 00 61 00 73 00 74 00 m.a.s.t. 0030: 65 00 72 00 00 00 e.r... I'll Google this in the AM and see if there isn't "Uri Dimant" wrote in message > Alan > No, bu can you tell us what is the error you are getting? > > > > > "Alan Z. Scharf" wrote in message > >> Hi, >> >> Is there a way I can view SQLServer processing steps while it is >> connecting to a linked server? >> >> I'm trying to track down a problem of sporadically not connecting to >> Linked Server to Access mdb. >> >> Thanks. >> >> Alan. >> > > >> Stay informed about: View SQLServer Linked Server Processes

Uri Dimant

External

Since: Aug 24, 2003
Posts: 1744

(Msg. 4) Posted: Wed Jan 24, 2007 5:44 pm Post subject: Re: View SQLServer Linked Server Processes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Alan It could be result of SQL Server bugs. Maybe you should open a support call. How much memory do you have ? "Alan Z. Scharf" wrote in message > Uri, > > 1. The error sent to me by client is below. I checked the Event ID in > EventID.net, but couldn't really glean anything from that. > > 2. I believe there is a way to view the process, becausue I did it about a > year ago per advice of someone else in this newsgroup. > > I had done this specifically to show an IT manager that SQLServer > connected to a linked Access mdb server via IP. You could see that IP > step in viewing the process trace. > > However, I forgot how to do this. I don't remember if it was a live > viewer or some log. I can't find the methodology I used. > > > Thanks again. > > Alan > > > > > > Got this in Event Viewer: > Event Type: Error > Event Source: MSSQLSERVER > Event Category: (2) > Event ID: 17052 > Date: 1/23/2007 > Time: 11:03:41 AM > User: PERMAL\JamesC > Computer: PMLNYCSQL01 > Description: > Error: 0, Severity: 19, State: 0 > SqlDumpExceptionHandler: Process 79 generated fatal exception c0000005 > EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. > > For more information, see Help and Support Center at > http://go.microsoft.com/fwlink/events.asp. > Data: > 0000: 00 00 00 00 13 00 00 00 ........ > 0008: 0c 00 00 00 50 00 4d 00 ....P.M. > 0010: 4c 00 4e 00 59 00 43 00 L.N.Y.C. > 0018: 53 00 51 00 4c 00 30 00 S.Q.L.0. > 0020: 31 00 00 00 07 00 00 00 1....... > 0028: 6d 00 61 00 73 00 74 00 m.a.s.t. > 0030: 65 00 72 00 00 00 e.r... > > I'll Google this in the AM and see if there isn't > "Uri Dimant" wrote in message > >> Alan >> No, bu can you tell us what is the error you are getting? >> >> >> >> >> "Alan Z. Scharf" wrote in message >> >>> Hi, >>> >>> Is there a way I can view SQLServer processing steps while it is >>> connecting to a linked server? >>> >>> I'm trying to track down a problem of sporadically not connecting to >>> Linked Server to Access mdb. >>> >>> Thanks. >>> >>> Alan. >>> >> >> > > >> Stay informed about: View SQLServer Linked Server Processes

Alan Z. Scharf

External

Since: Feb 03, 2007
Posts: 13

(Msg. 5) Posted: Wed Jan 24, 2007 5:44 pm Post subject: Re: View SQLServer Linked Server Processes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Uri, About 2 gb. It seems its machine related because it's not happening on 2 other boxes with same linked server setup. Alan "Uri Dimant" wrote in message > Alan > It could be result of SQL Server bugs. Maybe you should open a support > call. > How much memory do you have ? > > > > > > "Alan Z. Scharf" wrote in message > >> Uri, >> >> 1. The error sent to me by client is below. I checked the Event ID in >> EventID.net, but couldn't really glean anything from that. >> >> 2. I believe there is a way to view the process, becausue I did it about >> a year ago per advice of someone else in this newsgroup. >> >> I had done this specifically to show an IT manager that SQLServer >> connected to a linked Access mdb server via IP. You could see that IP >> step in viewing the process trace. >> >> However, I forgot how to do this. I don't remember if it was a live >> viewer or some log. I can't find the methodology I used. >> >> >> Thanks again. >> >> Alan >> >> >> >> >> >> Got this in Event Viewer: >> Event Type: Error >> Event Source: MSSQLSERVER >> Event Category: (2) >> Event ID: 17052 >> Date: 1/23/2007 >> Time: 11:03:41 AM >> User: PERMAL\JamesC >> Computer: PMLNYCSQL01 >> Description: >> Error: 0, Severity: 19, State: 0 >> SqlDumpExceptionHandler: Process 79 generated fatal exception c0000005 >> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. >> >> For more information, see Help and Support Center at >> http://go.microsoft.com/fwlink/events.asp. >> Data: >> 0000: 00 00 00 00 13 00 00 00 ........ >> 0008: 0c 00 00 00 50 00 4d 00 ....P.M. >> 0010: 4c 00 4e 00 59 00 43 00 L.N.Y.C. >> 0018: 53 00 51 00 4c 00 30 00 S.Q.L.0. >> 0020: 31 00 00 00 07 00 00 00 1....... >> 0028: 6d 00 61 00 73 00 74 00 m.a.s.t. >> 0030: 65 00 72 00 00 00 e.r... >> >> I'll Google this in the AM and see if there isn't >> "Uri Dimant" wrote in message >> >>> Alan >>> No, bu can you tell us what is the error you are getting? >>> >>> >>> >>> >>> "Alan Z. Scharf" wrote in message >>> >>>> Hi, >>>> >>>> Is there a way I can view SQLServer processing steps while it is >>>> connecting to a linked server? >>>> >>>> I'm trying to track down a problem of sporadically not connecting to >>>> Linked Server to Access mdb. >>>> >>>> Thanks. >>>> >>>> Alan. >>>> >>> >>> >> >> > > >> Stay informed about: View SQLServer Linked Server Processes

Display posts from previous:

Related Topics:

SQL 2005 view based on linked server table can't be manual.. - Hi everyone! I have two SQL Server 2005, Server_A and Server_B. On Server_A, I created a linked server (Server_B). On Server_A, I created a view that looks like: CREATE VIEW [dbo].[vwTest] AS SELECT LastName, FirstName FROM ..

Sql smo server processes enumeration problem. - Need some help returning database name while using smo.server.EnumProcesses() on SQL Server 2005. The project is quite simple 1. connect to the server - using smo object. 2. check how many open connections exist on the x database and return the User,...

A problem with SQL Server Agent Jobs in SQLServer 2000 - This is a simple problem, I think, but it will take a while to explain, so bear with me ... I created a Database Maintenance Plan, which does a complete backup every night at midnight, and then deletes all the old backups. I don't keep multiple copies....

SQL Server View on two Database Server question - Hi, In my SQL Server 2000, I would like to create a VIEW across two databases on two database servers. How do I do that? Thanks for help. Jason

Linked server - HI, Is there a way to create a linked server to dbase files. I need to be able to import data from dbase files on a regular basis, once the data has been imported it then needs to go through a verification and transformation, then finally imported to th...

	Database Help (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum