Mobsync.exe Errors After Installing Sql Server Sp3a

Apr 28, 2004

Server : w2k server sp4
Tablet : w2k sp4
Sql Server 2000

A few days ago we upgraded our servers and tablet pc's with sql server sp3a. At the same time we also changed the publisher and it now uses a static filter to reduce the number of records in the tablet database. Since we have done this we have been getting an error message when we try to synchronize via the windows synchronization manager on our tablet pc's. The error message is "mobsync.exe has generated errors and will be closed by windows. You will need to restart the program. I looked up the error message and it is a stack overflow. This does not happen every time but about 50% of the time. We can always sync from within enterprise manager and everything works fine every time.

If any one has any ideas I would greatly appreciate it and thank you in advance.

View 3 Replies


ADVERTISEMENT

Installing SQL Server 2000 SP3a

Jul 9, 2007

I got this message from
Backup Exec for Windows Servers Environment Check 1.0 for SBS1
QUOTE

An instance of Microsoft SQL 2000 was found that is not updated to Service Pack 3a.

An instance of Microsoft SQL Server was found that is not updated to the correct service pack. Using this SQL Server instance with Backup Exec may cause errors. To install Backup Exec successfully, upgrade this SQL Server to Service Pack 3a, or select another instance.


Instance: SBSMONITORING, Version: 2000 SP 3a
Instance: SHAREPOINT, Version: 2000 SP 3a
Instance: BKUPEXEC, Version: 2000 SP 3a
Instance: PADMINISTRATOR, Version: 2000 SP 3a
Instance: MICROSOFT##SSEE, Version: 2000

UNQUOTE



My Question is how to upgrade the instance : "MICROSOFT##SSEE, Version: 2000" to SP 3a?

View 7 Replies View Related

Problems Installing MSDE Desktop SP3a SQL Server

Jul 29, 2005

Hi,I'm trying to install MSDE Desktop SP3a SQL server on my Windows 2000 Professional Laptop.Every time I try it nearly finishes the installation and then just rollsback.Can anyone help? Is this a known issue?Thanks in advance,Jocky

View 3 Replies View Related

Errors Installing SQL Server Express 2005

Feb 6, 2006

I've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops.
After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions.
I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example.
Thanks in advance for help any of you can suggest.
Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006Process ID      : 2036c:6645bd818fccc8ef0bad80e6a12f5bsetup.exe Version: 2005.90.1399.0Running: LoadResourcesAction at: 2006/1/5 23:48:6Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned trueRunning: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6Loaded DLL:c:6645bd818fccc8ef0bad80e6a12f5bxmlrw.dll Version:2.0.3604.0Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateWinNTAction at: 2006/1/5 23:48:8Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateMinOSAction at: 2006/1/5 23:48:8Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned trueRunning: PerformSCCAction at: 2006/1/5 23:48:8Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned trueRunning: ActivateLoggingAction at: 2006/1/5 23:48:8Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned trueRunning: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned trueAction "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.Running: PerformSCCAction2 at: 2006/1/5 23:48:8Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned trueRunning: PerformDotNetCheck at: 2006/1/5 23:48:9Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned trueRunning: ComponentUpdateAction at: 2006/1/5 23:48:9Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned trueRunning: DetectLocalBootstrapAction at: 2006/1/5 23:48:30Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned trueRunning: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30

View 1 Replies View Related

Errors After Installing Server 2000 DTS Designer Components

Jan 30, 2007

Hello,

After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:

"The procedure entry point
?ProcessExecute@@YAXPAUHWND_@@PBG1@Z could not be located in teh dynamic link library SEMSFC.dll."


Is there a way to fix so that I can open Enterprise manager?

Thanks!



View 9 Replies View Related

Errors Installing MSDE Desktop

Nov 7, 2004

HELP! this is driving me mad!!

