\Backup directories - remove safely?

I've successfully applied SP4 to an MSDE 2000 installation on a
Windows 2000 Professional system. Now I've notived several \Backup
subdirectories in the "Microsoft SLQ Server" directory. Since I don't
want to go back to any previous version, these subdirectories appear
to be no longer required. May I safely remove them?
Heinz Wehner
(Karlsruhe, Germany)
Hi,
No problems. You can delete that directory.
Thanks
Hari
SQL Server MVP
"Heinz Wehner" <hwehner@.hotmail.com> wrote in message
news:c215e1ppe9k9vqim24ckphf0eukkgr6n5a@.4ax.com...
> I've successfully applied SP4 to an MSDE 2000 installation on a
> Windows 2000 Professional system. Now I've notived several \Backup
> subdirectories in the "Microsoft SLQ Server" directory. Since I don't
> want to go back to any previous version, these subdirectories appear
> to be no longer required. May I safely remove them?
> Heinz Wehner
> (Karlsruhe, Germany)
|||Thanks Hari.

> On Sun, 24 Jul 2005 19:32:03 +0530,
> Hari Prasad <hari_prasad_k@.hotmail.com> wrote:
> Hi,
> No problems. You can delete that directory.
> Thanks
> Hari
> SQL Server MVP
>
> Heinz Wehner <hwehner@.hotmail.com>
> wrote in message news:c215e1ppe9k9vqim24ckphf0eukkgr6n5a@.4ax.com...
> I've successfully applied SP4 to an MSDE 2000 installation on a
> Windows 2000 Professional system. Now I've notived several \Backup
> subdirectories in the "Microsoft SLQ Server" directory. Since I don't
> want to go back to any previous version, these subdirectories appear
> to be no longer required. May I safely remove them?
> Heinz Wehner
> (Karlsruhe, Germany)
sql

[WORKED] MSDE sp4 installation+osql connect

ok yesterday i crunched my head against the wall, after trying MSDE
installation (MSDE rel.A and MSDE SP4) on a brand new WXPPSP2 laptop.
Today it worked, in this way:
#Prerequisites
1.removed any MSDE installation (control panel > Remove Applications)
2.removed any MSDE directory (eg. "C:\programmi\Microsoft SQL Server") and
subdirs
3.removed any MSSQL regKey (Regedit.exe > HKLM\Software\Microsoft, keys
named "Microsoft SQL Server" or "MSDE", i browsed by intuition)
#Installation
i used following installation parameters:
BLANKSAPWD=1 (testing purposes only, next i'll check SAPWD="strongpwd")
INSTANCENAME ="theinstance"
DATADIR = "c:\Program Files\Microsoft SQL Server\MSSQL$theinstance\data\"
(notice the final backslash)
/L*v "C:\msde.log"
#Connection
$ osql -S (local)\theinstance -E
using -U sa with no input as password i get the error "Access denied for
"sa" user. Reason: not associated with a trusted SQL Server connection"
since i installed with blank sa pwd. (In theory sa should gain access with
no password specified)
actually, if you install MSDE without specificating the authentication mode,
the installation sets the login authentication to Windows authentication
mode, not the integrated one, hence you cannot access with builtin users
login.
See http://support.microsoft.com/default...;EN-US;Q285097
for further infos.

> #Connection
> $ osql -S (local)\theinstance -E
> using -U sa with no input as password i get the error "Access denied for
> "sa" user. Reason: not associated with a trusted SQL Server connection"
> since i installed with blank sa pwd. (In theory sa should gain access with
> no password specified)

[TCP/IP Sockets]ConnectionCheckForData()) Error

