MSDE not starting properly

I have MSDE come up when my system boots, but the server name does not appear
in the 1st dropdown box. So, I have to type the server name in and click the
start button in the MSDE window to get it to come up. I just want it to
start at boot-up, and be there without having to type the server name in
every time. Help.
You have the following options:
1. Add the following statement to Win.ini
Run = "SCM -Action 1 -Service mssqlserver -Silent"
2. Run the following in DOS:
REM modify SCM
SCM -Action 7 -Service mssqlserver -SvcStartType 2 -Silent
REM start sql service now
SCM -Action 1 -Service mssqlserver -Silent
"Tom Nowak" <TomNowak@.discussions.microsoft.com> wrote in message
news:BB6F9956-3BD9-4B00-A332-A5D79EC1ABAB@.microsoft.com...
> I have MSDE come up when my system boots, but the server name does not
appear
> in the 1st dropdown box. So, I have to type the server name in and click
the
> start button in the MSDE window to get it to come up. I just want it to
> start at boot-up, and be there without having to type the server name in
> every time. Help.

MSDE limitations

I'd like to use MSDE since it's free instead of SQL Server for my database. I will be hosting a portal type site. If all goes well and my site is wildly successful are there any limitations in MSDE that I need to worry about?

For instance, I thought there was a limit to the number of connections. I thought I remember seeing 5 or 50 on the microsoft download site.

If there is a connection limit of say 10, what happens when connection 11 comes in? Does it just wait for a free connection or does it fail?

Is anyone using is as the database on a large portal site? How many users are there in total? How many connected at the same time?

I am under the assumption that it is SQL Server underneath, so I assume the performance and abilities are very good. Is this a fair assumption?

Thanks for the inputSome of the limitations of MSDE:

25 concurrent users
2 GB max Database size
No Enterprsie manager|||::For instance, I thought there was a limit to the number of connections.

Less thinking and more reading helps against this. I haved no clue why everyone thinks there is a 10 connection limit on MSDE, when the documentation provided, the readme and the FAW to msde pretty clearly say what is there and how it is there.

::If there is a connection limit of say 10, what happens when connection 11 comes in?

TRIED reading the documentation?

You know the one you find at:
http://www.microsoft.com/sql/msde/

more concrete the document you find at:
http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true

::Does it just wait for a free connection or does it fail?

I will quote - I hope you understand it:
::Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and MSDE 2000
::allow 32,767 connections to an instance of the database engine. There is no limit for the
::number of connections that can be executing operations at the same time. The only effect
::of the workload governor is that it starts slowing down the database engine when more
::than eight operations are actively running at the same time.

Clearn enough? More info on the document provided.

::Is anyone using is as the database on a large portal site?

Define large.

::How many users are there in total? How many connected at the same time?

Irrelevant. No user connects at the same time. THink how web applications work. MSDE can handle 8 concurrentoperations - this is at least 8 concurrent pages being served. If you manage to hammer out a page in 0.1 seconds, this means per second you can serve 80 requests. If a user requests a page every 10 seconds average, this means you can serve 800 users WITHOUT ANY CACHING. If you are a little smart in your use of output caching, you can run this number up to some thousand (4000-5000) without any sweat. It all depends how dynamic your portal really is - and how smart or dump your usage of various caching levels is. Remmeber: cache as early as possible (output cache), as you get the most gain there.

::I am under the assumption that it is SQL Server underneath,

No. They share the same codebase, but SQL Server is not "underneath" it (whatever this is supposed to mean in IT).|||I'm sorry I failed to remember everything I read on their site. I was looking for information on how useful MSDE is in production environments. I was looking to run a .Text blog or some other such portal that used MSDE as the database. From reading on Microsoft.com I find the following:

"Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that's ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users."

This tells me that I should *not* be using MSDE for production type sites. I was just wondering if anyone had any first hand experience using it on a web site serving up to more than "25 concurrent users". I was also wondering how many visitors a day would equal "25 concurrent users" since site visitors are generally spread out over the day. I was wondering how many users *the site* had (not the database) and how many of the *site* users are typically using the site at the same time (not neccessarily the database).