I installed MSDE desktop with no problems... months later when creating a database, I stupidily forgot the "sa" password that I set during setup... So I decided to unistall MSDE and reinstall it, this time documenting the username and password... BUT now it is giving me errors which I am unable to solve... is there anyone out there that might be able to help me??

I go to a command-line, locate the directory where the install program lives and type in "setup SAPWD=(a password) SecurityMode=SQL" and it returns the follow error message:
"Setup Failed to configure the server. Refer to the server error logs and setup error logs"

My problem is I don't know where to locate these error logs. Please if anyone can help me with this problem I would greatly appreciate it.

thanks, Donald - email = pizzazzz@cox.net

View 1 Replies View Related

Errors Installing SQL 2005 Beta 2 Sept 05

Sep 28, 2005

I'm getting this error:

View 4 Replies View Related

SQL Server 2000 SP3a

Sep 16, 2004

Hi, I've downloaded the SP3a for sql server from the microsoft website. I unpackaged the files into a folder and ran the file setup.bat. I recieved an error that setupsql.exe file was not found. I think theres a folder missing called Setup under the X86 folder. Is there a way I can fix this????????

View 1 Replies View Related

Memory Leak. SQL Server Sp3a, VB And MDAC 2.8

Jul 20, 2005

Can anyone give me some sugguestions here.Connection is declared at the start of the applicationSet rsFZReport.ActiveConnection = connThen a function repeatly opens recordsets like this -rsFZReport.Open sRS, , adOpenStatic, adLockReadOnly, adCmdText....reporting code etc...If rsFZReport.State > 0 ThenrsFZReport.CloseSet rsFZReport= NothingendifUsing VB Watch debugger, the close and set nothing do NOT release anymemory. It just keeps increasing. The application connects to multipledatabases and many tables, so its uses about 10Mb/minute.(I don't think its of relavance but Form.show uses memory but form.unloaddoesn't release any back)I've installed SP3a and MDAC 2.8 to no avail. Anyone have any ideas or knowwhat I can do?msado27.tlb 2.80.1022.0MSSQL Server SP3a (3 has a memory leak apparently)VB6, SP6Sqlsrv32.dll caused a leak on NT4 SP6, but upgrading it on my win2k SP4server/workstation (they are both and the same) to thisSqlsrv32.dll 2000.85.1022.0doesn't help.Provider=SQLOLEDB;Data Source=theServer;Initial Catalog=theDB;UserID=uid;Password=thepwd;OPTION=3;connect timeout=240;

View 5 Replies View Related

Problems With Merge Rep After Upgrading From Sql Server 2000 Sp3a To Sql Server 2005 Build 2153

Mar 6, 2007

Hi,

We just upgraded 2 sql servers from sql server 2000 sp3a to sql server 2005 build 2153, and merge rep exists between these 2 servers.

However, after sql server upgrade, we had to reinitialize merge replication and now the merge agent is reporting 2 errors

1)

Error messages:


The Merge Agent failed to upgrade triggers, metadata and stored procedures on the Subscriber to versions compatible with SQL Server 2005. Restart synchronization, and if this failure continues to occur reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199403)
Get help: http://help/MSSQL_REPL-2147199403

Invalid column name 'metadata_select_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207

Invalid column name 'delete_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207

2)

Command attempted:


{call sp_MSensure_single_instance (N'Merge Agent Name', 4)}

Error messages:


The merge process could not connect to the Publisher 'Server:database'. Check to ensure that the server is running. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199368)
Get help: http://help/MSSQL_REPL-2147199368

Another merge agent for the subscription(s) is running or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)
Get help: http://help/21036

looking inside the sp_MSensure_single_instance stored procedure, it's trying to obtain an exclusive lock on resource 'Merge Agent Name' but fails and returns -1

this is the stored procedure executed by sp_MSensure_single_instance and @retcode = -1 and thus cannot obtain exclusive lock on resource

EXEC @retcode = sys.sp_getapplock @Resource = 'Merge Agent Name',

@LockMode = 'Exclusive',

@LockOwner = 'Session',