Error was returned when we compiled a proc. The proc compiles under SP3a.
We're using Standard Edition SP4.
The offending statement is a sub-select in a where clause that uses a union:
and mv.INSTR_ID in
(
select @.INSTR_ID
union
select ridf.INSTR_ID
from FT_T_RIDF ridf
join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
where ridf.REL_TYP = 'OPTION'
)change to:
( select @.INSTR_ID AS [ID]
union
select ridf.INSTR_ID
from FT_T_RIDF ridf
join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
where ridf.REL_TYP = 'OPTION'
)
--
-oj
"davidhg" <davidhg@.discussions.microsoft.com> wrote in message
news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
> Error was returned when we compiled a proc. The proc compiles under SP3a.
> We're using Standard Edition SP4.
> The offending statement is a sub-select in a where clause that uses a
> union:
> and mv.INSTR_ID in
> (
> select @.INSTR_ID
> union
> select ridf.INSTR_ID
> from FT_T_RIDF ridf
> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> where ridf.REL_TYP = 'OPTION'
> )
>|||Hi oj,
Unfortunately, the error still occurs. To compile the proc, we created a
pseudo-talbe from the sub-select with the union statement and joined it
directly to the other tables. FYI, I opened a case with MS.
--
Dave
"oj" wrote:
> change to:
> ( select @.INSTR_ID AS [ID]
> union
> select ridf.INSTR_ID
> from FT_T_RIDF ridf
> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> where ridf.REL_TYP = 'OPTION'
> )
> --
> -oj
>
> "davidhg" <davidhg@.discussions.microsoft.com> wrote in message
> news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
> > Error was returned when we compiled a proc. The proc compiles under SP3a.
> > We're using Standard Edition SP4.
> >
> > The offending statement is a sub-select in a where clause that uses a
> > union:
> > and mv.INSTR_ID in
> > (
> > select @.INSTR_ID
> > union
> > select ridf.INSTR_ID
> > from FT_T_RIDF ridf
> > join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> > and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> > where ridf.REL_TYP = 'OPTION'
> > )
> >
> >
>
>|||Okay. Without seeing the *whole* thing I'm not sure what would be the case.
The syntax looks right to me.
Do post back if you hear anything.
--
-oj
"davidhg" <davidhg@.discussions.microsoft.com> wrote in message
news:21FFCFE8-EED9-47FA-821C-AE224C630FDC@.microsoft.com...
> Hi oj,
> Unfortunately, the error still occurs. To compile the proc, we created a
> pseudo-talbe from the sub-select with the union statement and joined it
> directly to the other tables. FYI, I opened a case with MS.
> --
> Dave
>
> "oj" wrote:
>> change to:
>> ( select @.INSTR_ID AS [ID]
>> union
>> select ridf.INSTR_ID
>> from FT_T_RIDF ridf
>> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
>> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
>> where ridf.REL_TYP = 'OPTION'
>> )
>> --
>> -oj
>>
>> "davidhg" <davidhg@.discussions.microsoft.com> wrote in message
>> news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
>> > Error was returned when we compiled a proc. The proc compiles under
>> > SP3a.
>> > We're using Standard Edition SP4.
>> >
>> > The offending statement is a sub-select in a where clause that uses a
>> > union:
>> > and mv.INSTR_ID in
>> > (
>> > select @.INSTR_ID
>> > union
>> > select ridf.INSTR_ID
>> > from FT_T_RIDF ridf
>> > join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
>> > and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
>> > where ridf.REL_TYP = 'OPTION'
>> > )
>> >
>> >
>>sql

[TCP/IP Sockets]ConnectionCheckForData()) Error

Error was returned when we compiled a proc. The proc compiles under SP3a.
We're using Standard Edition SP4.
The offending statement is a sub-select in a where clause that uses a union:
and mv.INSTR_ID in
(
select @.INSTR_ID
union
select ridf.INSTR_ID
from FT_T_RIDF ridf
join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
where ridf.REL_TYP = 'OPTION'
)change to:
( select @.INSTR_ID AS [ID]
union
select ridf.INSTR_ID
from FT_T_RIDF ridf
join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
where ridf.REL_TYP = 'OPTION'
)
-oj
"davidhg" <davidhg@.discussions.microsoft.com> wrote in message
news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
> Error was returned when we compiled a proc. The proc compiles under SP3a.
> We're using Standard Edition SP4.
> The offending statement is a sub-select in a where clause that uses a
> union:
> and mv.INSTR_ID in
> (
> select @.INSTR_ID
> union
> select ridf.INSTR_ID
> from FT_T_RIDF ridf
> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> where ridf.REL_TYP = 'OPTION'
> )
>|||Hi oj,
Unfortunately, the error still occurs. To compile the proc, we created a
pseudo-talbe from the sub-select with the union statement and joined it
directly to the other tables. FYI, I opened a case with MS.
--
Dave
"oj" wrote:

