CAB Files

Can anyone Please point me to a place that I can find some documentation on what the sql.ppc.wce5.armv4i.CAB does?

I basically need to know which files are being placed in the handset by deplyoing the CAB file.

Thanks,

Farnaz

The cab file contents are documented here: http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx

caan not register server from internet

Hello,
I have two SQL 2K server, both are running fine with public IP address.
i.e.
Server #1: 100.100.100.101
Server #2: 200.200.200.202
I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
The alias has the ip 200.200.200.202 and port 1433
Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL Server
authentication. (login name: sa and password)
Then I got the following error message:
"SQL2 - SQL Server does not exist or access denied. Connection(Connect("
I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same error
message.
Both server can ping each other.
SQL#1 is behind Cisco router 1720 with direct ip address.
SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
I can use FTP and WEB on SQL#2.
Thanks
Did you make a port scan to indicate wheter the SQL Server is listening on
one
of the adresses
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
> Hello,
> I have two SQL 2K server, both are running fine with public IP address.
> i.e.
> Server #1: 100.100.100.101
> Server #2: 200.200.200.202
> I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
> The alias has the ip 200.200.200.202 and port 1433
> Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL
> Server
> authentication. (login name: sa and password)
> Then I got the following error message:
> "SQL2 - SQL Server does not exist or access denied. Connection(Connect("
> I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
> error
> message.
> Both server can ping each other.
> SQL#1 is behind Cisco router 1720 with direct ip address.
> SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
> I can use FTP and WEB on SQL#2.
>
> Thanks
>
|||Hello,
How to use port scan?
Thanks
"Jens Sü?meyer" wrote:

> Did you make a port scan to indicate wheter the SQL Server is listening on
> one
> of the adresses ?
> HTH, Jens Sü?meyer.
> --
> http://www.sqlserver2005.de
> --
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
>
>
|||YOu need to habe some porscanning program like Superscan, there you can
evaluate wehter the port is open and SQL Server is listening.
HTH, Jens Suessmeyer.
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...[vbcol=seagreen]
> Hello,
> How to use port scan?
> Thanks
> "Jens Smeyer" wrote:
|||You don't need a Port Scan to determine if the SQL server is listening on
the port. A simple Telnet command on port 1433 will tell you if the SQL
server can be reached on port 1433.
Regards
Steen
Jens Smeyer wrote:[vbcol=seagreen]
> YOu need to habe some porscanning program like Superscan, there you
> can evaluate wehter the port is open and SQL Server is listening.
> HTH, Jens Suessmeyer.
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...

caan not register server from internet