@LockTimeout = 0,

@DbPrincipal = 'MSmerge_PAL_role'

so i think it's failing because for some reason MSmerge_PAL_role database role does not have enough rights to obtain exclusive lock on necessary resources

i've tried many things to fix this, including scripting out and dropping all merge rep, turning off replication db option and reapplying replication create scripts on the server, and even manually deleting the MSmerge_PAL_role database role but still doesn't work

can anyone help?

Thanks

View 9 Replies View Related

Msmq Missing Messages After Applying SP3a To SQL Server

Jan 12, 2004

Used to work fine:
(windows 200 server, sql server 2000, JDBC driver SP2.)
Two java processes, one sending messages (using jdbc and sql as temp storage), second is receiving and placing on msmq.

After installing SP3a for SQL server, under high load (200 a sec) there are missing messages in msmq.
Installed everything from scratch on separate machine, works fine until SP3a is applied.
Any help is highly appreciated

View 3 Replies View Related

Help Me! My Mssql 2000 Server (with Sp3a) Is Keeping Full Loading My Cpu Non-stop Now!

Dec 8, 2004

my mssql never be used much
and i had a firewall to blocked the port of mssql to internet

but i don't that why tonight the sql server non-stop keep full loading the cpu suddenly until now!
please help me

View 3 Replies View Related

Cant Use ODBC Data Source On SQL SERver 2000 Sp3a Named Instance

Jul 23, 2005

Here's my situation:I have an ODBC DSN setup for Timberline Data (An accounting packagethat uses pervasive.sql) on my sql box. I set up a linked server usingthe supplied timberline odbc driver. I have two sql instances setup,the default instance and a named instance. On the default instance,the linked server works great no matter who is logged in using it (allauthentication is NT integrated). However on the named instance onlythe NT account that the MSSqlserver$NAMED service is logged in undercan utilize the linked server. All others get a ODBC error:"error 7399: OLE DB Provider 'MSDASQL' reported an error. AccessDenied. OLE DB error trace [OLE/DB Provider 'MSDASQL'IUnknown::QueryInterface returned 0x80070005: Access Denied.]."Far as i can tell, both instances are setup the same, except that oneis the default and one is a named instance.Why the different results for the default instance vs a named instance.Any ideas?Thanks

View 5 Replies View Related

SQL Server 2008 :: How To Make Sproc Return Errors For Underlying Table Errors

Jul 1, 2015

I recently updated the datatype of a sproc parameter from bit to tinyint. When I executed the sproc with the updated parameters the sproc appeared to succeed and returned "1 row(s) affected" in the console. However, the update triggered by the sproc did not actually work.

The table column was a bit which only allows 0 or 1 and the sproc was passing a value of 2 so the table was rejecting this value. However, the sproc did not return an error and appeared to return success. So is there a way to configure the database or sproc to return an error message when this type of error occurs?

View 1 Replies View Related

Installing MSDTC Resource After Installing SQL Server 2000 Cluster

Oct 19, 2006

Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?

When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.

Thanks in advance for any help. I would really like to avoid rebuilding again.



Andy

View 1 Replies View Related

Installing SQL Server Standard Edition 2005 After Installing SQL Server Express 2005

Feb 14, 2007

Hi

I have installed SQL Server Express 2005 on my machine.

I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.

Can these 2 Editions coexist with each other, or any troubles you think might encounter?

Thanks

View 5 Replies View Related

Update To Sp3a

Jan 23, 2004

I'm trying to upgrade my MSDE to sp3a, I'm following the instructions.

c:sql2ksp3MSDE

setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=1

But receive the following message:

Invalid product code was found. Check if product is installed.

Then

Could not find package to install on the installation media.

Any help?

Thank you.

View 3 Replies View Related

Sql 2000 Sp3a

Aug 5, 2003

Select @@version does not know the difference between SP3 and SP3A.

Does anyone know of a SQL statement that will let me know if I have SP3A??

Thanks.