Now that I've gone back to read the documentation on their site, I see that my initial questions are not answered by Microsoft. I thought the number was somewhere between 5 and 50, it's 25. They do not define what "25 concurrent users" are or how it affects scaling of the database. They indicate that one can "migrated to SQL Server 2000 technology if the customer or end user wants to scale the solution up to thousands of users or terabytes of data." but there is a lot of ground between this and the 25 concurrent users quote above with no documentation provided as to what happens to msde when you go over 25 concurrent users.|||Wow, what an arrogant guy. My first time here, and i see this kind of junk right off the bat? I thought i'd help out, but it seems none is needed. I do find it interesting that someone who goes out of their way to peddle their own wares (link under username, MVP banner, and sales-begging tagline) wouldn't be such an ass. I look forward to catching one of your questions in the future. No matter how good at something you think you are, there's always someone better.|||ps.

from: http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs

"What does Microsoft expect of its MVPs?
Because the MVP Award is an award-based program whose criteria are based on past contributions, Microsoft has no expectations of MVPs beyond the expectations of courtesy, professionalism, and adherence to the community rules that we ask of all Microsoft community members."

Sounds like you forgot to read that. See professionalism, courtesy, etc.

MSDE Installation Help

Hi
I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
....
"Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
PASSWORD>" at the command prompt and the MSDE setup begins to take place. At
the nearly the end of the install, I get a pop-up dialog stating the the
instalation failed.
I checked setupapi.log file under C:\winnt and the follwoing error was in
their...
"
[2005/01/03 21:29:08 2672.1]
#-199 Executing "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
#E077 Could not locate a non-empty section [DefaultInstall] when calculating
disk space in "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line was
not found in the INF."
Anyone have any ideas as to what the above means. Also, I checked the
dasetup.log file that was created when attempting to install MSDE and I
noticed the following...
: ****************************************
: * Beginning of Install *
: ****************************************
Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:07
Path: C:\WINNT;C:\WINNT\system32;
Localization: Machine Locale set to: English_United States.1252
Command Line Parameters:
Suppress Reboot: 0
Quiet/Silent Mode: 1
Logging Level: 3
INI File: dasetup.ini
Windows Directory: C:\WINNT
Progress: Loading Resource Library.
Progress: Parsing INI File.
*************************:
** Begin INI File Dump **:
*************************:
Ini Section: General
: ProductName = Microsoft Data Access Components 2.7
: ProductBuild = 2.71.9040.2
: ProductUrl = http://www.microsoft.com/data
: ProductVersionKey = SOFTWARE\Microsoft\DataAccess
: ProductVersionValue = FullInstallVer
: InstanceName = MDAC
: CheckInUseFiles = 1
: EULAFile = MDACEULA.RTF
: EULAType = rtf
: SupportsTS = 1
: SupportsMUI = 0
: CheckForDiskSpace = 1
: ValidOs = 4294967295
I find it starnge that the install is trying to use MDAC 2.7 when I
currently have MDAC 2.8 SP1 installed on my machine (I verified this through
the MDAC compcheck app).
Anyone have any ideas as to what is going on?
PS Sorry for the long message
Thanks
I also found this error in the dahotfix.log
"
[05:03:12]: An error occurred while setup was trying to verify the version
of Microsoft Data Access Components current installed on the machine.
Either the version currently installed does not match the version of this
hotfix package, or setup was unable to determine the version currently
installed.
["
"John Rydenbark" wrote:

> Hi
> I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
> ...
> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
> PASSWORD>" at the command prompt and the MSDE setup begins to take place. At
> the nearly the end of the install, I get a pop-up dialog stating the the
> instalation failed.
> I checked setupapi.log file under C:\winnt and the follwoing error was in
> their...
> "
> [2005/01/03 21:29:08 2672.1]
> #-199 Executing "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
> #E077 Could not locate a non-empty section [DefaultInstall] when calculating
> disk space in "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line was
> not found in the INF."
> Anyone have any ideas as to what the above means. Also, I checked the
> dasetup.log file that was created when attempting to install MSDE and I
> noticed the following...
> : ****************************************
> : * Beginning of Install *
> : ****************************************
> Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:07
> Path: C:\WINNT;C:\WINNT\system32;
> Localization: Machine Locale set to: English_United States.1252
> Command Line Parameters:
> Suppress Reboot: 0
> Quiet/Silent Mode: 1
> Logging Level: 3
> INI File: dasetup.ini
> Windows Directory: C:\WINNT
> Progress: Loading Resource Library.
> Progress: Parsing INI File.
> *************************:
> ** Begin INI File Dump **:
> *************************:
> Ini Section: General
> : ProductName = Microsoft Data Access Components 2.7
> : ProductBuild = 2.71.9040.2
> : ProductUrl = http://www.microsoft.com/data
> : ProductVersionKey = SOFTWARE\Microsoft\DataAccess
> : ProductVersionValue = FullInstallVer
> : InstanceName = MDAC
> : CheckInUseFiles = 1
> : EULAFile = MDACEULA.RTF
> : EULAType = rtf
> : SupportsTS = 1
> : SupportsMUI = 0
> : CheckForDiskSpace = 1
> : ValidOs = 4294967295
> I find it starnge that the install is trying to use MDAC 2.7 when I
> currently have MDAC 2.8 SP1 installed on my machine (I verified this through
> the MDAC compcheck app).
> Anyone have any ideas as to what is going on?
> PS Sorry for the long message
> Thanks
>

MSDE Installation Help

Hi
I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
...
"Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA
PASSWORD>" at the command prompt and the MSDE setup begins to take place. At
the nearly the end of the install, I get a pop-up dialog stating the the
instalation failed.
I checked setupapi.log file under C:\winnt and the follwoing error was in
their...
"
[2005/01/03 21:29:08 2672.1]
#-199 Executing "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
#E077 Could not locate a non-empty section [DefaultInstall] when calcula
ting
disk space in "C:\Documents and Settings\Owner\Local
Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line was
not found in the INF."
Anyone have any ideas as to what the above means. Also, I checked the
dasetup.log file that was created when attempting to install MSDE and I
noticed the following...
: ****************************************
: * Beginning of Install *
: ****************************************
Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:07
Path: C:\WINNT;C:\WINNT\system32;
Localization: Machine Locale set to: English_United States.1252
Command Line Parameters:
Suppress Reboot: 0
Quiet/Silent Mode: 1
Logging Level: 3
INI File: dasetup.ini
Windows Directory: C:\WINNT
Progress: Loading Resource Library.
Progress: Parsing INI File.
*************************:
** Begin INI File Dump **:
*************************:
Ini Section: General
: ProductName = Microsoft Data Access Components 2.7
: ProductBuild = 2.71.9040.2
: ProductUrl = http://www.microsoft.com/data
: ProductVersionKey = SOFTWARE\Microsoft\DataAccess
: ProductVersionValue = FullInstallVer
: InstanceName = MDAC
: CheckInUseFiles = 1
: EULAFile = MDACEULA.RTF
: EULAType = rtf
: SupportsTS = 1
: SupportsMUI = 0
: CheckForDiskSpace = 1
: ValidOs = 4294967295
I find it starnge that the install is trying to use MDAC 2.7 when I
currently have MDAC 2.8 SP1 installed on my machine (I verified this through
the MDAC compcheck app).
Anyone have any ideas as to what is going on?
PS Sorry for the long message
ThanksI also found this error in the dahotfix.log
"
[05:03:12]: An error occurred while setup was trying to verify the versi
on
of Microsoft Data Access Components current installed on the machine.
Either the version currently installed does not match the version of this
hotfix package, or setup was unable to determine the version currently
installed.
["
"John Rydenbark" wrote:

> Hi
> I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
> ...
> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR
SA
> PASSWORD>" at the command prompt and the MSDE setup begins to take place.
At
> the nearly the end of the install, I get a pop-up dialog stating the the
> instalation failed.
> I checked setupapi.log file under C:\winnt and the follwoing error was in
> their...
> "
> [2005/01/03 21:29:08 2672.1]
> #-199 Executing "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\dasetup.exe" with command line: /Q /N
> #E077 Could not locate a non-empty section [DefaultInstall] when calcu
lating
> disk space in "C:\Documents and Settings\Owner\Local
> Settings\Temp\IXP000.TMP\noop.inf". Error 0xe0000102: The required line wa
s
> not found in the INF."
> Anyone have any ideas as to what the above means. Also, I checked the
> dasetup.log file that was created when attempting to install MSDE and I
> noticed the following...
> : ****************************************
> : * Beginning of Install *
> : ****************************************
> Starting Install: Current Date/Time (U.S. Local Time): 01/03/2005 : 21:29:
07
> Path: C:\WINNT;C:\WINNT\system32;
> Localization: Machine Locale set to: English_United States.1252
> Command Line Parameters:
> Suppress Reboot: 0
> Quiet/Silent Mode: 1
> Logging Level: 3
> INI File: dasetup.ini
> Windows Directory: C:\WINNT
> Progress: Loading Resource Library.
> Progress: Parsing INI File.
> *************************:
> ** Begin INI File Dump **:
> *************************:
> Ini Section: General
> : ProductName = Microsoft Data Access Components 2.7
> : ProductBuild = 2.71.9040.2
> : ProductUrl = http://www.microsoft.com/data
> : ProductVersionKey = SOFTWARE\Microsoft\DataAccess
> : ProductVersionValue = FullInstallVer
> : InstanceName = MDAC
> : CheckInUseFiles = 1
> : EULAFile = MDACEULA.RTF
> : EULAType = rtf
> : SupportsTS = 1
> : SupportsMUI = 0
> : CheckForDiskSpace = 1
> : ValidOs = 4294967295
> I find it starnge that the install is trying to use MDAC 2.7 when I
> currently have MDAC 2.8 SP1 installed on my machine (I verified this throu
gh
> the MDAC compcheck app).
> Anyone have any ideas as to what is going on?
> PS Sorry for the long message
> Thanks
>

MSDE installation - newbie problem

Dear all,

I have this problem with MSDE Installation:

I install MSDE then from prompt c:\sql...\msde\
I type: setup INSTANCENAME=pippo SECURITYMODE=SQL SAPWD=pp
then I restart but I see on the toolbar the icon of the SQL server but Ihaven't any Server or Service, in the Icon there is not the green signal nether the red signal, the little circle is white.

what I need to do?

thanks,
lucaHi Luca,

What version of Windows is this?

Don|||Windows XP Pro.

Now I unistall MSDE and Re-install it and now is ok.

Is the 1st time I use MSDE and I'd like t know wath's the use of SAPWD ?
and I need to indicate in the SETUP SAPWD=... etc. also uid= ?
and uid wath's

thanks,
luca|||I'm having the same problem. I'm using Windows 2000 Professional.

I do have the SQL Server 2000 CLIENT Tools installed on my computer, but as far as I know, those are just for connecting to SQL db's, it's not the actual engine; that's why I want MSDE on my machine. Would those client tools be conflicting with my MSDE installation?|||I've tried uninstalling it and then reinstalling it...

When I double click the little server icon in the tray and I go to hit the green play button, there are no services in the dropdown menu to start.

Anyone know how to solve this?|||Hi Luca,

The SAPWD switch lets you set the sa (system administrator, SQL Server's superuser) password which you shouldALWAYS do because of worms that have taken advantage of it.

uid is user id, the user you can use to log into MSDE.

Don|||Hi Matt,

I'm not sure I understand what you're saying about having the SQL Server client tools installed. You can use those to connect to and manage the engine of any SQL Server or MSDE installation on the local machine or across the network that you have permissions to access.

Do you mean that those don't include the database engine? If so, yes, that's right. So you would indeed want to install MSDE in order to use databases locally. And no, the client tools won't conflict with your MSDE installation at all.

I don't know why you aren't getting any services listed. If you go into Computer Management from the Control Panel do you have MSSQLSERVER listed under Services and Applications | Services? If so, can you start it from there?

This could be because you already had the client tools installed when you installed MSDE. So you probably have to add a registration to the local MSDE. Go into Enterprise Manager, expand Microsoft SQL Servers in the treeview, right-click on SQL SErver Group and select New SQL SErver Registration from the popup menu. In the available servers select either LOCAL (it might say LOCALHOST) or the machine name. If it isn't listed, type it in. Then complete the other steps in the wizard.

Does that solve it?

Don|||Don:

Since my last post I UNinstalled MSDE. You did clear up a lot for me though. I was unsure if the Client Tools were somehow conflicting, but now I know they won't.

I'll REinstall MSDE and register it in Enterprise Manager and see what happens.

Thanks for your help!

MSDE install problem

I am trying to install on a fresh copy of XP Home SP1. When I type the cmd line command to start the installation, the progress bar moves to almost completion and then it rolls back to the left and dies. What's going on here??

Help!!

Thanks
Mike Kiewiczhard to say. does it leave behind an install.log? what about the system's event viewer? anything in there?|||I am having the same behavior.

Event viewer has 5 entries

1. Warning
No object list was found in the installation file. Adding an object list to the installation file will improve performance of the system when measuring performance counters.

2. Error
The performance counter name string value in the registry is incorrectly formatted. The last valid index value is DWORD 0 in the Record Data.

3. Error
The performance counter name string value in the registry is incorrectly formatted. The last valid index value is DWORD 0 in the Record Data.

4. Error
Installing the performance counter strings for MSSQL$BOBBY1 failed. The Error code is DWORD 0 of the Record Data.

5. Information
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.|||I had this same problem. You have to have File and Print Sharing installed and running on the machine.

Kory|||File and print services are installed, however I can not view the properties

MSDE Error 70000

Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
System error numbers are up to 50000. So 70000 must be a user error
number assigned by the vendor/developer to some event. I don't think
there's anything anyone here can do to help you with that one, you need
to ask the vendor. Note, severity 10 is considered an informational
message only so perhaps it's nothing to be concerned about - once again,
ask the vendor (looks to me kind of like a debug statement - "this
(badly named) proc is being called with these parameters by this SPID").
*mike hodgson*
http://sqlnerd.blogspot.com
Djangar S. wrote:

>Hello, everyone
>Can somebody clarify what type of ther error it is ?
>Event Type: Information
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 2/23/2006
>Time: 3:01:03 PM
>User: N/A
>Computer: XXX
>Description:
>Error: 70000, Severity: 10, State: 1
>Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
>
>
|||Thanks, Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:e%23a99$NOGHA.532@.TK2MSFTNGP15.phx.gbl...
System error numbers are up to 50000. So 70000 must be a user error number assigned by the vendor/developer to some event. I don't think there's anything anyone here can do to help you with that one, you need to ask the vendor. Note, severity 10 is considered an informational message only so perhaps it's nothing to be concerned about - once again, ask the vendor (looks to me kind of like a debug statement - "this (badly named) proc is being called with these parameters by this SPID").
mike hodgson
http://sqlnerd.blogspot.com
Djangar S. wrote:
Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475

MSDE Error 70000

Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475This is a multi-part message in MIME format.
--080606060502060508030601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
System error numbers are up to 50000. So 70000 must be a user error
number assigned by the vendor/developer to some event. I don't think
there's anything anyone here can do to help you with that one, you need
to ask the vendor. Note, severity 10 is considered an informational
message only so perhaps it's nothing to be concerned about - once again,
ask the vendor (looks to me kind of like a debug statement - "this
(badly named) proc is being called with these parameters by this SPID").
--
*mike hodgson*
http://sqlnerd.blogspot.com
Djangar S. wrote:
>Hello, everyone
>Can somebody clarify what type of ther error it is ?
>Event Type: Information
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 2/23/2006
>Time: 3:01:03 PM
>User: N/A
>Computer: XXX
>Description:
>Error: 70000, Severity: 10, State: 1
>Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
>
>
--080606060502060508030601
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>System error numbers are up to 50000. So 70000 must be a user
error number assigned by the vendor/developer to some event. I don't
think there's anything anyone here can do to help you with that one,
you need to ask the vendor. Note, severity 10 is considered an
informational message only so perhaps it's nothing to be concerned
about - once again, ask the vendor (looks to me kind of like a debug
statement - "this (badly named) proc is being called with these
parameters by this SPID").</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Djangar S. wrote:
<blockquote cite="mid%23FuN0yMOGHA.2696@.TK2MSFTNGP14.phx.gbl"
type="cite">
<pre wrap="">Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
</pre>
</blockquote>
</body>
</html>
--080606060502060508030601--|||This is a multi-part message in MIME format.
--=_NextPart_000_0014_01C63933.5F319C80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks, Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message =news:e%23a99$NOGHA.532@.TK2MSFTNGP15.phx.gbl...
System error numbers are up to 50000. So 70000 must be a user error =number assigned by the vendor/developer to some event. I don't think =there's anything anyone here can do to help you with that one, you need =to ask the vendor. Note, severity 10 is considered an informational =message only so perhaps it's nothing to be concerned about - once again, =ask the vendor (looks to me kind of like a debug statement - "this =(badly named) proc is being called with these parameters by this SPID").
--
mike hodgson
http://sqlnerd.blogspot.com=20
Djangar S. wrote: Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
--=_NextPart_000_0014_01C63933.5F319C80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Thanks, Mike
"Mike Hodgson" wrote =in message news:e%23a99$NOGHA.5=32@.TK2MSFTNGP15.phx.gbl...System error numbers are up to 50000. So 70000 must be a user error =number assigned by the vendor/developer to some event. I don't think =there's anything anyone here can do to help you with that one, you need to ask =the vendor. Note, severity 10 is considered an informational message =only so perhaps it's nothing to be concerned about - once again, ask the =vendor (looks to me kind of like a debug statement - "this (badly named) proc is =being called with these parameters by this SPID").
--mike =hodgsonhttp://sqlnerd.blogspot.com Djangar S. wrote: Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475

---

--=_NextPart_000_0014_01C63933.5F319C80--

MSDE Error 70000

Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475System error numbers are up to 50000. So 70000 must be a user error
number assigned by the vendor/developer to some event. I don't think
there's anything anyone here can do to help you with that one, you need
to ask the vendor. Note, severity 10 is considered an informational
message only so perhaps it's nothing to be concerned about - once again,
ask the vendor (looks to me kind of like a debug statement - "this
(badly named) proc is being called with these parameters by this SPID").
*mike hodgson*
http://sqlnerd.blogspot.com
Djangar S. wrote:

>Hello, everyone
>Can somebody clarify what type of ther error it is ?
>Event Type: Information
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 2/23/2006
>Time: 3:01:03 PM
>User: N/A
>Computer: XXX
>Description:
>Error: 70000, Severity: 10, State: 1
>Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
>
>|||Thanks, Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:e%23a99$NOGHA.532
@.TK2MSFTNGP15.phx.gbl...
System error numbers are up to 50000. So 70000 must be a user error number
assigned by the vendor/developer to some event. I don't think there's anyth
ing anyone here can do to help you with that one, you need to ask the vendor
. Note, severity 10 is considered an informational message only so perhaps
it's nothing to be concerned about - once again, ask the vendor (looks to me
kind of like a debug statement - "this (badly named) proc is being called w
ith these parameters by this SPID").
mike hodgson
http://sqlnerd.blogspot.com
Djangar S. wrote:
Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475