> change to:
> ( select @.INSTR_ID AS [ID]
> union
> select ridf.INSTR_ID
> from FT_T_RIDF ridf
> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> where ridf.REL_TYP = 'OPTION'
> )
> --
> -oj
>
> "davidhg" <davidhg@.discussions.microsoft.com> wrote in message
> news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
>
>|||Okay. Without seeing the *whole* thing I'm not sure what would be the case.
The syntax looks right to me.
Do post back if you hear anything.
-oj
"davidhg" <davidhg@.discussions.microsoft.com> wrote in message
news:21FFCFE8-EED9-47FA-821C-AE224C630FDC@.microsoft.com...[vbcol=seagreen]
> Hi oj,
> Unfortunately, the error still occurs. To compile the proc, we created a
> pseudo-talbe from the sub-select with the union statement and joined it
> directly to the other tables. FYI, I opened a case with MS.
> --
> Dave
>
> "oj" wrote:
>

[TCP/IP Sockets]ConnectionCheckForData()) Error

Error was returned when we compiled a proc. The proc compiles under SP3a.
We're using Standard Edition SP4.
The offending statement is a sub-select in a where clause that uses a union:
and mv.INSTR_ID in
(
select @.INSTR_ID
union
select ridf.INSTR_ID
from FT_T_RIDF ridf
join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
where ridf.REL_TYP = 'OPTION'
)
change to:
( select @.INSTR_ID AS [ID]
union
select ridf.INSTR_ID
from FT_T_RIDF ridf
join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
where ridf.REL_TYP = 'OPTION'
)
-oj
"davidhg" <davidhg@.discussions.microsoft.com> wrote in message
news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
> Error was returned when we compiled a proc. The proc compiles under SP3a.
> We're using Standard Edition SP4.
> The offending statement is a sub-select in a where clause that uses a
> union:
> and mv.INSTR_ID in
> (
> select @.INSTR_ID
> union
> select ridf.INSTR_ID
> from FT_T_RIDF ridf
> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> where ridf.REL_TYP = 'OPTION'
> )
>
|||Hi oj,
Unfortunately, the error still occurs. To compile the proc, we created a
pseudo-talbe from the sub-select with the union statement and joined it
directly to the other tables. FYI, I opened a case with MS.
Dave
"oj" wrote:

> change to:
> ( select @.INSTR_ID AS [ID]
> union
> select ridf.INSTR_ID
> from FT_T_RIDF ridf
> join FT_T_RISS riss on riss.RLD_ISS_FEAT_ID = ridf.RLD_ISS_FEAT_ID
> and riss.PART_UNITS_TYP = 'Option' and riss.INSTR_ID = @.INSTR_ID
> where ridf.REL_TYP = 'OPTION'
> )
> --
> -oj
>
> "davidhg" <davidhg@.discussions.microsoft.com> wrote in message
> news:3255283F-3B9E-435B-BFC4-51CF9B5069BD@.microsoft.com...
>
>
|||Okay. Without seeing the *whole* thing I'm not sure what would be the case.
The syntax looks right to me.
Do post back if you hear anything.
-oj
"davidhg" <davidhg@.discussions.microsoft.com> wrote in message
news:21FFCFE8-EED9-47FA-821C-AE224C630FDC@.microsoft.com...[vbcol=seagreen]
> Hi oj,
> Unfortunately, the error still occurs. To compile the proc, we created a
> pseudo-talbe from the sub-select with the union statement and joined it
> directly to the other tables. FYI, I opened a case with MS.
> --
> Dave
>
> "oj" wrote:

[strange] date format issue: 2 servers, one query, 2 different results.

I'm running 2 WIN2K SP4 servers with MSSQL Server (v 7.00.1077). Both NT servers seems to have the same setup. I use the ADODB object to connect to MSSQL via OLE DB and notice that the following query generates an error on one server, not the other:

SELECT DATA FROM TABLE_1 WHERE ((TRANSACTION_DATE >='13/11/2003') AND (TRANSACTIONS_DATE <='20/11/2003')) [dates are DD/MM/YYYY]

Query on server_1:
- using OLE DB: correct
- using ODBC: correct
- using Query Analyzer: error <The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value>

On server_2:
- using OLE DB: error <The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value>
- using ODBC: correct
- using Query Analyzer: error <The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value>

Both servers have MDAC 2.8 RTM installed and a <select @.@.language> returns <us_english> via query analyzer and <franais> via ODBC.

I'd like to setup Server 2 so that queries can be executed the same as on server 1.

Any ideas are welcomed!There's a problem with 20/11/2003 in us_english format. Default is: MDY, so it's reading 20th as month, which is why you're getting that error.