View 5 Replies View Related

Cannot Get SP3a To Install

Jun 24, 2004

We have the rtm version of SQL 2000 and have spent the last 2.5 hours trying to apply SP3a. Nothing on the microsoft support site has pointed us to the solution.

Basically, we start the install after shutting down the services, answer all the questions and then when it starts to copy files it fails with an error
'microsoft data access component failed (-1).

Looking in c:winntdatestup.log, the error is unknown. The c:winntsqlsrp.log file is not touched.

We tried renaming the odbcconf.dll file per a microsoft article and no joy.

We also restored mdac_type.exe file per microsoft article and no joy.

Trying to install SP1 and SP2 - same results.

Anyone got any ideas besides it's time to call Microsoft?
:confused:

View 2 Replies View Related

Sp3a Does Not Seem To Apply

Feb 26, 2004

I am trying to install sql server sp3a. I checked the version before and after the sp is applied, and it shows:

8.00.194

Now, according to the sp3a readme:

http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp

the following versions should show:

SQL Server 2000 Original Release 8.00.194 RTM
Database Components SP1 or Desktop Engine SP1 8.00.384 SP1
Database Components SP2 or Desktop Engine SP2 8.00.534 SP2
Database Components SP3 or SP3a, or Desktop Engine SP3 or SP3a 8.00.760 SP3

This would imply that after installing sp3a and restarting, the version reported should now be 8.00.760. However, it still shows 8.00.194. So it appears to have not really installed, althought the sp3a installation ran without incident. So, how can I get the sp3a to not just act like it installed, but actually get it to install? Also, I have shut down all mssql services and rebooted, applied patch, and rebooted again. Doesn't help.
Also, if it is really installing, is there another way to tell?

Anyway, I really need to be able to install sp3a to see if it fixes another problem I'm having. Unfortunetly, since I can't even tell if the sp3a is installing, I can't tell if it really doesn't help or not. Thanks.

Tony F

View 2 Replies View Related

SP3a Installs SP1

Oct 20, 2005

I really don't understand this, in an attempt to upgrade/install SP3a, I download the file sql2kdesksp3.exe, which from the documentation, you can either use for upgrading or new installs. I run a new install; in the new instance, I execute "select @@version" and get "Service Pack 1"??

View 8 Replies View Related

SQL 2000 SP3a To SP4

Apr 30, 2008



Our environment is currently running on SQL 2000 sp3a (win2003) and I'm having an issue with 'max worker threads', so I opened a ticket with Microsoft.
They tell me that SP3a is no longer support and I have to upgrade all our servers to SP4.

We had an issue in my previous company and I was told by a consultant that I shouldn't install SP4 because it caused a lot of issues. I'm aware of the 'AWE enabled' issue, are there any others I should watch out for?

Thanks

View 2 Replies View Related

Error On Sp3a URGENT HELP !!

Jul 9, 2004

After past MDAC it fails running 1st script with error sp3_serv_uni.SQL(1) PLEASE HELP

View 2 Replies View Related

Restore System Dbs From SP3 To SP3a?

Jan 14, 2005

Can system databases (master, model, msdb) backed up from SQL2k SP3 be restored to an instance of SP3a? Can they be restored from SP3a to SP3? TIA!

View 4 Replies View Related

SP3a Support And MSDE

Aug 21, 2007

Hi

Now that support for SQL SP3a has been removed, how does this affect MSDE installations? We've got lots of products installed that have come with MSDE backends, all on SP3a. Is it up to the individual vendors as to whether they continue to support on this version? Backup Exec and Insight Manager are 2 that spring to mind.

thanks

View 1 Replies View Related

Upgrade MSDE With SP3a With SP4

Jun 1, 2006