Hello,
I have two SQL 2K server, both are running fine with public IP address.
i.e.
Server #1: 100.100.100.101
Server #2: 200.200.200.202
I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
The alias has the ip 200.200.200.202 and port 1433
Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL Server
authentication. (login name: sa and password)
Then I got the following error message:
"SQL2 - SQL Server does not exist or access denied. Connection(Connect("
I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same error
message.
Both server can ping each other.
SQL#1 is behind Cisco router 1720 with direct ip address.
SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
I can use FTP and WEB on SQL#2.
ThanksDid you make a port scan to indicate wheter the SQL Server is listening on
one
of the adresses ß
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
> Hello,
> I have two SQL 2K server, both are running fine with public IP address.
> i.e.
> Server #1: 100.100.100.101
> Server #2: 200.200.200.202
> I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
> The alias has the ip 200.200.200.202 and port 1433
> Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL
> Server
> authentication. (login name: sa and password)
> Then I got the following error message:
> "SQL2 - SQL Server does not exist or access denied. Connection(Connect("
> I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
> error
> message.
> Both server can ping each other.
> SQL#1 is behind Cisco router 1720 with direct ip address.
> SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
> I can use FTP and WEB on SQL#2.
>
> Thanks
>|||Hello,
How to use port scan?
Thanks
"Jens Sü�meyer" wrote:
> Did you make a port scan to indicate wheter the SQL Server is listening on
> one
> of the adresses Ã?
> HTH, Jens Sü�meyer.
> --
> http://www.sqlserver2005.de
> --
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
> > Hello,
> >
> > I have two SQL 2K server, both are running fine with public IP address.
> >
> > i.e.
> > Server #1: 100.100.100.101
> > Server #2: 200.200.200.202
> >
> > I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
> > The alias has the ip 200.200.200.202 and port 1433
> > Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL
> > Server
> > authentication. (login name: sa and password)
> > Then I got the following error message:
> > "SQL2 - SQL Server does not exist or access denied. Connection(Connect("
> >
> > I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
> > error
> > message.
> >
> > Both server can ping each other.
> > SQL#1 is behind Cisco router 1720 with direct ip address.
> > SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
> > I can use FTP and WEB on SQL#2.
> >
> >
> > Thanks
> >
> >
>
>|||YOu need to habe some porscanning program like Superscan, there you can
evaluate wehter the port is open and SQL Server is listening.
HTH, Jens Suessmeyer.
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...
> Hello,
> How to use port scan?
> Thanks
> "Jens Süßmeyer" wrote:
>> Did you make a port scan to indicate wheter the SQL Server is listening
>> on
>> one
>> of the adresses ß
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
>> > Hello,
>> >
>> > I have two SQL 2K server, both are running fine with public IP address.
>> >
>> > i.e.
>> > Server #1: 100.100.100.101
>> > Server #2: 200.200.200.202
>> >
>> > I use SQL Server #1 Client Network Utility to create an Alias i.e.
>> > SQL2.
>> > The alias has the ip 200.200.200.202 and port 1433
>> > Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL
>> > Server
>> > authentication. (login name: sa and password)
>> > Then I got the following error message:
>> > "SQL2 - SQL Server does not exist or access denied.
>> > Connection(Connect("
>> >
>> > I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
>> > error
>> > message.
>> >
>> > Both server can ping each other.
>> > SQL#1 is behind Cisco router 1720 with direct ip address.
>> > SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
>> > I can use FTP and WEB on SQL#2.
>> >
>> >
>> > Thanks
>> >
>> >
>>|||You don't need a Port Scan to determine if the SQL server is listening on
the port. A simple Telnet command on port 1433 will tell you if the SQL
server can be reached on port 1433.
Regards
Steen
Jens Süßmeyer wrote:
> YOu need to habe some porscanning program like Superscan, there you
> can evaluate wehter the port is open and SQL Server is listening.
> HTH, Jens Suessmeyer.
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...
>> Hello,
>> How to use port scan?
>> Thanks
>> "Jens Süßmeyer" wrote:
>> Did you make a port scan to indicate wheter the SQL Server is
>> listening on
>> one
>> of the adresses ß
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
>> Hello,
>> I have two SQL 2K server, both are running fine with public IP
>> address.
>> i.e.
>> Server #1: 100.100.100.101
>> Server #2: 200.200.200.202
>> I use SQL Server #1 Client Network Utility to create an Alias i.e.
>> SQL2.
>> The alias has the ip 200.200.200.202 and port 1433
>> Then I use SQL Server #1 Enterprise Manager to register SQL2 with
>> SQL Server
>> authentication. (login name: sa and password)
>> Then I got the following error message:
>> "SQL2 - SQL Server does not exist or access denied.
>> Connection(Connect("
>> I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the
>> same error
>> message.
>> Both server can ping each other.
>> SQL#1 is behind Cisco router 1720 with direct ip address.
>> SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to
>> SQL#2. I can use FTP and WEB on SQL#2.
>>
>> Thanks

caan not register server from internet

Hello,
I have two SQL 2K server, both are running fine with public IP address.
i.e.
Server #1: 100.100.100.101
Server #2: 200.200.200.202
I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
The alias has the ip 200.200.200.202 and port 1433
Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL Server
authentication. (login name: sa and password)
Then I got the following error message:
"SQL2 - SQL Server does not exist or access denied. Connection(Connect("
I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same error
message.
Both server can ping each other.
SQL#1 is behind cisco router 1720 with direct ip address.
SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
I can use FTP and WEB on SQL#2.
ThanksDid you make a port scan to indicate wheter the SQL Server is listening on
one
of the adresses
HTH, Jens Smeyer.
http://www.sqlserver2005.de
--
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
> Hello,
> I have two SQL 2K server, both are running fine with public IP address.
> i.e.
> Server #1: 100.100.100.101
> Server #2: 200.200.200.202
> I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
> The alias has the ip 200.200.200.202 and port 1433
> Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL
> Server
> authentication. (login name: sa and password)
> Then I got the following error message:
> "SQL2 - SQL Server does not exist or access denied. Connection(Connect("
> I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
> error
> message.
> Both server can ping each other.
> SQL#1 is behind cisco router 1720 with direct ip address.
> SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
> I can use FTP and WEB on SQL#2.
>
> Thanks
>|||Hello,
How to use port scan?
Thanks
"Jens Sü?meyer" wrote:

> Did you make a port scan to indicate wheter the SQL Server is listening on
> one
> of the adresses ?
> HTH, Jens Sü?meyer.
> --
> http://www.sqlserver2005.de
> --
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
>
>|||YOu need to habe some porscanning program like Superscan, there you can
evaluate wehter the port is open and SQL Server is listening.
HTH, Jens Suessmeyer.
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...[vbcol=seagreen]
> Hello,
> How to use port scan?
> Thanks
> "Jens Smeyer" wrote:
>|||You don't need a Port Scan to determine if the SQL server is listening on
the port. A simple Telnet command on port 1433 will tell you if the SQL
server can be reached on port 1433.
Regards
Steen
Jens Smeyer wrote:[vbcol=seagreen]
> YOu need to habe some porscanning program like Superscan, there you
> can evaluate wehter the port is open and SQL Server is listening.
> HTH, Jens Suessmeyer.
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...

CA not valid

Hello,
I need first to test SSL-Encryption on an standalone SQL Server 2000 Server.
For this, I became a Personal CA from a friend and the appropriated Trusted
Root CA. I requested it with the User who start the SQL Server services (an
administrator user)
All looks fine under MMC, but SQL Server does not find any 'valid'
certificate... and SetCert too
What the mater?
Is it not possible to use CAs from none official Authorities? Also if my
Server is out of the network?
How can I test for a day without to pay for a longtime valid CA?If SQL is on the same machine as the CA, the CA must have a different name.
The certificate that SQL uses is a machine cert, the same cert that IIS
uses. As a test you could
use IIS to validate the cert using a SSL site on the same machine.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

C2 SQL auditing

Hi,
I setup my SQL 2000 Server to use C2 auditing. It is working.
My only problem is that my trace file does not get populated while I am
inserting/updating/select data or anything.
However, when I stop SQL server then my trace file gets populated.
I cannot stop a production SQL server on and off just to collect data and
the trace file is only limited to 200MB so I can wait till the end of day.
I am trying to do a audit report every 2hrs.
Am I doing something wrong? Or this is how C2 works?
I would appreciate all the help!Don't use the C2 auditing. Just create a custom trace that collects the data
you want and you can start and stop it as you need to. Check out
sp_trace_Create in BooksOnLine.
Andrew J. Kelly SQL MVP
"SQL apprentice" <mssqlworld@.yahoo.com> wrote in message
news:OYlONfeVHHA.3500@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I setup my SQL 2000 Server to use C2 auditing. It is working.
> My only problem is that my trace file does not get populated while I am
> inserting/updating/select data or anything.
> However, when I stop SQL server then my trace file gets populated.
> I cannot stop a production SQL server on and off just to collect data and
> the trace file is only limited to 200MB so I can wait till the end of day.
> I am trying to do a audit report every 2hrs.
> Am I doing something wrong? Or this is how C2 works?
> I would appreciate all the help!
>|||Hi Andrew,
I had to setup C2 for my company just so they can see it in their own eyes.
I recommended them to use Server Side trace, it is more efficiency and
customizable to what they want to audit.
It would make my case even better when I tell them 3 SQL MVPs suggest not to
use C2.
Do you suggest any third party tools for SOX compliance? I am testing Idera
CM right now.
Eventually, I would like to off load the server side trace to the SOX team
since there are over 100 SQL Servers.
I would like to setup and manage so many traces.
Thanks again for the input...I greatly appreciated.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OqOIdLiVHHA.3592@.TK2MSFTNGP03.phx.gbl...
> Don't use the C2 auditing. Just create a custom trace that collects the
data
> you want and you can start and stop it as you need to. Check out
> sp_trace_Create in BooksOnLine.
> --
> Andrew J. Kelly SQL MVP
> "SQL apprentice" <mssqlworld@.yahoo.com> wrote in message
> news:OYlONfeVHHA.3500@.TK2MSFTNGP05.phx.gbl...
and[vbcol=seagreen]
day.[vbcol=seagreen]
>|||I don't have a specific recomendation as the SOX requirements are very loose
and open to interpitation. There are a number of 3rd party tools that
monitor the logs.
http://sqlserver2000.databases.aspf...t
a.html
http://sqlserver2000.databases.aspf...
log-files.html
Andrew J. Kelly SQL MVP
"SQL apprentice" <mssqlworld@.yahoo.com> wrote in message
news:ufl7fZpVHHA.1636@.TK2MSFTNGP02.phx.gbl...
> Hi Andrew,
> I had to setup C2 for my company just so they can see it in their own
> eyes.
> I recommended them to use Server Side trace, it is more efficiency and
> customizable to what they want to audit.
> It would make my case even better when I tell them 3 SQL MVPs suggest not
> to
> use C2.
> Do you suggest any third party tools for SOX compliance? I am testing
> Idera
> CM right now.
> Eventually, I would like to off load the server side trace to the SOX team
> since there are over 100 SQL Servers.
> I would like to setup and manage so many traces.
> Thanks again for the input...I greatly appreciated.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OqOIdLiVHHA.3592@.TK2MSFTNGP03.phx.gbl...
> data
> and
> day.
>

c2 failed login correlation to an origination IP/host ?

hey there
I wanted to know how people correlate a failed login attempt from within sql
logs or c2 logs and the origination address. I am thinking maybe people
looks at the events logs, but do those say what are the connections from
wich the failed loging started ?
I am in a dillema !
Hi
A guess... but can you link this into your firewall logs somethow?
John
"Simo Sentissi" wrote:

> hey there
> I wanted to know how people correlate a failed login attempt from within sql
> logs or c2 logs and the origination address. I am thinking maybe people
> looks at the events logs, but do those say what are the connections from
> wich the failed loging started ?
> I am in a dillema !
>
>

c2 failed login correlation to an origination IP/host ?

hey there
I wanted to know how people correlate a failed login attempt from within sql
logs or c2 logs and the origination address. I am thinking maybe people
looks at the events logs, but do those say what are the connections from
wich the failed loging started '
I am in a dillema !Hi
A guess... but can you link this into your firewall logs somethow?
John
"Simo Sentissi" wrote:

> hey there
> I wanted to know how people correlate a failed login attempt from within s
ql
> logs or c2 logs and the origination address. I am thinking maybe people
> looks at the events logs, but do those say what are the connections from
> wich the failed loging started '
> I am in a dillema !
>
>

c2 failed login correlation to an origination IP/host ?

hey there
I wanted to know how people correlate a failed login attempt from within sql
logs or c2 logs and the origination address. I am thinking maybe people
looks at the events logs, but do those say what are the connections from
wich the failed loging started '
I am in a dillema !Hi
A guess... but can you link this into your firewall logs somethow?
John
"Simo Sentissi" wrote:
> hey there
> I wanted to know how people correlate a failed login attempt from within sql
> logs or c2 logs and the origination address. I am thinking maybe people
> looks at the events logs, but do those say what are the connections from
> wich the failed loging started '
> I am in a dillema !
>
>

C2 Auditing: How to change to directory to save log files

I need to turn on C2 auditing on a sql 2K cluster server.
I do not have any space on C drive which according to the articles (and bol)
is the default place.
How I can change the directory so these traces can be save into the location
I want.
Any solid experience anyone has on C2?
Thank you,
ktf
Hi
C2 auditing writes to \mssql\data directory for default instances of SQL
Server 2000, or the \mssql$instancename\data directory for named instances.
If you change the default database data location in EM, or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\DefaultData,
it will place them there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ktf" <ktf@.discussions.microsoft.com> wrote in message
news:D1ACF0EF-410E-4306-B826-17C76081C275@.microsoft.com...
> I need to turn on C2 auditing on a sql 2K cluster server.
> I do not have any space on C drive which according to the articles (and
bol)
> is the default place.
> How I can change the directory so these traces can be save into the
location
> I want.
> Any solid experience anyone has on C2?
> Thank you,
> ktf
>
|||Well Mr. Epprecht,
I have C and D drive which are the local drives and S and R from the SAN.
The only location that I can is on S drive. The registry setting is deferent.
Is there a specific registry object for that mater? I can try to run it and
see where it is saving it but is there a specific place that I can change the
setting that is for C2 ONLY?
Other question I have a passive site for disaster recovery (I am not talking
about passive node) do I have to replicate the trace data? The passive site
has a different virtual server name and ip address. As you know the sql is
sleep but I have a third party replication system going. Do you know if I
replace the trace that will be readable at the passive site?
Do you recommend any site for anything on C2?
Thank you,
ktf
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> C2 auditing writes to \mssql\data directory for default instances of SQL
> Server 2000, or the \mssql$instancename\data directory for named instances.
> If you change the default database data location in EM, or
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\DefaultData,
> it will place them there.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ktf" <ktf@.discussions.microsoft.com> wrote in message
> news:D1ACF0EF-410E-4306-B826-17C76081C275@.microsoft.com...
> bol)
> location
>
>

C2 Auditing: How to change to directory to save log files

I need to turn on C2 auditing on a sql 2K cluster server.
I do not have any space on C drive which according to the articles (and bol)
is the default place.
How I can change the directory so these traces can be save into the location
I want.
Any solid experience anyone has on C2?
Thank you,
ktfHi
C2 auditing writes to \mssql\data directory for default instances of SQL
Server 2000, or the \mssql$instancename\data directory for named instances.
If you change the default database data location in EM, or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\DefaultData,
it will place them there.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ktf" <ktf@.discussions.microsoft.com> wrote in message
news:D1ACF0EF-410E-4306-B826-17C76081C275@.microsoft.com...
> I need to turn on C2 auditing on a sql 2K cluster server.
> I do not have any space on C drive which according to the articles (and
bol)
> is the default place.
> How I can change the directory so these traces can be save into the
location
> I want.
> Any solid experience anyone has on C2?
> Thank you,
> ktf
>|||Well Mr. Epprecht,
I have C and D drive which are the local drives and S and R from the SAN.
The only location that I can is on S drive. The registry setting is deferent.
Is there a specific registry object for that mater? I can try to run it and
see where it is saving it but is there a specific place that I can change the
setting that is for C2 ONLY?
Other question I have a passive site for disaster recovery (I am not talking
about passive node) do I have to replicate the trace data? The passive site
has a different virtual server name and ip address. As you know the sql is
sleep but I have a third party replication system going. Do you know if I
replace the trace that will be readable at the passive site?
Do you recommend any site for anything on C2?
Thank you,
ktf
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> C2 auditing writes to \mssql\data directory for default instances of SQL
> Server 2000, or the \mssql$instancename\data directory for named instances.
> If you change the default database data location in EM, or
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\DefaultData,
> it will place them there.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ktf" <ktf@.discussions.microsoft.com> wrote in message
> news:D1ACF0EF-410E-4306-B826-17C76081C275@.microsoft.com...
> >
> > I need to turn on C2 auditing on a sql 2K cluster server.
> > I do not have any space on C drive which according to the articles (and
> bol)
> > is the default place.
> > How I can change the directory so these traces can be save into the
> location
> > I want.
> > Any solid experience anyone has on C2?
> >
> > Thank you,
> > ktf
> >
>
>

C2 Auditing: How to change to directory to save log files

I need to turn on C2 auditing on a sql 2K cluster server.
I do not have any space on C drive which according to the articles (and bol)
is the default place.
How I can change the directory so these traces can be save into the location
I want.
Any solid experience anyone has on C2?
Thank you,
ktfHi
C2 auditing writes to \mssql\data directory for default instances of SQL
Server 2000, or the \mssql$instancename\data directory for named instances.
If you change the default database data location in EM, or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\DefaultData,
it will place them there.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ktf" <ktf@.discussions.microsoft.com> wrote in message
news:D1ACF0EF-410E-4306-B826-17C76081C275@.microsoft.com...
> I need to turn on C2 auditing on a sql 2K cluster server.
> I do not have any space on C drive which according to the articles (and
bol)
> is the default place.
> How I can change the directory so these traces can be save into the
location
> I want.
> Any solid experience anyone has on C2?
> Thank you,
> ktf
>|||Well Mr. Epprecht,
I have C and D drive which are the local drives and S and R from the SAN.
The only location that I can is on S drive. The registry setting is deferent
.
Is there a specific registry object for that mater? I can try to run it and
see where it is saving it but is there a specific place that I can change th
e
setting that is for C2 ONLY?
Other question I have a passive site for disaster recovery (I am not talking
about passive node) do I have to replicate the trace data? The passive site
has a different virtual server name and ip address. As you know the sql is
sleep but I have a third party replication system going. Do you know if I
replace the trace that will be readable at the passive site?
Do you recommend any site for anything on C2?
Thank you,
ktf
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> C2 auditing writes to \mssql\data directory for default instances of SQL
> Server 2000, or the \mssql$instancename\data directory for named instances
.
> If you change the default database data location in EM, or
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\DefaultData,
> it will place them there.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ktf" <ktf@.discussions.microsoft.com> wrote in message
> news:D1ACF0EF-410E-4306-B826-17C76081C275@.microsoft.com...
> bol)
> location
>
>

C2 auditing path?

How can I specify the c2 auditing files path?Hi
The files will be in the default data directory which you can change.
John
"Artificer" wrote:
> How can I specify the c2 auditing files path?
>|||How to specify that?
"John Bell" wrote:
> Hi
> The files will be in the default data directory which you can change.
> John
> "Artificer" wrote:
> > How can I specify the c2 auditing files path?
> >
> >|||Hi
The easiest way is to change it on the database tab of the server properties
dialog in Enterprise Manager and restart SQL Server.
John
"Joseph" wrote:
> How to specify that?
> "John Bell" wrote:
> > Hi
> >
> > The files will be in the default data directory which you can change.
> >
> > John
> >
> > "Artificer" wrote:
> >
> > > How can I specify the c2 auditing files path?
> > >
> > >|||If the database tab of the server properties is changed, what will the new
default database destination be? The one described in the database tab or the
one of the model db?
Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> Hi
> The easiest way is to change it on the database tab of the server properties
> dialog in Enterprise Manager and restart SQL Server.
> John
> "Joseph" wrote:
> > How to specify that?
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > The files will be in the default data directory which you can change.
> > >
> > > John
> > >
> > > "Artificer" wrote:
> > >
> > > > How can I specify the c2 auditing files path?
> > > >
> > > >|||Hi
New databases data files will be created in the directory that you have
chanegd on the database tab of the server properties dialog. This directory
does not have to be the same location as the system databases.
If you don't want to create the data and log files in the default
directories you can either overwrite them in the new database dialogs data
file and log file tabs or use Query analyser to specify explicitly the CREATE
DATABASE statement.
John
"blackpit" wrote:
> If the database tab of the server properties is changed, what will the new
> default database destination be? The one described in the database tab or the
> one of the model db?
> Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> > Hi
> >
> > The easiest way is to change it on the database tab of the server properties
> > dialog in Enterprise Manager and restart SQL Server.
> >
> > John
> >
> > "Joseph" wrote:
> >
> > > How to specify that?
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > The files will be in the default data directory which you can change.
> > > >
> > > > John
> > > >
> > > > "Artificer" wrote:
> > > >
> > > > > How can I specify the c2 auditing files path?
> > > > >
> > > > >|||It is clear.
Thank you
Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> Hi
> New databases data files will be created in the directory that you have
> chanegd on the database tab of the server properties dialog. This directory
> does not have to be the same location as the system databases.
> If you don't want to create the data and log files in the default
> directories you can either overwrite them in the new database dialogs data
> file and log file tabs or use Query analyser to specify explicitly the CREATE
> DATABASE statement.
> John
> "blackpit" wrote:
> > If the database tab of the server properties is changed, what will the new
> > default database destination be? The one described in the database tab or the
> > one of the model db?
> >
> > Î? Ï?Ï?ήÏ?Ï?ηÏ? "John Bell" έγγÏ?αÏ?ε:
> >
> > > Hi
> > >
> > > The easiest way is to change it on the database tab of the server properties
> > > dialog in Enterprise Manager and restart SQL Server.
> > >
> > > John
> > >
> > > "Joseph" wrote:
> > >
> > > > How to specify that?
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > The files will be in the default data directory which you can change.
> > > > >
> > > > > John
> > > > >
> > > > > "Artificer" wrote:
> > > > >
> > > > > > How can I specify the c2 auditing files path?
> > > > > >
> > > > > >|||Thanks!

C2 auditing path?

How can I specify the c2 auditing files path?Hi
The files will be in the default data directory which you can change.
John
"Artificer" wrote:

> How can I specify the c2 auditing files path?
>|||How to specify that?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> The files will be in the default data directory which you can change.
> John
> "Artificer" wrote:
>|||Hi
The easiest way is to change it on the database tab of the server properties
dialog in Enterprise Manager and restart SQL Server.
John
"Joseph" wrote:
[vbcol=seagreen]
> How to specify that?
> "John Bell" wrote:
>|||If the database tab of the server properties is changed, what will the new
default database destination be? The one described in the database tab or th
e
one of the model db?
Ο χρ?στη? "John Bell" _γγραψε:
[vbcol=seagreen]
> Hi
> The easiest way is to change it on the database tab of the server properti
es
> dialog in Enterprise Manager and restart SQL Server.
> John
> "Joseph" wrote:
>|||Hi
New databases data files will be created in the directory that you have
chanegd on the database tab of the server properties dialog. This directory
does not have to be the same location as the system databases.
If you don't want to create the data and log files in the default
directories you can either overwrite them in the new database dialogs data
file and log file tabs or use Query analyser to specify explicitly the CREAT
E
DATABASE statement.
John
"blackpit" wrote:
[vbcol=seagreen]
> If the database tab of the server properties is changed, what will the new
> default database destination be? The one described in the database tab or
the
> one of the model db?
> Ο χρ?στη? "John Bell" _γγραψε:
>|||It is clear.
Thank you
Ο χρ?στη? "John Bell" _γγραψε:
[vbcol=seagreen]
> Hi
> New databases data files will be created in the directory that you have
> chanegd on the database tab of the server properties dialog. This director
y
> does not have to be the same location as the system databases.
> If you don't want to create the data and log files in the default
> directories you can either overwrite them in the new database dialogs data
> file and log file tabs or use Query analyser to specify explicitly the CRE
ATE
> DATABASE statement.
> John
> "blackpit" wrote:
>|||Thanks!

C2 auditing on SQL Server

I currently have C2 auditing turned on for a server, and an audit trace file
gets written to the default database directory every couple of hours. Is
there a way to get C2 auditing to write to a separate database for querying?
And is there also a way to turn C2 on/off without restarting the server?
Is C2 the appropriate tool for internal auditing, or is there a
better tool out there for getting reports, etc?
cross posted to .securitytools
Thanks,
-RSHi,
A normal profiler using the properties windows can save the contents to a
table. I am not sure on how tyo automate this in C2 auditing, because
it craetes seperate files.
And is there also a way to turn C2 on/off without restarting the server?
No.
Is C2 the appropriate tool for internal auditing, or is there a better tool
out there for getting reports, etc?
Yes, But might not be useful for reporting. Take a look into the product
from lumigent
http://www.lumigent.com/Downloads/
Have a look into the below site for more information on c2 Audit
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2ard.asp
Thanks
Hari
MCDBA
"RS" <rspen@.yahoo.com> wrote in message
news:e$4zwZ2CEHA.3748@.TK2MSFTNGP11.phx.gbl...
> I currently have C2 auditing turned on for a server, and an audit trace
file
> gets written to the default database directory every couple of hours. Is
> there a way to get C2 auditing to write to a separate database for
querying?
> And is there also a way to turn C2 on/off without restarting the server?
> Is C2 the appropriate tool for internal auditing, or is there a
> better tool out there for getting reports, etc?
> cross posted to .securitytools
> Thanks,
> -RS
>|||C2 auditing is primary for forensics purposes and not meant to be used for r
eporting. The logs themselves write to 200mb and then roll over, so it's a
hassle at best to try and get anything meaningful from a reporting standpoin
t. I'd recommend running a
different profile for what you specifically want.|||Thanks..that helps. I think we are going to look at Lumigent, but it is
pricey. Is there anything that offers a good reporting tool for trace files
without being so expensive? Maybe there is a market opportunity here.
-RS
"binary_designs" <anonymous@.discussions.microsoft.com> wrote in message
news:A0B925B8-6ACC-4802-9BBB-26882634DCB2@.microsoft.com...
> C2 auditing is primary for forensics purposes and not meant to be used for
reporting. The logs themselves write to 200mb and then roll over, so it's a
hassle at best to try and get anything meaningful from a reporting
standpoint. I'd recommend running a different profile for what you
specifically want.

C2 auditing ?

Hello there
I just inherited a data farm and I noticed that the person before me had c2
auditing turned on.
I noticed that the trc files date only back to 04/05 and that the last time
a fiel has been modified is yesterday.
the rate of growing out of 200mb should make these files date of once a day
or even 2. does anybody know how I can check if c2 is still turned on ? or
any idea why that is ? I suppoe i can wait another couple of days and see
but ...
thanks
>> does anybody know how I can check if c2 is still turned on ?
You can use sp_configure look for the running value for c2 audit mode.
Anith

C2 auditing ?

Hello there
I just inherited a data farm and I noticed that the person before me had c2
auditing turned on.
I noticed that the trc files date only back to 04/05 and that the last time
a fiel has been modified is yesterday.
the rate of growing out of 200mb should make these files date of once a day
or even 2. does anybody know how I can check if c2 is still turned on ? or
any idea why that is ? I suppoe i can wait another couple of days and see
but ...
thanks>> does anybody know how I can check if c2 is still turned on ?
You can use sp_configure look for the running value for c2 audit mode.
--
Anith

C2 auditing ?

Hello there
I just inherited a data farm and I noticed that the person before me had c2
auditing turned on.
I noticed that the trc files date only back to 04/05 and that the last time
a fiel has been modified is yesterday.
the rate of growing out of 200mb should make these files date of once a day
or even 2. does anybody know how I can check if c2 is still turned on ? or
any idea why that is ? I suppoe i can wait another couple of days and see
but ...
thanks>> does anybody know how I can check if c2 is still turned on ?
You can use sp_configure look for the running value for c2 audit mode.
Anith

c2 auditing

Is there any way to granularise what c2 monitors? I have a system which is
generating thousands of trades and this is in turn generating a 200Mb c2
trace every 1 minute.
What kind of trading system would use C2 audit?
Linchi
"guest5" wrote:

> Is there any way to granularise what c2 monitors? I have a system which is
> generating thousands of trades and this is in turn generating a 200Mb c2
> trace every 1 minute.

c2 auditing

Is there any way to granularise what c2 monitors? I have a system which is
generating thousands of trades and this is in turn generating a 200Mb c2
trace every 1 minute.> Is there any way to granularise what c2 monitors?
That would mean it isn't a c2 trace anymore... ;-)
You can create your own server-side traces, however, and make them autostart
using sp_procoption.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:EA8A7A35-E793-4537-B8B1-EC7AEF9C7D7D@.microsoft.com...
> Is there any way to granularise what c2 monitors? I have a system which is
> generating thousands of trades and this is in turn generating a 200Mb c2
> trace every 1 minute.|||What kind of trading system would use C2 audit?
Linchi
"guest5" wrote:

> Is there any way to granularise what c2 monitors? I have a system which is
> generating thousands of trades and this is in turn generating a 200Mb c2
> trace every 1 minute.

c2 auditing

Is there any way to granularise what c2 monitors? I have a system which is
generating thousands of trades and this is in turn generating a 200Mb c2
trace every 1 minute.> Is there any way to granularise what c2 monitors?
That would mean it isn't a c2 trace anymore... ;-)
You can create your own server-side traces, however, and make them autostart using sp_procoption.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:EA8A7A35-E793-4537-B8B1-EC7AEF9C7D7D@.microsoft.com...
> Is there any way to granularise what c2 monitors? I have a system which is
> generating thousands of trades and this is in turn generating a 200Mb c2
> trace every 1 minute.|||What kind of trading system would use C2 audit?
Linchi
"guest5" wrote:
> Is there any way to granularise what c2 monitors? I have a system which is
> generating thousands of trades and this is in turn generating a 200Mb c2
> trace every 1 minute.

c2 audit on SQL 7?

dear gurus,
as far as i know, c2 mode is doable on sql 2000 running
in NT4.
is it any possibility to have c2 auditting on SQL7 in NT4?
any seizing tool to evaluate the windows/sql resource
consumption if c2 is enabled?
thanks,
May ChengC2 Auditing is not available on SQL Server 7 - it's only available on
SQL Server 2000.
-Sue
On Mon, 11 Oct 2004 09:35:09 -0700, "may cheng"
<anonymous@.discussions.microsoft.com> wrote:

>dear gurus,
>as far as i know, c2 mode is doable on sql 2000 running
>in NT4.
>is it any possibility to have c2 auditting on SQL7 in NT4?
>any seizing tool to evaluate the windows/sql resource
>consumption if c2 is enabled?
>thanks,
>May Cheng

C2 Audit and BCP

I have a system that requires the functionality of c2 audit mode.
Unfortunately most the manipulations that will be taking place on this
system will be using BCP (actually they'll be using IRowsetFastLoad, but the
effect is the same).
If I use Profiler to record SQL statements each of the BCP transactions
comes out as insert bulk SQL statement.
But the audit event just contains garbage (little squares, non-printable
characters) and does not enable me to determine anything useful at all.
Has anyone else encountered this?
Has anyone been able to log BCP statements using c2 audit on SQL Server 2000
SP3a?
Does anyone know if a bug already exists for this?
Thanks.
J.T.BCP will use Native mode by default unless you specify character mode.
What exactly are you wanting to see?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I'd like to be able to identify that an "insert bulk" statement has
occurred.
All of the SQL Statements that are run are identified solely by the
permission event, we have to look at the text data column in Profiler to
establish what the SQL was - but when we use BCP we get a few permission
events but nothing legible in the text data column.
This isn't an issue with the functionality of BCP, it's an issue with the
audit events that profiler picks up.
What I'd like is to find the same text captured in the permissions event
(which is part of the audit set of events) as it captured by the SQL
statements events (which logs the "insert bulk" statement and identifies the
table and columns).
Thanks.
J.T.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:cLXa5U3QEHA.3960@.cpmsftngxa10.phx.gbl...
> BCP will use Native mode by default unless you specify character mode.
> What exactly are you wanting to see?
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

c2 audit ,about hostname coloum value

Hi!
When the audit mode is set to 1 and reconfigured ,
Sql Profiler can read audit file which have a colum called HostName record
the computer name of source Computer. How can I change this vaue to the
source computer's IP address.
And Can I change the audit's file to another directory ?
thanks .HI,
There is no data column named Host IP address in profiler, as well as you
cant change the
data columns for C2 Audit option.
Can I change the audit's file to another directory ?
No, you cant change the directory.
Thanks
Hari
MCDBA
"william.huang" <william.huang@.saturn.yzu.edu.tw> wrote in message
news:OBTku6kXEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi!
> When the audit mode is set to 1 and reconfigured ,
> Sql Profiler can read audit file which have a colum called HostName
record
> the computer name of source Computer. How can I change this vaue to the
> source computer's IP address.
> And Can I change the audit's file to another directory ?
> thanks .
>

c0000005 EXCEPTION_ACCESS_VIOLATION when querying linked server

I have SQL 2K with SP4. Oracle client is installed on the Server. I have created linked server to Oracle. I am abld to connect to Oracle Server through DTS but when I query an oracle linked server SQl Server crashes with "EXCEPTION_ACCESS_VIOLATION" error.

Info on the Server:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

I have the SQL dump if you need that. Please help.

Thanks

Sreejith

Hi Sreejith,

I've moving your post to the Database Engine forum. Your issue isn't a documentation issue and you'll likely get a better response in that forum.

Thanks,

Gail Erickson

SQL Server Documentation Team

|||

Whilst I cannot help a lot I can recommend that you give a little more information:

Version of Oracle (and it's host) Middleware being used (ODBC vs OLEDB driver, whose, which version) Whether Oracle is local or remote Is it any query or specific queries|||

Can you please upload the dump file?

Thanks, Ron D.

c0000005 EXCEPTION_ACCESS_VIOLATION on Linked server access

Hi,
My server is running SQL Server 7.00.1063 on Windows 2000 Server SP3. A couple of linked server are configured on this server. These linked servers connect to SQL 7 servers, and also SQL 2000 servers.
If I try to use one of these linked servers in a SELECT query, I always get an access violation. System tables or user tables in any database, it don't work. A simple query like SELECT * from LINK1.master.dbo.sysprocesses crashes. Even a query on a non
-existing table (i.e. SELECT * FROM LINK1.my_db.dbo.unknowntable) crashes with an acces violation. I tried to create a new linked server, but this new one still don't work. Even worse: if I try SELECT * FROM A.B.C.D, It crashed with an access violation
instead of raising an error telling that A is not in sysservers...
I tried to reboot the server, but that didn't solve anything.
I ran a DBCC CHECKDB on all databases, but no error was found.
If this can helps to identify the problem, this is the Short Stack Dump found in the SQL000000.dmp files:
0x780011cd Module(MSVCRT+11cd) (wcslen+4)
0x005ec588 Module(sqlservr+1ec588) (FEqWsz+20)
0x00540ae6 Module(sqlservr+140ae6) (FOpenRange+ce)
0x004406f6 Module(sqlservr+406f6) (colnames+dac)
0x00440388 Module(sqlservr+40388) (colnames+7a)
0x004402d6 Module(sqlservr+402d6) (CProchdr::NormQuery+30)
0x00532811 Module(sqlservr+132811) (CProchdr::FCompile+1bf)
0x0040e1c8 Module(sqlservr+e1c8) (CSQLSource::FTransform+234)
0x00537769 Module(sqlservr+137769) (CSQLObject::FTransform2+31c)
0x0046b90d Module(sqlservr+6b90d) (CSQLObject::FGetFromDisk+627)
0x0041ff1c Module(sqlservr+1ff1c) (CSQLObject::FTransform+21a)
0x0060737b Module(sqlservr+20737b) (CSQLObject::PtrGetCmd+3e)
0x00636b94 Module(sqlservr+236b94) (FGetViewColumns+f6)
0x00540dcb Module(sqlservr+140dcb) (FOpenRange+412)
0x004406f6 Module(sqlservr+406f6) (colnames+dac)
0x00440388 Module(sqlservr+40388) (colnames+7a)
0x004402d6 Module(sqlservr+402d6) (CProchdr::NormQuery+30)
0x0043df13 Module(sqlservr+3df13) (CProchdr::FCompile+23f)
0x0040e1c8 Module(sqlservr+e1c8) (CSQLSource::FTransform+234)
0x00420394 Module(sqlservr+20394) (CSQLObject::FTransform2+1ab)
0x0046b90d Module(sqlservr+6b90d) (CSQLObject::FGetFromDisk+627)
0x0041ff1c Module(sqlservr+1ff1c) (CSQLObject::FTransform+21a)
0x0040dd22 Module(sqlservr+dd22) (CSQLSource::Execute+11d)
0x004ff1e3 Module(sqlservr+ff1e3) (CStmtExec::XretLocalExec+127)
0x004ff0a2 Module(sqlservr+ff0a2) (CStmtExec::XretExecute+253)
0x0040e9ab Module(sqlservr+e9ab) (CMsqlExecContext::ExecuteStmts+11b)
0x0040e4c0 Module(sqlservr+e4c0) (CMsqlExecContext::Execute+1bb)
This server has been built a year ago, and linked servers had always worked as expected until today...
Does anyone have an idea on how to solve this?
Thank you very much.
Eric Prevost
Hi,
I solved my problem. @.@.servername was returning NULL instead of server name. I used sp_dropserver / sp_addserver and restarted SQL Server. The problem is gone.

c0000005 EXCEPTION_ACCESS_VIOLATION on Linked server access

Hi,
My server is running SQL Server 7.00.1063 on Windows 2000 Server SP3. A cou
ple of linked server are configured on this server. These linked servers co
nnect to SQL 7 servers, and also SQL 2000 servers.
If I try to use one of these linked servers in a SELECT query, I always get
an access violation. System tables or user tables in any database, it don't
work. A simple query like SELECT * from LINK1.master.dbo.sysprocesses cras
hes. Even a query on a non
-existing table (i.e. SELECT * FROM LINK1.my_db.dbo.unknowntable) crashes wi
th an acces violation. I tried to create a new linked server, but this new
one still don't work. Even worse: if I try SELECT * FROM A.B.C.D, It crash
ed with an access violation
instead of raising an error telling that A is not in sysservers...
I tried to reboot the server, but that didn't solve anything.
I ran a DBCC CHECKDB on all databases, but no error was found.
If this can helps to identify the problem, this is the Short Stack Dump foun
d in the SQL000000.dmp files:
0x780011cd Module(MSVCRT+11cd) (wcslen+4)
0x005ec588 Module(sqlservr+1ec588) (FEqWsz+20)
0x00540ae6 Module(sqlservr+140ae6) (FOpenRange+ce)
0x004406f6 Module(sqlservr+406f6) (colnames+dac)
0x00440388 Module(sqlservr+40388) (colnames+7a)
0x004402d6 Module(sqlservr+402d6) (CProchdr::NormQuery+30)
0x00532811 Module(sqlservr+132811) (CProchdr::FCompile+1bf)
0x0040e1c8 Module(sqlservr+e1c8) (CSQLSource::FTransform+234)
0x00537769 Module(sqlservr+137769) (CSQLObject::FTransform2+31c)
0x0046b90d Module(sqlservr+6b90d) (CSQLObject::FGetFromDisk+627)
0x0041ff1c Module(sqlservr+1ff1c) (CSQLObject::FTransform+21a)
0x0060737b Module(sqlservr+20737b) (CSQLObject::PtrGetCmd+3e)
0x00636b94 Module(sqlservr+236b94) (FGetViewColumns+f6)
0x00540dcb Module(sqlservr+140dcb) (FOpenRange+412)
0x004406f6 Module(sqlservr+406f6) (colnames+dac)
0x00440388 Module(sqlservr+40388) (colnames+7a)
0x004402d6 Module(sqlservr+402d6) (CProchdr::NormQuery+30)
0x0043df13 Module(sqlservr+3df13) (CProchdr::FCompile+23f)
0x0040e1c8 Module(sqlservr+e1c8) (CSQLSource::FTransform+234)
0x00420394 Module(sqlservr+20394) (CSQLObject::FTransform2+1ab)
0x0046b90d Module(sqlservr+6b90d) (CSQLObject::FGetFromDisk+627)
0x0041ff1c Module(sqlservr+1ff1c) (CSQLObject::FTransform+21a)
0x0040dd22 Module(sqlservr+dd22) (CSQLSource::Execute+11d)
0x004ff1e3 Module(sqlservr+ff1e3) (CStmtExec::XretLocalExec+127)
0x004ff0a2 Module(sqlservr+ff0a2) (CStmtExec::XretExecute+253)
0x0040e9ab Module(sqlservr+e9ab) (CMsqlExecContext::ExecuteStmts+11b)
0x0040e4c0 Module(sqlservr+e4c0) (CMsqlExecContext::Execute+1bb)
This server has been built a year ago, and linked servers had always worked
as expected until today...
Does anyone have an idea on how to solve this?
Thank you very much.
Eric PrevostHi,
I solved my problem. @.@.servername was returning NULL instead of server name
. I used sp_dropserver / sp_addserver and restarted SQL Server. The proble
m is gone.

c0000005 EXCEPTION_ACCESS_VIOLATION after stopping/starting servi

On a nightly basis, SQL services are stopped to perform backups.
Afterwards the services are started.
This has been working for years.
Middle of last week, SQL has been failing to start.
SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
It requires a REBOOT to bring SQL back up.
No maintenace has been applied, Windows or SQL Server.
Win2K Server Standard Edition SP4
SQL Server SP4First question:
Have you seen this page yet? http://support.microsoft.com/?kbid=814572
Second question:
Why do you stop/start SQL to run backups? You can run "hot" backups
using the BACKUP command or a maintenance plan, then backup those
backup files.|||Tracey
Thanks for the prompt reply.
As for #2:
We have the oppurtunity to do so.
It's a cleaner backup.
I feel better with it.
If our nightly window gets tight, then we will switch to HOT backup only.
Yes, we do have a maintenance plan in place to do backups, reorg and index
maintenance.
This is not causing the prioblem.
We've been doing it this way for some time.
I'm the only SQL DBA this company has had.
Something changed last week.
It was not WIN maintenance.
It was not SQL Server maintenance.
As to #1:
Yes, I've seen that posting.
This is at SP4, or so I've been told, and has been for the past 6 months.
I used Microsoft Update and it indicates no fixes availible for Sql Server
2005.
Regards
Mark
"Tracy McKibben" wrote:
> First question:
> Have you seen this page yet? http://support.microsoft.com/?kbid=814572
> Second question:
> Why do you stop/start SQL to run backups? You can run "hot" backups
> using the BACKUP command or a maintenance plan, then backup those
> backup files.
>|||Found the problem.
It's the anti-virus software McAfee.
It upgraded itself the other week.
I've gotten around the problem by shutting down the McAfee services before
restarting the MS SQL services.
Right or wrong, it works.
"Mark Kuntz" wrote:
> On a nightly basis, SQL services are stopped to perform backups.
> Afterwards the services are started.
> This has been working for years.
> Middle of last week, SQL has been failing to start.
> SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> It requires a REBOOT to bring SQL back up.
> No maintenace has been applied, Windows or SQL Server.
> Win2K Server Standard Edition SP4
> SQL Server SP4

c0000005 EXCEPTION_ACCESS_VIOLATION after stopping/starting servi

On a nightly basis, SQL services are stopped to perform backups.
Afterwards the services are started.
This has been working for years.
Middle of last week, SQL has been failing to start.
SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
It requires a REBOOT to bring SQL back up.
No maintenace has been applied, Windows or SQL Server.
Win2K Server Standard Edition SP4
SQL Server SP4First question:
Have you seen this page yet? http://support.microsoft.com/?kbid=814572
Second question:
Why do you stop/start SQL to run backups? You can run "hot" backups
using the BACKUP command or a maintenance plan, then backup those
backup files.|||Found the problem.
It's the anti-virus software McAfee.
It upgraded itself the other week.
I've gotten around the problem by shutting down the McAfee services before
restarting the MS SQL services.
Right or wrong, it works.
"Mark Kuntz" wrote:

> On a nightly basis, SQL services are stopped to perform backups.
> Afterwards the services are started.
> This has been working for years.
> Middle of last week, SQL has been failing to start.
> SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> It requires a REBOOT to bring SQL back up.
> No maintenace has been applied, Windows or SQL Server.
> Win2K Server Standard Edition SP4
> SQL Server SP4

c0000005 EXCEPTION_ACCESS_VIOLATION

We have SQL Server 2000 with SP3 installed on Windows 2000 Advance Server. Server has 8 GB RAM and 4 CPU. Few days back we have installed multiple named instance on this server .Now we have assign each CPU to individual instance and min server memory to 1024 and max server memory is kept open.

After this we are facing an issue with default instance for exception_access_violation as below ...
Memory
MemoryLoad = 83%
Total Physical = 7679 MB
Available Physical = 1252 MB
Total Page File = 15480 MB
Available Page File = 7756 MB
Total Virtual = 2047 MB
Available Virtual = 344 MB

*Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDu
mp0022.txt
* ************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 07/24/07 00:46:02 spid 16
*
* Exception Address = 008405D8 (DeadlockMonitor::ResolveDeadlock + 00000025 L
ine 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C627FFF 000b8000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77D9EFFF 0006f000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7DFFF 0003e000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 028D0000 0291FFFF 00050000
* Secur32 02920000 0292EFFF 0000f000
* NTDSAPI 02930000 02940FFF 00011000
* DNSAPI 02950000 02973FFF 00024000
* WSOCK32 02980000 02987FFF 00008000
* WS2_32 02990000 029A3FFF 00014000
* WS2HELP 029B0000 029B7FFF 00008000
* WLDAP32 029C0000 029E9FFF 0002a000
* NETRAP 029F0000 029F5FFF 00006000
* SAMLIB 02A00000 02A0EFFF 0000f000
* ole32 02D70000 02E5EFFF 000ef000
* XOLEHLP 02E60000 02E67FFF 00008000
* MSDTCPRX 02E70000 02F2AFFF 000bb000
* MTXCLU 02F30000 02F3FFFF 00010000
* VERSION 02F40000 02F46FFF 00007000
* LZ32 02F50000 02F55FFF 00006000
* CLUSAPI 02F60000 02F6FFFF 00010000
* RESUTILS 02F70000 02F7CFFF 0000d000
* USERENV 02F80000 02FE0FFF 00061000
* rnr20 02FF0000 02FFBFFF 0000c000
* iphlpapi 03040000 03052FFF 00013000
* ICMP 03060000 03064FFF 00005000
* MPRAPI 03070000 03086FFF 00017000
* OLEAUT32 03090000 0312AFFF 0009b000
* ACTIVEDS 03130000 0315EFFF 0002f000
* ADSLDPC 03160000 03182FFF 00023000
* RTUTILS 03190000 0319DFFF 0000e000
* SETUPAPI 031A0000 0322DFFF 0008e000
* RASAPI32 03230000 03262FFF 00033000
* RASMAN 03270000 03280FFF 00011000
* TAPI32 03290000 032B1FFF 00022000
* COMCTL32 032C0000 03343FFF 00084000
* SHLWAPI 03350000 033B5FFF 00066000
* DHCPCSVC 033C0000 033D8FFF 00019000
* winrnr 03880000 03887FFF 00008000
* rasadhlp 03890000 03894FFF 00005000
* SSNETLIB 04040000 04054FFF 00015000
* SSNMPN70 04090000 04095FFF 00006000
* security 043B0000 043B3FFF 00004000
* msafd 04850000 0486DFFF 0001e000
* wshtcpip 048B0000 048B6FFF 00007000
* SSmsLPCn 04940000 04946FFF 00007000
* mswsock 049D0000 049E1FFF 00012000
* msv1_0 04A30000 04A50FFF 00021000
* CRYPT32 04A60000 04AE6FFF 00087000
* MSASN1 04B10000 04B1FFFF 00010000
* rsabase 04F40000 04F62FFF 00023000
* CLBCATQ 05280000 0530EFFF 0008f000
* SQLOLEDB 05310000 05382FFF 00073000
* MSDART 05390000 053AEFFF 0001f000
* comdlg32 053B0000 053EDFFF 0003e000
* SHELL32 053F0000 05635FFF 00246000
* MSDATL3 05640000 05654FFF 00015000
* oledb32 05CE0000 05D45FFF 00066000
* OLEDB32R 05D50000 05D5FFFF 00010000
* xpstar 05DE0000 05E26FFF 00047000
* SQLRESLD 05E30000 05E36FFF 00007000
* SQLSVC 05E40000 05E56FFF 00017000
* ODBC32 05E60000 05E91FFF 00032000
* odbcbcp 05EA0000 05EA5FFF 00006000
* W95SCM 05EB0000 05EBBFFF 0000c000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 05EC0000 05EDDFFF 0001e000
* MPR 05EE0000 05EEFFFF 00010000
* SHFOLDER 05EF0000 05EF7FFF 00008000
* odbcint 061C0000 061D5FFF 00016000
* NDDEAPI 061E0000 061E6FFF 00007000
* SQLSVC 061F0000 061F5FFF 00006000
* xpstar 06200000 06208FFF 00009000
* xplog70 06AA0000 06AB1FFF 00012000
* xplog70 06AC0000 06AC3FFF 00004000
* xpsqlbot 06AD0000 06AD5FFF 00006000
* SQLFTQRY 09200000 09231FFF 00032000
* impprov 094E0000 094F8FFF 00019000
* DBNETLIB 09A80000 09A8EFFF 0000f000
* SQLOLEDB 09BD0000 09BDEFFF 0000f000
* sqlvdi 09C20000 09C2BFFF 0000c000
* dbghelp 07BE0000 07C94FFF 000b5000
*

Any idea ?Can you install SP4? this KB seems to indicate this is fixed in SP4: http://support.microsoft.com/kb/821741/en-us?spid=2852&sid=1070

What's in the SQL Server log file just before the dump?|||Is there any workaround other than upgrading to SP4. as SQL Server crashing daily twise and SP4 upgrade testing will take atleast a week time.|||I don't have a workaround for you, sorry. Maybe PSS could suggest one if you call them.|||As suggested only MS PSS can give more idea why the stack dump is created. It is better to proceed that way to resolve this issue and also SP3 for SQL2000 is no more supported, you have to test and upgrade to SP4 for SQL.

c0000005 EXCEPTION_ACCESS_VIOLATION

I have searched this newsgroup and Google. It seems that with this error I
should just call PSS? The SQL (see error.log attached) runs fine from Query
Analyzer, but not from my application (other queries run fine though). It
worked up until yesterday. I rebooted the server. I had an associate apply
SP4, but it still throws this exception. I'm having my partner run Dell
diags on it during lunch. The server is in California, I'm in Tennessee.
I also get this Events in the Event Log when the query is fired:
Event 17052, SOURCE: MSSQLSERVER
Error: 0, Severity: 19, State: 0
language_exec: Process 57 generated an access violation. SQL Server is
terminating this process.
AND
Event 17052, SOURCE: MSSQLSERVER
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
begin 666 error.log
M4W%L1'5M<$5X8V5P=&EO;DAA;F1L97(Z(%!R;V-E<W,@.-3(@.9V5N97)A=&5D
M(&9A=&%L(&5X8V5P=&EO;B!C,# P,# P-2!%6$-%4%1)3TY?04-#15-37U9)
M3TQ!5$E/3BX@.#0I344P@.4V5R=F5R(&ES('1E<FUI;F%T:6YG('1H:7,@.<' )O
M8V5S<RXN#0HJ("HJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ* BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ* BHJ*BHJ*BH-
M"BH-"BH@.0D5'24X@.4U1!0TL@.1%5-4#H-"BH@.(" P.2\P-R\P-2 P.#HR-#HQ
M-"!S<&ED(#4R#0HJ#0HJ(" @.17AC97!T:6]N($%D9')E<W,@./2 P,#0T1#%%
M,PT**B @.($5X8V5P=&EO;B!#;V1E(" @.(#T@.8S P,# P,#4@.15A#15!424].
M7T%#0T534U]624],051)3TX-"BH@.("!!8V-E<W,@.5FEO;&%T:6]N(&]C8W5R
M<F5D(')E861I;F<@.861D<F5S<R P,S(Y,# P, T**B!);G!U="!"=69F97(@.
M,S<V(&)Y=&5S("T-"BH@.(%-%3$5#5"!#05-%(&QE;BAR97!L86-E*&QO8V%T
M:6]N+"=B9RTG+"<G*2D@.5TA%3B Q(%1(14X@.)T)'+3 G("L@.<F5P;&%C90T*
M*B @.*&QO8V%T:6]N+"=B9RTG+"<G*2!%3%-%(&QO8V%T:6]N($5.1"P@.<&%R
M=&YU;2P@.=F5N9&]R+"!C87-E;G5M($923TT@.8V5N#0HJ("!T<F%L+F1B;RYT
M8FQG;'-I;G9S;F%P(%=(15)%(&1I=CTG3$U))R!!3D0@.;&]C871I;VX@.3$E+
M12 G0D<E)R!!3D0@.0T].5D4-"BH@.(%)4*&YV87)C:&%R+'-N87!D871E+#$P
M,2D])S Y+S Q+S(P,#4G($]21$52($)9($-!4T4@.;&5N*')E<&QA8V4H;&]C
M871I;PT**B @.;BPG8F<M)RPG)RDI(%=(14X@.,2!42$5.("="1RTP)R K(')E
M<&QA8V4H;&]C871I;VXL)V)G+2<L)R<I($5,4T4@.;&]C871I#0HJ("!O;B!%
M3D0L('!A<G1N=6T@.#0HJ(" -"BH-"BH@.($U/1%5,12 @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.0D%312 @.(" @.($5.1" @.(" @.("!325I%#0HJ('-Q;'-E
M<G9R(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,#0P,# P," @.,#!#0D%&1D8@.
M(# P.&)B,# P#0HJ(&YT9&QL(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W
M0S@.P,# P," @.-T,X0D9&1D8@.(# P,&,P,# P#0HJ(&ME<FYE;#,R(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" W-T4T,# P," @.-S=&-#%&1D8@.(# P,3 R,# P
M#0HJ($%$5D%023,R(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W-T8U,# P," @.
M-S=&14)&1D8@.(# P,#EC,# P#0HJ(%)00U)4-" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" W-T,U,# P," @.-S=#145&1D8@.(# P,#EF,# P#0HJ($U35D-0
M-S$@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W0S-!,# P," @.-T,T,4%&1D8@.
M(# P,#=B,# P#0HJ($U35D-2-S$@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W
M0S,T,# P," @.-T,S.35&1D8@.(# P,#4V,# P#0HJ(&]P96YD<S8P(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" T,3 V,# P," @.-#$P-C5&1D8@.(# P,# V,# P
M#0HJ(%-(14Q,,S(@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W0SA$,# P," @.
M-T0P1#)&1D8@.(# P.# S,# P#0HJ($=$23,R(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" W-T,P,# P," @.-S=#-#=&1D8@.(# P,#0X,# P#0HJ(%5315(S
M,B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W-S,X,# P," @.-S<T,3%&1D8@.
M(# P,#DR,# P#0HJ(&US=F-R=" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W
M-T)!,# P," @.-S="1CE&1D8@.(# P,#5A,# P#0HJ(%-(3%=!4$D@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" W-T1!,# P," @.-S=$1C%&1D8@.(# P,#4R,# P
M#0HJ('-Q;'-O<G0@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" T,D%%,# P," @.
M-#)"-D9&1D8@.(# P,#DP,# P#0HJ('5M<R @.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" T,3 W,# P," @.-#$P-T1&1D8@.(# P,#!E,# P#0HJ(&-O;6-T
M;#,R(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" W-S0R,# P," @.-S<U,C)&1D8@.
M(# P,3 S,# P#0HJ('-Q;&5V;C<P(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" T
M,3 X,# P," @.-#$P.$%&1D8@.(# P,#!B,# P#0HJ($Y%5$%023,R(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P,S(P,# P," @.,#,R-3=&1D8@.(# P,#4X,# P
M#0HJ($%55$A" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,S(V,# P," @.
M,#,R-S-&1D8@.(# P,#$T,# P#0HJ($-/35)%4R @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P,S8Q,# P," @.,#,V1#5&1D8@.(# P,&,V,# P#0HJ(&]L93,R
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,S9%,# P," @.,#,X,3-&1D8@.
M(# P,3,T,# P#0HJ(%A/3$5(3% @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M,SA!,# P," @.,#,X035&1D8@.(# P,# V,# P#0HJ($U31%1#4%)8(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P,SA",# P," @.,#,Y,C=&1D8@.(# P,#<X,# P
M#0HJ(&US=F-P-C @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,SDS,# P," @.
M,#,Y.3!&1D8@.(# P,#8Q,# P#0HJ($U46$-,52 @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P,SE!,# P," @.,#,Y0CA&1D8@.(# P,#$Y,# P#0HJ(%9%4E-)
M3TX@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,SE#,# P," @.,#,Y0S=&1D8@.
M(# P,# X,# P#0HJ(%=33T-+,S(@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M,SE$,# P," @.,#,Y1#A&1D8@.(# P,# Y,# P#0HJ(%=3,E\S,B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P,SE%,# P," @.,#,Y1C9&1D8@.(# P,#$W,# P
M#0HJ(%=3,DA%3% @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,T$P,# P," @.
M,#-!,#=&1D8@.(# P,# X,# P#0HJ($],14%55#,R(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P,T$Q,# P," @.,#-!.4)&1D8@.(# P,#AC,# P#0HJ($-,55-!
M4$D@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,T%%,# P," @.,#-!1C%&1D8@.
M(# P,#$R,# P#0HJ(%)%4U5424Q3(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M,T(P,# P," @.,#-",3)&1D8@.(# P,#$S,# P#0HJ(%5315)%3E8@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P,T(R,# P," @.,#-"13-&1D8@.(# P,&,T,# P
M#0HJ('-E8W5R,S(@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,T)&,# P," @.
M,#-#,#)&1D8@.(# P,#$S,# P#0HJ($EN=F%L:60@.061D<F5S<R @.(" @.(" @.
M(" @.(" @.(" P,T,R,# P," @.,#-#-C!&1D8@.(# P,#0Q,# P#0HJ($EN=F%L
M:60@.061D<F5S<R @.(" @.(" @.(" @.(" @.(" P,T,W,# P," @.,#-#.3A&1D8@.
M(# P,#(Y,# P#0HJ('=I;G)N<B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M,T-%,# P," @.,#-#139&1D8@.(# P,# W,# P#0HJ(%=,1$%0,S(@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P,T-&,# P," @.,#-$,41&1D8@.(# P,#)E,# P
M#0HJ(')A<V%D:&QP(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,T0T,# P," @.
M,#-$-#1&1D8@.(# P,# U,# P#0HJ($Y434%25$$@.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P,$4R,# P," @.,#!%-#%&1D8@.(# P,#(R,# P#0HJ(%-!34Q)
M0B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P,$4U,# P," @.,#!%-45&1D8@.
M(# P,#!F,# P#0HJ(%-33D543$E"(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M,$4W,# P," @.,#!%.#5&1D8@.(# P,#$V,# P#0HJ('-E8W5R:71Y(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P,$4Y,# P," @.,#!%.3-&1D8@.(# P,# T,# P
M#0HJ(&AN971C9F<@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-#@.T,# P," @.
M,#0X.3A&1D8@.(# P,#4Y,# P#0HJ('=S:'1C<&EP(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-#A%,# P," @.,#0X13=&1D8@.(# P,# X,# P#0HJ(%-3;7-,
M4$-N(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-#DW,# P," @.,#0Y-S=&1D8@.
M(# P,# X,# P#0HJ(%-3;FU03C<P(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-#DX,# P," @.,#0Y.#9&1D8@.(# P,# W,# P#0HJ(&YT9'-A<&D@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-$$Q,# P," @.,#1!,C1&1D8@.(# P,#$U,# P
M#0HJ(&ME<F)E<F]S(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-3!#,# P," @.
M,#4Q,3=&1D8@.(# P,#4X,# P#0HJ(&-R>7!T9&QL(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-3$R,# P," @.,#4Q,D)&1D8@.(# P,#!C,# P#0HJ($U305-.
M,2 @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-3$S,# P," @.,#4Q-#%&1D8@.
M(# P,#$R,# P#0HJ(%-13$9445)9(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-$(T,# P," @.,#1"-C5&1D8@.(# P,#(V,# P#0HJ('AP<W R<F5S(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" Q,# P,# P," @.,3 R0S1&1D8@.(# P,F,U,# P
M#0HJ($-,0D-A=%$@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-$(W,# P," @.
M,#1"1C)&1D8@.(# P,#@.S,# P#0HJ('-Q;&]L961B(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-$,R,# P," @.,#1#03!&1D8@.(# P,#@.Q,# P#0HJ($U31$%2
M5" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-$-",# P," @.,#1#0SE&1D8@.
M(# P,#%A,# P#0HJ($U31$%43#,@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-$-$,# P," @.,#1#131&1D8@.(# P,#$U,# P#0HJ(&]L961B,S(@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-34V,# P," @.,#4U1#A&1D8@.(# P,#<Y,# P
M#0HJ($],141",S)2(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-35%,# P," @.
M,#4U1C!&1D8@.(# P,#$Q,# P#0HJ(')S865N:" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-38P,# P," @.,#4V,D5&1D8@.(# P,#)F,# P#0HJ(%!305!)
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-31$,# P," @.,#4T1$%&1D8@.
M(# P,#!B,# P#0HJ(&US=C%?," @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-38S,# P," @.,#4V-39&1D8@.(# P,#(W,# P#0HJ(&EP:&QP87!I(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-38V,# P," @.,#4V-SE&1D8@.(# P,#%A,# P
M#0HJ('AP<W1A<B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-38Y,# P," @.
M,#4V1$-&1D8@.(# P,#1D,# P#0HJ(%-13%)%4TQ$(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-39%,# P," @.,#4V14)&1D8@.(# P,#!C,# P#0HJ(%-13%-6
M0R @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-39&,# P," @.,#4W,$%&1D8@.
M(# P,#%B,# P#0HJ($]$0D,S,B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-3<Q,# P," @.,#4W-$-&1D8@.(# P,#-D,# P#0HJ($-/34-43#,R(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-3<U,# P," @.,#4W139&1D8@.(# P,#DW,# P
M#0HJ(&-O;61L9S,R(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-3=&,# P," @.
M,#4X,SE&1D8@.(# P,#1A,# P#0HJ(&]D8F-B8W @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-3@.T,# P," @.,#4X-#5&1D8@.(# P,# V,# P#0HJ(%<Y-5-#
M32 @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-3@.U,# P," @.,#4X-4-&1D8@.
M(# P,#!D,# P#0HJ(%-13%5.25),(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-3@.V,# P," @.,#4X.$-&1D8@.(# P,#)D,# P#0HJ(%=)3E-03T],(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-3@.Y,# P," @.,#4X0C9&1D8@.(# P,#(W,# P
M#0HJ(%-(1D],1$52(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-3A#,# P," @.
M,#4X0SA&1D8@.(# P,# Y,# P#0HJ(&]D8F-I;G0@.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-4%!,# P," @.,#5!0C9&1D8@.(# P,#$W,# P#0HJ($Y$1$5!
M4$D@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-4)$,# P," @.,#5"1#9&1D8@.
M(# P,# W,# P#0HJ(%-13%-60R @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-4)%,# P," @.,#5"135&1D8@.(# P,# V,# P#0HJ('AP<W1A<B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-4)&,# P," @.,#5"1CA&1D8@.(# P,# Y,# P
M#0HJ($%#5$E61413(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-4,P,# P," @.
M,#5#,S)&1D8@.(# P,#,S,# P#0HJ(&%D<VQD<&,@.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-4,T,# P," @.,#5#-C9&1D8@.(# P,#(W,# P#0HJ(&-R961U
M:2 @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-4,W,# P," @.,#5#.41&1D8@.
M(# P,#)E,# P#0HJ($%43" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-4-!,# P," @.,#5#0C=&1D8@.(# P,#$X,# P#0HJ(&%D<VQD<" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" P-40R,# P," @.,#5$-$1&1D8@.(# P,#)E,# P
M#0HJ(%-84R @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-45$,# P," @.
M,#5&.$)&1D8@.(# P,&)C,# P#0HJ('AP;&]G-S @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" P-48Y,# P," @.,#5&.45&1D8@.(# P,#!F,# P#0HJ('AP;&]G
M-S @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P-49!,# P," @.,#5&031&1D8@.
M(# P,# U,# P#0HJ(&1B9VAE;' @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" P
M-C!",# P," @.,#8Q049&1D8@.(# P,3 P,# P#0HJ#0HJ(" @.(" @.("!%9&DZ
M(# P,# P,# Q.B -"BH@.(" @.(" @.($5S:3H@.,#,R.3 S0T$Z( T**B @.(" @.
M(" @.16%X.B P,S(X1D9&13H@.#0HJ(" @.(" @.("!%8G@.Z(# U-35&,D,P.B P
M,# P,# P-B @.,# P,# P,#4@.(#0S-#8Q-S8P(" P,38R.$9#," @.-#)#-44Y
M138@.(#0S,C@.Y,D,X(" -"BH@.(" @.(" @.($5C>#H@.,#,R.$9&0T4Z(# P-D4P
M,#4U(" P,#<T,# V.2 @.,# W.# P-C4@.(# P-#<P,#(P(" P,#8Q,# V0R @.
M,# W,S P-S,@.( T**B @.(" @.(" @.161X.B P,# P,#%&13H@.#0HJ(" @.(" @.
M("!%:7 Z(# P-#1$,44S.B!&.3@.S,#@.X0B @.,3DX-C!&-T8@.(#A",# P-#DR
M("!&,#A"1D,T1" @.1D5$,48Q,D(@.(#@.T,$9$,C@.U(" -"BH@.(" @.(" @.($5B
M<#H@.,#4U-48R.#0Z(# U-35&-$%#(" P,#4S-C-!02 @.,# P,# P,#$@.(# U
M-35&,D$X(" P,# P,#%&12 @.,#4U-48U-#@.@.( T**B @.(" @.(%-E9T-S.B P
M,# P,# Q0CH@.#0HJ(" @.("!%1FQA9W,Z(# P,#$P,C@.S.B T1C P,# P," @.
M-3 P,#1$,# @.(#4T,# T,3 P(" S1# P-#@.P," @.,T$P,#0S,# @.(#4P,# U
M0S P(" -"BH@.(" @.(" @.($5S<#H@.,#4U-48R-S Z(# S,CA&1D-%(" P,# P
M,#1%-" @.-#,T-C@.P0S @.(# P,# P-$4T(" P,S(X1D9#12 @.,#4U-48T04,@.
M( T**B @.(" @.(%-E9U-S.B P,# P,# R,SH@.#0HJ("HJ*BHJ*BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ* BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BH-"BH@.+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+ 2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+0T**B!3:&]R="!3=&%C:R!$=6UP#0HJ(# P-#1$,44S
M($UO9'5L92AS<6QS97)V<BLP,# T1#%%,RD-"BH@.,# U,S8S04$@.36]D=6QE
M*'-Q;'-E<G9R*S P,3,V,T%!*0T**B P,#4S-C,R."!-;V1U;&4H<W%L<V5R
M=G(K,# Q,S8S,C@.I#0HJ(# P-#(Y1D$Y($UO9'5L92AS<6QS97)V<BLP,# R
M.49!.2D-"BH@.,# T,$,S03<@.36]D=6QE*'-Q;'-E<G9R*S P,#!#,T$W*0T*
M*B P,#0Q1#$W."!-;V1U;&4H<W%L<V5R=G(K,# P,40Q-S@.I#0HJ(# P-#(Y
M.30Q($UO9'5L92AS<6QS97)V<BLP,# R.3DT,2D-"BH@.,# T,CE%04$@.36]D
M=6QE*'-Q;'-E<G9R*S P,#(Y14%!*0T**B P,#0Q-40P-"!-;V1U;&4H<W%L
M<V5R=G(K,# P,35$,#0I#0HJ(# P-#$V,C$T($UO9'5L92AS<6QS97)V<BLP
M,# Q-C(Q-"D-"BH@.,# T,35&,C@.@.36]D=6QE*'-Q;'-E<G9R*S P,#$U1C(X
M*0T**B P,#0Y0S,R12!-;V1U;&4H<W%L<V5R=G(K,# P.4,S,D4I#0HJ(# P
M-#E#-#9!($UO9'5L92AS<6QS97)V<BLP,# Y0S0V02D-"BH@.-#$P-S4S,#D@.
M36]D=6QE*'5M<RLP,# P-3,P.2D@.*%!R;V-E<W-7;W)K4F5Q=65S=',K,# P
M,# R1#D@.3&EN92 T-38K,# P,# P,# I#0HJ(#0Q,#<T.3<X($UO9'5L92AU
M;7,K,# P,#0Y-S@.I("A4:')E8613=&%R=%)O=71I;F4K,# P,# P.3@.@.3&EN
M92 R-C,K,# P,# P,#<I#0HJ(#=#,S0Y-#!&($UO9'5L92A-4U9#4C<Q*S P
M,# Y-#!&*2 H96YD=&AR96%D*S P,# P,$%!*0T**B W-T4V-C V,R!-;V1U
M;&4H:V5R;F5L,S(K,# P,C8P-C,I("A'971-;V1U;&5&:6QE3F%M94$K,# P
M,# P14(I#0HJ("TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+ 2TM+2TM
;+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
`
end
"Mike Smith" <msmith@.larrymethvin.com> wrote in message
news:OS7pVV9sFHA.3752@.TK2MSFTNGP09.phx.gbl...
> I have searched this newsgroup and Google. It seems that with this error I
> should just call PSS? The SQL (see error.log attached) runs fine from
Query
> Analyzer, but not from my application (other queries run fine though). It
> worked up until yesterday. I rebooted the server. I had an associate apply
> SP4, but it still throws this exception. I'm having my partner run Dell
> diags on it during lunch. The server is in California, I'm in Tennessee.
> I also get this Events in the Event Log when the query is fired:
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> language_exec: Process 57 generated an access violation. SQL Server is
> terminating this process.
> AND
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
Sorry, specs:
Dell PowerEdge, Windows 2003 SP1, SQL2000 SP4.
The only change I am aware of is SP4, previously (yesterday), it had SP3a.
Regards,
Mike Smith
msmith@.larrymethvin.com
|||"Mike Smith" <msmith@.larrymethvin.com> wrote in message
news:OS7pVV9sFHA.3752@.TK2MSFTNGP09.phx.gbl...
>I have searched this newsgroup and Google. It seems that with this error I
> should just call PSS?
Yes.
David
|||"Mike Smith" <msmith@.larrymethvin.com> wrote in message
news:OS7pVV9sFHA.3752@.TK2MSFTNGP09.phx.gbl...
> I have searched this newsgroup and Google. It seems that with this error I
> should just call PSS? The SQL (see error.log attached) runs fine from
Query
> Analyzer, but not from my application (other queries run fine though). It
> worked up until yesterday. I rebooted the server. I had an associate apply
> SP4, but it still throws this exception. I'm having my partner run Dell
> diags on it during lunch. The server is in California, I'm in Tennessee.
> I also get this Events in the Event Log when the query is fired:
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> language_exec: Process 57 generated an access violation. SQL Server is
> terminating this process.
> AND
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
For the sake of the list, and anyone else that may have this problem. I
checked my log files, they were HUGE! We had moved servers, and whoever
setup the backups didn't back up the logs. I shrank the logs using the
method in: http://support.microsoft.com/kb/272318

c0000005 EXCEPTION_ACCESS_VIOLATION

"Mike Smith" <msmith@.larrymethvin.com> wrote in message
news:OS7pVV9sFHA.3752@.TK2MSFTNGP09.phx.gbl...
> I have searched this newsgroup and Google. It seems that with this error I
> should just call PSS? The SQL (see error.log attached) runs fine from
Query
> Analyzer, but not from my application (other queries run fine though). It
> worked up until yesterday. I rebooted the server. I had an associate apply
> SP4, but it still throws this exception. I'm having my partner run Dell
> diags on it during lunch. The server is in California, I'm in Tennessee.
> I also get this Events in the Event Log when the query is fired:
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> language_exec: Process 57 generated an access violation. SQL Server is
> terminating this process.
> AND
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
Sorry, specs:
Dell PowerEdge, Windows 2003 SP1, SQL2000 SP4.
The only change I am aware of is SP4, previously (yesterday), it had SP3a.
Regards,
Mike Smith
msmith@.larrymethvin.com"Mike Smith" <msmith@.larrymethvin.com> wrote in message
news:OS7pVV9sFHA.3752@.TK2MSFTNGP09.phx.gbl...
>I have searched this newsgroup and Google. It seems that with this error I
> should just call PSS?
Yes.
David|||"Mike Smith" <msmith@.larrymethvin.com> wrote in message
news:OS7pVV9sFHA.3752@.TK2MSFTNGP09.phx.gbl...
> I have searched this newsgroup and Google. It seems that with this error I
> should just call PSS? The SQL (see error.log attached) runs fine from
Query
> Analyzer, but not from my application (other queries run fine though). It
> worked up until yesterday. I rebooted the server. I had an associate apply
> SP4, but it still throws this exception. I'm having my partner run Dell
> diags on it during lunch. The server is in California, I'm in Tennessee.
> I also get this Events in the Event Log when the query is fired:
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> language_exec: Process 57 generated an access violation. SQL Server is
> terminating this process.
> AND
> Event 17052, SOURCE: MSSQLSERVER
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
For the sake of the list, and anyone else that may have this problem. I
checked my log files, they were HUGE! We had moved servers, and whoever
setup the backups didn't back up the logs. I shrank the logs using the
method in: http://support.microsoft.com/kb/272318

C++ SSCE example

Hi

Does anyone have an example code in C++ to create a SSCE db and access data?

Many thanks

Ozzie

Install the developer tools SDK. You you find at the following location assuming default installation path.

C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\Samples\NorthwindOleDb.zip

This is a device sample, but you can port it to desktop. Or you can copy paste code, the code for creating/opening and other database operations would be the same for device & desktop.

|||I have attempted to run the NorthwindOleDb project. The project builds without errors and when I start it it opens in the Pocket PC 2003 emulator but fails when trying to create the dialog to display employee info and fails at the line:
hr = InitDatabase();
I have SSCE dll's installed, the SSCE SDK and VS 2005 SP1. Any suggestions would be greatly appreciated. Im sure this should just work straight out of the box.

Ozzie