Here's an article I found: http://members.lycos.nl/digispy/C2/P56/C2P56A1806.htm

G'luck!
Meera|||Possible there is something to do with locale settings of windows, check the "Region Options" in Control Panel for both servers.|||I'd say the languages are different...and accordingingly each date format is different

Di SELECT * FROM master..syslanguages

I think English is the only one that mdy|||(D/M/Y is a French date format).

I just had to set <French> to user's default language instead of <US_ENGLISH>. This means ODBC settings override the default SQL Server settings as OLE DB uses the default SQL Server setting.sql

[Q]Problems related to the MySQL linked Server.

Dear everyone.
I have two questions about the linked server for the MySQL.
I need to connect to the mysql DB from the my SQLServer 2000 SP4 on the
Windows 2000 standard Edition(MDAC 2.8)
So, I made a linked server at the SQLServer. I worked well, but I faced with
some problem.
1. Query method
I need to query some data in the mysql with dynamic parameter.
ex) select @.v_intUserNo = uno
from tb_test
where userid = 'testid'
*input of the userid is changed everytime by the user.
so, I cannot use the OPENQUERY or OPENROWSET.
I want to query above like this,
select @.v_intUserNo = uno
from [linked server name].[catalog name].[schema name].[ta
ble name]
where userid = 'testid'
When I used above syntax at the linked server of the SQLServer, it worked
well.
But, it did not worked with the mysql DB.
(unfortunately, I cannot remember the exact error message.T.T)
2. Not killable SPID.
After #1 step, I tried many method to solve the problem.
As one trial, I set the catalog at the linked server's property.
After that, I tried query as followings
---
select @.v_intUserNo = uno
from [linked server name].[catalog name].[schema name].[ta
ble name]
where userid = 'testid'
or select @.v_intUserNo = uno
from OPENQUERY('TEST_DB', 'select * from test_tbl where userid =
''testid''')
---
It doesn't returned any error or result, so, I killed the session.
but it was not cleared promptly, only return the following message.
SPID 70: transaction rollback in progress. Estimated rollback completion:
100%. Estimated time remaining: 0 seconds.
After restarting the SQLServer, they were cleared.
I wish to know the all the experiencies for managing the linked server to
the mysql DB at the SQLServer.
Thank you in advanceFurther information of my environment.
1. I used the mysql ODBC Ver 3.51
2. The error messge when I query data with following SQL.
select @.v_intUserNo = uno
from [linked server name].[catalog name].[schema name].[ta
ble name]
where userid = 'testid'
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
**Following query also doesn't work.
select @.v_intUserNo = uno
from [linked server name].[catalog name].[table name]
where userid = 'testid'
select @.v_intUserNo = uno
from [linked server name].[schema name].[table name]
where userid = 'testid'
select @.v_intUserNo = uno
from [linked server name].[table name]
where userid = 'testid'
Thank you.
"?" <dialup@.nownuri.net> wrote in message
news:ObJWtpObGHA.3992@.TK2MSFTNGP05.phx.gbl...
> Dear everyone.
> I have two questions about the linked server for the MySQL.
> I need to connect to the mysql DB from the my SQLServer 2000 SP4 on the
> Windows 2000 standard Edition(MDAC 2.8)
> So, I made a linked server at the SQLServer. I worked well, but I faced
with
> some problem.
> 1. Query method
> I need to query some data in the mysql with dynamic parameter.
> ex) select @.v_intUserNo = uno
> from tb_test
> where userid = 'testid'
> *input of the userid is changed everytime by the user.
> so, I cannot use the OPENQUERY or OPENROWSET.
> I want to query above like this,
> select @.v_intUserNo = uno
> from [linked server name].[catalog name].[schema name].[
table name]
> where userid = 'testid'
> When I used above syntax at the linked server of the SQLServer, it worked
> well.
> But, it did not worked with the mysql DB.
> (unfortunately, I cannot remember the exact error message.T.T)
> 2. Not killable SPID.
> After #1 step, I tried many method to solve the problem.
> As one trial, I set the catalog at the linked server's property.
> After that, I tried query as followings
> ---
> select @.v_intUserNo = uno
> from [linked server name].[catalog name].[schema name].[
table name]
> where userid = 'testid'
> or select @.v_intUserNo = uno
> from OPENQUERY('TEST_DB', 'select * from test_tbl where userid =
> ''testid''')
> ---
> It doesn't returned any error or result, so, I killed the session.
> but it was not cleared promptly, only return the following message.
> SPID 70: transaction rollback in progress. Estimated rollback completion:
> 100%. Estimated time remaining: 0 seconds.
> After restarting the SQLServer, they were cleared.
> I wish to know the all the experiencies for managing the linked server to
> the mysql DB at the SQLServer.
> Thank you in advance
>
>

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 8.00.2039
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/default.aspx?ln=en-us&x=11&y=13&prid=2392&gprid=36498
--
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> =====================================================================> BugCheck Dump
> =====================================================================>
> This file is generated by Microsoft SQL Server 8.00.2039
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
>
> Computer type is AT/AT COMPATIBLE.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients => 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
========================================
=============================
BugCheck Dump
========================================
=============================
This file is generated by Microsoft SQL Server 8.00.2039
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/de...d=3
6498
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> ========================================
=============================
> BugCheck Dump
> ========================================
=============================
>
> This file is generated by Microsoft SQL Server 8.00.2039
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
>
> Computer type is AT/AT COMPATIBLE.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients =
> 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
================================================== ===================
BugCheck Dump
================================================== ===================
This file is generated by Microsoft SQL Server 8.00.2039
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*
AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/def...92&gprid=36498
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> ================================================== ===================
> BugCheck Dump
> ================================================== ===================
>
> This file is generated by Microsoft SQL Server 8.00.2039
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
>
> Computer type is AT/AT COMPATIBLE.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients =
> 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv())DId you enable remote con