Hi,
I'm trying to upgrade MSDE with SP4.
I used the following in command prompt.
setup /upgradesp sqlrun INSTANCENAME=MSDEINSTANCE SECURITYMODE=SQL UPGRADEUSER=username UPGRADEPWD=userpassword /L*v C:MSDELog.log
i got the message "Please go the control panel to install and configure system components."
What does it mean?
How to upgrade it?I have tried to edit the line with *V, and using the sa username and password, but i get the same message.
RegardsKenneth Davidsen

View 1 Replies View Related

Installing IIS After Installing SQL Server 2005 And Visual Studio 2005 Help Requested!

Aug 31, 2007

Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.

My situation:

My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.

So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.

The server is not connected to any network or the internet.

My Question:

Is their any way to fix this? and if yes could anyone tell me where to start


Thanks in Advance!

ps if their is information or logs that u need in order to help me just say so :-)


-Arjan

View 1 Replies View Related

Does The MSDE2000 Sp3a Come With Northwind Database

Jan 30, 2004

I just downloaded and installed MSDE2000 sp3a for winform and asp.net
quickstart tutorial. But I found it has no sample database such as pubs
and northwind. It used to have these databases. At least in last September
when .Net web Matrix came out.

If this is the case, can someone tell me where to get the sql scripts
to create Northwind database in MSDE?
Becasue the winform tutorial uses this database.

Thanks in advance!

Lei Xu

View 1 Replies View Related

MSDE SP3a Upgrade Problem

Jun 14, 2004

I just upgraded my desktop engine MSDE 1.0 to MSDE 2000 SP3a. Everything seemed to go well, MSSQLSERVER AND SQLSERVER Agent Services are running, problem is, I can no longer see the particular instance on the network from Enterprise Manager.

The installation instructions specified that if the Instance was to accept connections from applications on other computers not to specify the DISABLENETWORKPROTOCOLS parameter, so I didn't.

I'm a little green with this, can anyone suggest a place to start troubleshooting?

View 1 Replies View Related

SP3a And Strong Password Problem

Jul 23, 2005

I urgently need tom use SP3a upgrade the instance of SQLServer200MSDE runing on my local machine but I am having problems in doing so.My first problem is that when I start the set up procedure I get themessage"A strong SA password is required for security reasons. Please useSAPWD switch to supply the same"Currently the sa password isAbc/def/ghk1Which I think is a 'strong password' according to the microsoft rulesathttp://www.microsoft.com/resources/...sword_tips.mspxI would be grateful if someone could confirm that Abc/def/ghk1 is astrong password.If anyone could point me to some published informal help on installingSP3a then that would also be very helpful (I do of course have the MSread me file). If anyone has a sample command line entry for theupdating then I would find that extremely useful. There is oneinstance of MSDE on my machine, named NetSDK.Best wishes, John Morgan

View 6 Replies View Related

SQL Fails After SP3a Has Been Applied. Slammer?

Jul 23, 2005

A Win2k, SQL2k machine with SP2 that only just now has been updated to SP3afails in different ways. Among other things, when I now start EnterpriseManager, I get a message saying "rebbrui.rll" is missing and the snap-infails to initiate. But then the Manager starts anyway.But the SQL application does not work. I searched around the net, and Ifound that it looks as if SQL Slammer has been on the server. I can tell bythe similar symptoms other users have had, allthough I am not sure. Anyway,when I run some online virusscans and the Symantec SQLexp-tool to removeSlammer, I am told that the system is virusfree. Is that because SP3a toSQL2000 automatically got rid of the virus (if any)?But how do I get the SQL to run without any errors again?The server also runs in Terminal Application Mode.Regards, Lars.

View 4 Replies View Related

SP3a Installation- Cannot Find Setupsql.exe

Jul 20, 2005