Dear All

I am using sql server 2000 SP4. Os is win2003 server. I was able to register sql server from my server using Enterprise manager. but i am not able to register the same from any client machine. pls help me

raffi

Hi,

DId you enable remote connections yet ? Have a look at my screencast on my site. You will find a tutorial to enable remote connections for your SQL Server 2005. By default this is turned off.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv())

Dear All

I am using sql server 2000 SP4. Os is win2003 server. I was able to register sql server from my server using Enterprise manager. but i am not able to register the same from any client machine. pls help me

raffi

Hi,

DId you enable remote connections yet ? Have a look at my screencast on my site. You will find a tutorial to enable remote connections for your SQL Server 2005. By default this is turned off.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

[Microsoft] [ODBC SQL Server Driver] Timeout expired

Hi, Everyone,

I have a SQL 2000 cluster with sp4. I used SQL QUERY Analyzer to running DBCC CHECKDB for 2 of user’s databases (one is 110 GB and other 5 GB) and get the following message: [Microsoft] [ODBC SQL Server Driver] Timeout expired.I am running same DBCC CHECKDB against system databases or other small users’ databases are fine.

I can get resulted back from T-SQL (DBCC CHECKDB) against these 2 user databases and I checked sp_configure with other server, I can not find the difference.

Can someone help me out?

KT

Are you executing CHECKDB against 2 of those databases at the same time?

Also check event viewer and SQL error logs for any sort of slow performance with any of the hardware or components on this server.

Have you tried scheduling the same using a SQLagent job?

Have you applied or tested the sp4 hotfix?

|||

I ran dbcc checkdb agaist each database at each time. There has no information logon at even view and SQL log when I got time out message.

I haven't schedule this dbcc checkdb at SQL agent job yet.

I only applied hot fix -KB903086 and brought SQL server level to v8.00 2140.

|||ODBC Sql server drive Timeout expires error message getting when I connect to sql200 server data base with query analyzer

[Microsoft] [ODBC SQL Server Driver] Timeout expired

Hi, Everyone,

I have a SQL 2000 cluster with sp4. I used SQL QUERY Analyzer to running DBCC CHECKDB for 2 of user’s databases (one is 110 GB and other 5 GB) and get the following message: [Microsoft] [ODBC SQL Server Driver] Timeout expired.I am running same DBCC CHECKDB against system databases or other small users’ databases are fine.

I can get resulted back from T-SQL (DBCC CHECKDB) against these 2 user databases and I checked sp_configure with other server, I can not find the difference.

Can someone help me out?

KT

Are you executing CHECKDB against 2 of those databases at the same time?

Also check event viewer and SQL error logs for any sort of slow performance with any of the hardware or components on this server.

Have you tried scheduling the same using a SQLagent job?

Have you applied or tested the sp4 hotfix?

|||

I ran dbcc checkdb agaist each database at each time. There has no information logon at even view and SQL log when I got time out message.

I haven't schedule this dbcc checkdb at SQL agent job yet.

I only applied hot fix -KB903086 and brought SQL server level to v8.00 2140.

|||ODBC Sql server drive Timeout expires error message getting when I connect to sql200 server data base with query analyzer

[help] SQL Error - I/O Error 2 (The system cannot find the file specified)

Windows 2000 Server SP4 + SQL Server 2000 Enterprise Editon SP3,RAID5.

the windows event log give the following error information:

I/O error 2(The system cannot find the file specified) detected during write at offset 0x0000010c6c4000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\GJSZBANK_Data.MDF'.

I have searched microsoft knowledge base and got this article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;828339

but don't understand some contents in the topic:

For example, if you encounter the following error message in the SQL Server Errorlog file, SQL Server encountered operating system error 2 when it uses a Windows API call to write to the tempdb primary database file:

Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000000284000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'

Because SQL Server has already successfully opened the file and did not receive an Invalid Handle error, the error is likely being raised in a lower-level kernel software component, such as the file system or a device driver. This problem does not indicate a problem in SQL Server, and it must be investigated as an issue with the file system or a device driver that is associated with the file.

Does that mean this is not a SQL Server error?
Does that mean something wrong with my operating system? or something wrong with my hard disk?Are there any errors in the SQL errorlog? Or is it only in the NT Event log?

[DBNETLIB][ConnectionWrite (send()).]General network error

SQL Server Spec
SQL 2000, 8.00.2187 SP4 standard edition
windows 2003 SP1
sqlserver driver 2000.86.1830.00
webserver
windows 2003 r2, standard edition service pack2
sqlserver driver 2000.86.3959.00
we received "intermittance"
Error Number -2147467259 (&H80004005)
[DBNETLIB][ConnectionWrite (send()).]General network error. Check yo
ur
network documentation.
We already do this as mention in microsoft website
on SynAttackProtect:
http://support.microsoft.com/defaul...kb;en-us;899599
Any idea or any one have experience on this?
Cheers,
Liang Yewsorry,
SQL Server
windows 2003 SP2
SQL 2000, 8.00.2187 SP4 standard edition
sqlserver driver 2000.86.3959.00
"soonyu" wrote:

> SQL Server Spec
> SQL 2000, 8.00.2187 SP4 standard edition
> windows 2003 SP1
> sqlserver driver 2000.86.1830.00
> webserver
> windows 2003 r2, standard edition service pack2
> sqlserver driver 2000.86.3959.00
> we received "intermittance"
> Error Number -2147467259 (&H80004005)
> [DBNETLIB][ConnectionWrite (send()).]General network error. Check
your
> network documentation.
> We already do this as mention in microsoft website
> on SynAttackProtect:
> http://support.microsoft.com/defaul...kb;en-us;899599
> Any idea or any one have experience on this?
> Cheers,
> Liang Yew

[DBNETLIB][ConnectionWrite (send()).]General network error

SQL Server Spec
SQL 2000, 8.00.2187 SP4 standard edition
windows 2003 SP1
sqlserver driver 2000.86.1830.00
webserver
windows 2003 r2, standard edition service pack2
sqlserver driver 2000.86.3959.00
we received "intermittance"
Error Number -2147467259 (&H80004005)
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your
network documentation.
We already do this as mention in microsoft website
on SynAttackProtect:
http://support.microsoft.com/default.aspx?scid=kb;en-us;899599
Any idea or any one have experience on this?
Cheers,
Liang Yew
sorry,
SQL Server
windows 2003 SP2
SQL 2000, 8.00.2187 SP4 standard edition
sqlserver driver 2000.86.3959.00
"soonyu" wrote:

> SQL Server Spec
> SQL 2000, 8.00.2187 SP4 standard edition
> windows 2003 SP1
> sqlserver driver 2000.86.1830.00
> webserver
> windows 2003 r2, standard edition service pack2
> sqlserver driver 2000.86.3959.00
> we received "intermittance"
> Error Number -2147467259 (&H80004005)
> [DBNETLIB][ConnectionWrite (send()).]General network error. Check your
> network documentation.
> We already do this as mention in microsoft website
> on SynAttackProtect:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;899599
> Any idea or any one have experience on this?
> Cheers,
> Liang Yew