current config: Windows XP SP1, SQL Server 2000trying to install : SP3a on SQL Server 20001. I downloaded the three files of the service pack from(http://www.microsoft.com/downloads/...&displaylang=en)..2. Saved the three files to a same local directory d:sqlsvr3a.3. Click through each and extracted them to same local directoryd:sql2ksp33. when I try to run the d:sql2ksp3setup.bat, it tells me thatx86setupsetupsql.exe is not found. Indeed, the file is not there inthe extracted folders.Is this a common problem, or am I missing something ?-thanks

View 1 Replies View Related

SP3a + Extended Procedures = Not Nice (help!)

Jul 20, 2005

Hi(sorry this has turned into a bit of an epic...thought I'd as theexperts!)SQL 2k, sp3a. Dual xeon 2.4. 2 gig ram. everything on a 3 disk raid 5.Microsoft SQL Server 2000 - 8.00.760 (Intel X86)Enterprise Edition on Windows NT 5.0 (Build 2195: )Problem seems to be some extended procs that seemed to be running fineon a 'vanilla' install on a different server now seem to be failing.Failures occuring c 6 - 10 hours.Sometimes the failure logs as the xp failure with severity 20 that Ikindof expect :s. other times absolutely nothing is logged.There are a variety of error messages - or sometimes nothing at all.http://www.mapinfo.com/common/docs/.../SWMSS48_RN.pdfdescribes one of our issues, which seems to come out on the restartafter a failure:Error event id is 19011, Message "SuperSocket info:ConnectionListen(Shared-Memory (LPC)) : Error 5."That site suggests:[color=blue]>Workaround>Suggested solutions include:>• Obtain a hotfix from Microsoft (http://www.microsoft.com). You will[/color]need to >cite the 94302[color=blue]>reference number.>• Turn off shared memory in the client network configuration utility[/color]to >disable shared[color=blue]>memory.>• Replace the SQL Server SSMSLPCN.DLL with the SSMSLPCN.DLL[/color](8.00.540) from >SQL[color=blue]>Server 2000 Service Pack 2.[/color]- but I cant find any sensible information which describes this tocorrelate! Searching MS for that number (94302) came up with zip.The dll version we are running is 2000.80.760.0, although earlierversions are elsewhere on the server (disk images).Interesting to note that we seem to be able to replicate the 'leakage'of improperly closed handles on this version, but not on the oldserver runningthat dll version 2000.80.194.0. This I understood to have been fixedin sp3.On one failure we caught the following (involving our extended procs):2004-02-15 15:03:31.40 spid58 Error: 0, Severity: 20, State: 02004-02-15 15:03:31.40 spid58 Stored function'xp_Contest_CalculateScores' in the library 'e:sqlxpga_procs.dll'generated an access violation. SQL Server is terminating process 58..2004-02-15 15:04:32.14 spid64 Error: 0, Severity: 20, State: 02004-02-15 15:04:32.14 spid64 Stored function 'xp_XML_GetSubTree'in the library 'e:sqlxpga_procs.dll' generated an access violation.SQL Server is terminating process 64..2004-02-15 15:04:48.48 spid53 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 53, PSS = 0x472d7200, EC = 0x725fc098*Stack Dump being sent to e:sqlMSSQLlogSQLDump0001.txt* ************************************************** ******************************* BEGIN STACK DUMP:* 02/15/04 15:04:48 spid 53This was followed about a minute later by:2004-02-15 15:04:55.75 spid53 Stack Signature for the dump is0x1CC032652004-02-15 15:04:55.75 spid53 SQL Server Assertion: File:<recbase.cpp>, line=1378Failed Assertion = 'm_offBeginVar < m_SizeRec'.2004-02-15 15:04:55.89 spid53 Using 'dbghelp.dll' version '4.0.5'*Stack Dump being sent to e:sqlMSSQLlogSQLDump0002.txt2004-02-15 15:04:56.01 spid53 SqlDumpExceptionHandler: Process 2292generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQLServer is terminating this process.* ************************************************** ******************************* BEGIN STACK DUMP:* 02/15/04 15:04:55 spid 53As a side issue we have a number of 'initialisation of notify failed'notes.Any one have any clue about this?Might the DLL need rolling back?Is sp3a knacked for extended procs?Is there some daft setting I've missed :/Any good events to track in particular?Cheers all!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved