I'd like to expand a coalesce function to account for Case 3, which says tha
t
if Date2 is null, then stay with null. As you see the following only
satisfies Case 1 and Case 2. Any ideas appreciated. I think that a fancy
CASE statement might do it, but I can't figure it out. Thanks, --Bob
Select COALESCE(Date1, Date2) as DateX From tableXYZ
Desired
output
Date1 Date2 DateX
Case 1 11/08/05 11/14/05 11/08/05
Case 2 null 11/14/05 11/14/05
Case 3 11/08/05 null nullSELECT CASE WHEN date2 IS NULL
THEN CAST( NULL AS DATETIME)
ELSE COALESCE (date1, date2) END
AS date_x
FROM Foobar;
The CAST() can be important in this kind of CASE expression.|||SELECT 'DateX'=
CASE
WHEN Date2 IS NULL THEN NULL
WHEN Date1 IS NULL THEN Date2
ELSE Date1
END
FROM TableXYZ
This works if you always want Date1 returned for the value of DateX when
neither are NULL.
"BobS" wrote:
> I'd like to expand a coalesce function to account for Case 3, which says t
hat
> if Date2 is null, then stay with null. As you see the following only
> satisfies Case 1 and Case 2. Any ideas appreciated. I think that a fancy
> CASE statement might do it, but I can't figure it out. Thanks, --Bob
> Select COALESCE(Date1, Date2) as DateX From tableXYZ
> Desired
> output
> Date1 Date2 DateX
> Case 1 11/08/05 11/14/05 11/08/05
> Case 2 null 11/14/05 11/14/05
> Case 3 11/08/05 null null
>
>
Saturday, February 25, 2012
COALESCE an integer?
Hi guys
I've got a table with a field called PMon_Total. At the moment, a lot have
rows have this set to null.
I want to substitute this NULL for a 0 so that I can count all the
PMon_Total fields, however, I can't get coalesce to work.
Here's my select...
SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions WHE...
Works fine if I try and grab PMon_Total values from C#, as long as they
arent null! However, if I put
SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
Sessions WHE...
my code give me a System.IndexOutOfRange exception. How can I coalesce
PMon_Total, so I know that any nulls will show as 0?!
Cheers
Dan> I want to substitute this NULL for a 0 so that I can count all the
> PMon_Total fields, however, I can't get coalesce to work.
I'm not sure what this means. Why would counting require you to change
nulls to zero? COUNT(*) will count rows whether NULL or not.
> my code give me a System.IndexOutOfRange exception.
That doesn't look like a SQL Server error. Can you tell us the exact
error message and error number please. Did you try the query in Query
Analyzer? Post some code to reproduce the problem if you can. I suspect
this is a client-side error.
David Portas
SQL Server MVP
--|||try
SELECT ProjectID, SessionID, SessionDate, isnull(PMon_Total,0) FROM
Sessions WHE...
Regards
R.D
--Knowledge gets doubled when shared
"dhnriverside" wrote:
> Hi guys
> I've got a table with a field called PMon_Total. At the moment, a lot have
> rows have this set to null.
> I want to substitute this NULL for a 0 so that I can count all the
> PMon_Total fields, however, I can't get coalesce to work.
> Here's my select...
> SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions WHE...
> Works fine if I try and grab PMon_Total values from C#, as long as they
> arent null! However, if I put
> SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
> Sessions WHE...
> my code give me a System.IndexOutOfRange exception. How can I coalesce
> PMon_Total, so I know that any nulls will show as 0?!
> Cheers
>
> Dan|||It's weird. I've just tried isnull() and that gave me the error as well.
Here's the C# code I'm using (where sDate = '2005-04-01' and eDate =
'2005-10-13')...
sql = "SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions
WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate + "')
ORDER BY ProjectID";
SqlConnection dbConn = new
SqlConnection(ConfigurationSettings.AppSettings.Get("System_ConnectionString
"));
dbConn.Open();
SqlCommand prjCmd = new SqlCommand(sql, dbConn);
SqlDataReader prjDr = prjCmd.ExecuteReader();
try
{
while(prjDr.Read())
{
Response.Write(prjDr["ProjectID"].ToString() + ", " +
prjDr["SessionID"].ToString() + ", " + prjDr["SessionDate"].ToString() + "|"
);
if(Convert.ToInt32(prjDr["ProjectID"].ToString()) > projID)
{
projC++;
projID = Convert.ToInt32(prjDR["ProjectID"].ToString());
Response.Write("new!");
}
seshC++;
Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
}
}
finally
{
prjDr.Close();
prjDr = null;
dbConn.Close();
dbConn = null;
}
The response.write statements are purely for debugging :)
Basically, with the code like that, it works perfectly. However, If I try
sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate
+ "') ORDER BY ProjectID";
or isnull() - i get the following error...
Server Error in '/dartsIntranetV2.1' Application.
----
--
PMon_Total
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information abou
t
the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: PMon_Total
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
The error message identifies line 223, which is effectively the last line in
the loop...
Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
Any help much appreciated!
Cheers
Dan
----
"David Portas" wrote:
> I'm not sure what this means. Why would counting require you to change
> nulls to zero? COUNT(*) will count rows whether NULL or not.
>
> That doesn't look like a SQL Server error. Can you tell us the exact
> error message and error number please. Did you try the query in Query
> Analyzer? Post some code to reproduce the problem if you can. I suspect
> this is a client-side error.
> --
> David Portas
> SQL Server MVP
> --
>|||If you print the SQL statement you send to SQL Server (or use Profiler to ca
tch it), you can do two
things:
1. Execute in Query Analyzer to see whether the problem is in the client or
in SQL Server.
2. Post it here so we can have a look at it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dhnriverside" <dan@.musoswire.com> wrote in message
news:EE59E12B-A568-4482-95C0-D6E7C67CFE86@.microsoft.com...
> It's weird. I've just tried isnull() and that gave me the error as well.
> Here's the C# code I'm using (where sDate = '2005-04-01' and eDate =
> '2005-10-13')...
> sql = "SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions
> WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate + "')
> ORDER BY ProjectID";
>
> SqlConnection dbConn = new
> SqlConnection(ConfigurationSettings.AppSettings.Get("System_ConnectionStri
ng"));
> dbConn.Open();
> SqlCommand prjCmd = new SqlCommand(sql, dbConn);
> SqlDataReader prjDr = prjCmd.ExecuteReader();
> try
> {
> while(prjDr.Read())
> {
> Response.Write(prjDr["ProjectID"].ToString() + ", " +
> prjDr["SessionID"].ToString() + ", " + prjDr["SessionDate"].ToString() + "
|");
> if(Convert.ToInt32(prjDr["ProjectID"].ToString()) > projID)
> {
> projC++;
> projID = Convert.ToInt32(prjDR["ProjectID"].ToString());
> Response.Write("new!");
> }
> seshC++;
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> }
> }
> finally
> {
> prjDr.Close();
> prjDr = null;
> dbConn.Close();
> dbConn = null;
> }
> The response.write statements are purely for debugging :)
> Basically, with the code like that, it works perfectly. However, If I try
> sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FR
OM
> Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDa
te
> + "') ORDER BY ProjectID";
> or isnull() - i get the following error...
> Server Error in '/dartsIntranetV2.1' Application.
> ----
--
> PMon_Total
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information ab
out
> the error and where it originated in the code.
> Exception Details: System.IndexOutOfRangeException: PMon_Total
> Source Error:
> An unhandled exception was generated during the execution of the current w
eb
> request. Information regarding the origin and location of the exception ca
n
> be identified using the exception stack trace below.
> The error message identifies line 223, which is effectively the last line
in
> the loop...
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> Any help much appreciated!
> Cheers
>
> Dan
> ----
> "David Portas" wrote:
>|||This is a C# error so you may have more luck in a C# forum.
Why aren't you using the parameters collection to pass your parameters?
That at least would eliminate the possibility of a corrupt command
string due to invalid input. It also avoids any SQL injection
vulnerabilities. Example at:
http://msdn.microsoft.com/library/d.../>
ersTopic.asp
You should also consider putting the SQL in a proc since the query
appears to be static anyway.
David Portas
SQL Server MVP
--|||You need to give the column an alias,
SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) AS
PMon_Total FROM
Sessions WHE...
That should fix it - it was being returned to c# with no column name.
"dhnriverside" <dan@.musoswire.com> wrote in message
news:13A0B95A-CBB3-40D3-9FF6-4B6762CB8A6D@.microsoft.com...
> Hi guys
> I've got a table with a field called PMon_Total. At the moment, a lot have
> rows have this set to null.
> I want to substitute this NULL for a 0 so that I can count all the
> PMon_Total fields, however, I can't get coalesce to work.
> Here's my select...
> SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions WHE...
> Works fine if I try and grab PMon_Total values from C#, as long as they
> arent null! However, if I put
> SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
> Sessions WHE...
> my code give me a System.IndexOutOfRange exception. How can I coalesce
> PMon_Total, so I know that any nulls will show as 0?!
> Cheers
>
> Dan|||> Basically, with the code like that, it works perfectly. However, If I try
> sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0)
> FROM
> Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" +
> eDate
> + "') ORDER BY ProjectID";
> or isnull() - i get the following error...
This SQL statement doesn't include an alias for COALESCE(PMon_Total,0). You
get an IndexOutOfRangeException exception when you reference
prjDr["PMon_Total"] because no column with that name exists in the result.
Try specifying PMon_Total as the alias for the COALESCE expression:
sql = "SELECT ProjectID, SessionID, SessionDate,
COALESCE(PMon_Total,0) AS PMon_Total
FROM Sessions
WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate
+ "') ORDER BY ProjectID";
Hope this helps.
Dan Guzman
SQL Server MVP
"dhnriverside" <dan@.musoswire.com> wrote in message
news:EE59E12B-A568-4482-95C0-D6E7C67CFE86@.microsoft.com...
> It's weird. I've just tried isnull() and that gave me the error as well.
> Here's the C# code I'm using (where sDate = '2005-04-01' and eDate =
> '2005-10-13')...
> sql = "SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions
> WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate + "')
> ORDER BY ProjectID";
>
> SqlConnection dbConn = new
> SqlConnection(ConfigurationSettings.AppSettings.Get("System_ConnectionStri
ng"));
> dbConn.Open();
> SqlCommand prjCmd = new SqlCommand(sql, dbConn);
> SqlDataReader prjDr = prjCmd.ExecuteReader();
> try
> {
> while(prjDr.Read())
> {
> Response.Write(prjDr["ProjectID"].ToString() + ", " +
> prjDr["SessionID"].ToString() + ", " + prjDr["SessionDate"].ToString() +
> "|");
> if(Convert.ToInt32(prjDr["ProjectID"].ToString()) > projID)
> {
> projC++;
> projID = Convert.ToInt32(prjDR["ProjectID"].ToString());
> Response.Write("new!");
> }
> seshC++;
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> }
> }
> finally
> {
> prjDr.Close();
> prjDr = null;
> dbConn.Close();
> dbConn = null;
> }
> The response.write statements are purely for debugging :)
> Basically, with the code like that, it works perfectly. However, If I try
> sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0)
> FROM
> Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" +
> eDate
> + "') ORDER BY ProjectID";
> or isnull() - i get the following error...
> Server Error in '/dartsIntranetV2.1' Application.
> ----
--
> PMon_Total
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.IndexOutOfRangeException: PMon_Total
> Source Error:
> An unhandled exception was generated during the execution of the current
> web
> request. Information regarding the origin and location of the exception
> can
> be identified using the exception stack trace below.
> The error message identifies line 223, which is effectively the last line
> in
> the loop...
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> Any help much appreciated!
> Cheers
>
> Dan
> ----
> "David Portas" wrote:
>|||Fixed!
I had a look at the query code running from Web Data Administrator, and it
was passing the results of COALESCE as a new column, named Column 1.
I changed it to COALESCE(PMon_Total, 0) AS MonTotal, and pulled that from my
code, which works perfectly.
Thanks for everyones help!
"David Portas" wrote:
> This is a C# error so you may have more luck in a C# forum.
> Why aren't you using the parameters collection to pass your parameters?
> That at least would eliminate the possibility of a corrupt command
> string due to invalid input. It also avoids any SQL injection
> vulnerabilities. Example at:
> http://msdn.microsoft.com/library/d...
etersTopic.asp
> You should also consider putting the SQL in a proc since the query
> appears to be static anyway.
> --
> David Portas
> SQL Server MVP
> --
>
I've got a table with a field called PMon_Total. At the moment, a lot have
rows have this set to null.
I want to substitute this NULL for a 0 so that I can count all the
PMon_Total fields, however, I can't get coalesce to work.
Here's my select...
SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions WHE...
Works fine if I try and grab PMon_Total values from C#, as long as they
arent null! However, if I put
SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
Sessions WHE...
my code give me a System.IndexOutOfRange exception. How can I coalesce
PMon_Total, so I know that any nulls will show as 0?!
Cheers
Dan> I want to substitute this NULL for a 0 so that I can count all the
> PMon_Total fields, however, I can't get coalesce to work.
I'm not sure what this means. Why would counting require you to change
nulls to zero? COUNT(*) will count rows whether NULL or not.
> my code give me a System.IndexOutOfRange exception.
That doesn't look like a SQL Server error. Can you tell us the exact
error message and error number please. Did you try the query in Query
Analyzer? Post some code to reproduce the problem if you can. I suspect
this is a client-side error.
David Portas
SQL Server MVP
--|||try
SELECT ProjectID, SessionID, SessionDate, isnull(PMon_Total,0) FROM
Sessions WHE...
Regards
R.D
--Knowledge gets doubled when shared
"dhnriverside" wrote:
> Hi guys
> I've got a table with a field called PMon_Total. At the moment, a lot have
> rows have this set to null.
> I want to substitute this NULL for a 0 so that I can count all the
> PMon_Total fields, however, I can't get coalesce to work.
> Here's my select...
> SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions WHE...
> Works fine if I try and grab PMon_Total values from C#, as long as they
> arent null! However, if I put
> SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
> Sessions WHE...
> my code give me a System.IndexOutOfRange exception. How can I coalesce
> PMon_Total, so I know that any nulls will show as 0?!
> Cheers
>
> Dan|||It's weird. I've just tried isnull() and that gave me the error as well.
Here's the C# code I'm using (where sDate = '2005-04-01' and eDate =
'2005-10-13')...
sql = "SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions
WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate + "')
ORDER BY ProjectID";
SqlConnection dbConn = new
SqlConnection(ConfigurationSettings.AppSettings.Get("System_ConnectionString
"));
dbConn.Open();
SqlCommand prjCmd = new SqlCommand(sql, dbConn);
SqlDataReader prjDr = prjCmd.ExecuteReader();
try
{
while(prjDr.Read())
{
Response.Write(prjDr["ProjectID"].ToString() + ", " +
prjDr["SessionID"].ToString() + ", " + prjDr["SessionDate"].ToString() + "|"
);
if(Convert.ToInt32(prjDr["ProjectID"].ToString()) > projID)
{
projC++;
projID = Convert.ToInt32(prjDR["ProjectID"].ToString());
Response.Write("new!");
}
seshC++;
Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
}
}
finally
{
prjDr.Close();
prjDr = null;
dbConn.Close();
dbConn = null;
}
The response.write statements are purely for debugging :)
Basically, with the code like that, it works perfectly. However, If I try
sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate
+ "') ORDER BY ProjectID";
or isnull() - i get the following error...
Server Error in '/dartsIntranetV2.1' Application.
----
--
PMon_Total
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information abou
t
the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: PMon_Total
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
The error message identifies line 223, which is effectively the last line in
the loop...
Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
Any help much appreciated!
Cheers
Dan
----
"David Portas" wrote:
> I'm not sure what this means. Why would counting require you to change
> nulls to zero? COUNT(*) will count rows whether NULL or not.
>
> That doesn't look like a SQL Server error. Can you tell us the exact
> error message and error number please. Did you try the query in Query
> Analyzer? Post some code to reproduce the problem if you can. I suspect
> this is a client-side error.
> --
> David Portas
> SQL Server MVP
> --
>|||If you print the SQL statement you send to SQL Server (or use Profiler to ca
tch it), you can do two
things:
1. Execute in Query Analyzer to see whether the problem is in the client or
in SQL Server.
2. Post it here so we can have a look at it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dhnriverside" <dan@.musoswire.com> wrote in message
news:EE59E12B-A568-4482-95C0-D6E7C67CFE86@.microsoft.com...
> It's weird. I've just tried isnull() and that gave me the error as well.
> Here's the C# code I'm using (where sDate = '2005-04-01' and eDate =
> '2005-10-13')...
> sql = "SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions
> WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate + "')
> ORDER BY ProjectID";
>
> SqlConnection dbConn = new
> SqlConnection(ConfigurationSettings.AppSettings.Get("System_ConnectionStri
ng"));
> dbConn.Open();
> SqlCommand prjCmd = new SqlCommand(sql, dbConn);
> SqlDataReader prjDr = prjCmd.ExecuteReader();
> try
> {
> while(prjDr.Read())
> {
> Response.Write(prjDr["ProjectID"].ToString() + ", " +
> prjDr["SessionID"].ToString() + ", " + prjDr["SessionDate"].ToString() + "
|");
> if(Convert.ToInt32(prjDr["ProjectID"].ToString()) > projID)
> {
> projC++;
> projID = Convert.ToInt32(prjDR["ProjectID"].ToString());
> Response.Write("new!");
> }
> seshC++;
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> }
> }
> finally
> {
> prjDr.Close();
> prjDr = null;
> dbConn.Close();
> dbConn = null;
> }
> The response.write statements are purely for debugging :)
> Basically, with the code like that, it works perfectly. However, If I try
> sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FR
OM
> Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDa
te
> + "') ORDER BY ProjectID";
> or isnull() - i get the following error...
> Server Error in '/dartsIntranetV2.1' Application.
> ----
--
> PMon_Total
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information ab
out
> the error and where it originated in the code.
> Exception Details: System.IndexOutOfRangeException: PMon_Total
> Source Error:
> An unhandled exception was generated during the execution of the current w
eb
> request. Information regarding the origin and location of the exception ca
n
> be identified using the exception stack trace below.
> The error message identifies line 223, which is effectively the last line
in
> the loop...
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> Any help much appreciated!
> Cheers
>
> Dan
> ----
> "David Portas" wrote:
>|||This is a C# error so you may have more luck in a C# forum.
Why aren't you using the parameters collection to pass your parameters?
That at least would eliminate the possibility of a corrupt command
string due to invalid input. It also avoids any SQL injection
vulnerabilities. Example at:
http://msdn.microsoft.com/library/d.../>
ersTopic.asp
You should also consider putting the SQL in a proc since the query
appears to be static anyway.
David Portas
SQL Server MVP
--|||You need to give the column an alias,
SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) AS
PMon_Total FROM
Sessions WHE...
That should fix it - it was being returned to c# with no column name.
"dhnriverside" <dan@.musoswire.com> wrote in message
news:13A0B95A-CBB3-40D3-9FF6-4B6762CB8A6D@.microsoft.com...
> Hi guys
> I've got a table with a field called PMon_Total. At the moment, a lot have
> rows have this set to null.
> I want to substitute this NULL for a 0 so that I can count all the
> PMon_Total fields, however, I can't get coalesce to work.
> Here's my select...
> SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions WHE...
> Works fine if I try and grab PMon_Total values from C#, as long as they
> arent null! However, if I put
> SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0) FROM
> Sessions WHE...
> my code give me a System.IndexOutOfRange exception. How can I coalesce
> PMon_Total, so I know that any nulls will show as 0?!
> Cheers
>
> Dan|||> Basically, with the code like that, it works perfectly. However, If I try
> sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0)
> FROM
> Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" +
> eDate
> + "') ORDER BY ProjectID";
> or isnull() - i get the following error...
This SQL statement doesn't include an alias for COALESCE(PMon_Total,0). You
get an IndexOutOfRangeException exception when you reference
prjDr["PMon_Total"] because no column with that name exists in the result.
Try specifying PMon_Total as the alias for the COALESCE expression:
sql = "SELECT ProjectID, SessionID, SessionDate,
COALESCE(PMon_Total,0) AS PMon_Total
FROM Sessions
WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate
+ "') ORDER BY ProjectID";
Hope this helps.
Dan Guzman
SQL Server MVP
"dhnriverside" <dan@.musoswire.com> wrote in message
news:EE59E12B-A568-4482-95C0-D6E7C67CFE86@.microsoft.com...
> It's weird. I've just tried isnull() and that gave me the error as well.
> Here's the C# code I'm using (where sDate = '2005-04-01' and eDate =
> '2005-10-13')...
> sql = "SELECT ProjectID, SessionID, SessionDate, PMon_Total FROM Sessions
> WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" + eDate + "')
> ORDER BY ProjectID";
>
> SqlConnection dbConn = new
> SqlConnection(ConfigurationSettings.AppSettings.Get("System_ConnectionStri
ng"));
> dbConn.Open();
> SqlCommand prjCmd = new SqlCommand(sql, dbConn);
> SqlDataReader prjDr = prjCmd.ExecuteReader();
> try
> {
> while(prjDr.Read())
> {
> Response.Write(prjDr["ProjectID"].ToString() + ", " +
> prjDr["SessionID"].ToString() + ", " + prjDr["SessionDate"].ToString() +
> "|");
> if(Convert.ToInt32(prjDr["ProjectID"].ToString()) > projID)
> {
> projC++;
> projID = Convert.ToInt32(prjDR["ProjectID"].ToString());
> Response.Write("new!");
> }
> seshC++;
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> }
> }
> finally
> {
> prjDr.Close();
> prjDr = null;
> dbConn.Close();
> dbConn = null;
> }
> The response.write statements are purely for debugging :)
> Basically, with the code like that, it works perfectly. However, If I try
> sql = "SELECT ProjectID, SessionID, SessionDate, COALESCE(PMon_Total,0)
> FROM
> Sessions WHERE (SessionDate > '" + sDate + "') AND (SessionDate < '" +
> eDate
> + "') ORDER BY ProjectID";
> or isnull() - i get the following error...
> Server Error in '/dartsIntranetV2.1' Application.
> ----
--
> PMon_Total
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.IndexOutOfRangeException: PMon_Total
> Source Error:
> An unhandled exception was generated during the execution of the current
> web
> request. Information regarding the origin and location of the exception
> can
> be identified using the exception stack trace below.
> The error message identifies line 223, which is effectively the last line
> in
> the loop...
> Response.Write(", " + prjDr["PMon_Total"].ToString() + "<br>");
> Any help much appreciated!
> Cheers
>
> Dan
> ----
> "David Portas" wrote:
>|||Fixed!
I had a look at the query code running from Web Data Administrator, and it
was passing the results of COALESCE as a new column, named Column 1.
I changed it to COALESCE(PMon_Total, 0) AS MonTotal, and pulled that from my
code, which works perfectly.
Thanks for everyones help!
"David Portas" wrote:
> This is a C# error so you may have more luck in a C# forum.
> Why aren't you using the parameters collection to pass your parameters?
> That at least would eliminate the possibility of a corrupt command
> string due to invalid input. It also avoids any SQL injection
> vulnerabilities. Example at:
> http://msdn.microsoft.com/library/d...
etersTopic.asp
> You should also consider putting the SQL in a proc since the query
> appears to be static anyway.
> --
> David Portas
> SQL Server MVP
> --
>
Coalesce / Comma Delimitted List
I'm trying to return multiple column, one of which is a column + a comma delimitted list of values. Below is a simplified, non working, query:
(assume @.MyBit, @.MyVarChar, and @.MyValue are all declared)
SELECT distinct
IsNull(Column1, '') AS Column1,
IsNull(Column2,'') + CASE WHEN @.MyBit = 1 THEN ' My Test: ' + (select @.MyVarChar = COALESCE(Column3 + ', ', '') from TableSub where Value = @.MyValue) ELSE '' END AS Column2,
FROM TableMain
I get an ADO error: Incorrect syntax near '='
Thoughts?
Thanks(select @.MyVarChar = COALESCE(Column3 + ', ', '') from TableSub where Value = @.MyValue)
use "[ ]" brackets instead of "( )" around the above select statment.
(and remove the last comma before the FROM stmnt)|||I now have:
SELECT distinct
IsNull(Column1, '') AS Column1,
IsNull(Column2,'') + CASE WHEN @.MyBit = 1 THEN ' My Test: ' + [select @.MyVarChar = COALESCE(Column3 + ', ', '') from TableSub where Value = @.MyValue] ELSE '' END AS Column2
FROM TableMain
and I get:
ADO error: Invalid column name 'select @.MyVarChar = COALESCE(Column3 + ',', '') from TableSub where Value = @.MyValue'
Thanks|||my apologies - here is the correct query
SELECT distinct
IsNull(Column1, '') AS Column1,
IsNull(Column2,'') + CASE WHEN @.MyBit = 1 THEN ' My Test: ' + (select COALESCE(Column3 + ', ', '') from TableSub where Value = @.MyValue) ELSE '' END AS Column2
FROM TableMain
put the "( )" back on and remove the @.MyVarChar = (that is where the err is)
you just need select coalesce...
Coalesce
Hi.
I have a piece of a store procedure I don't quite understand, as follows:
SELECT d.DealReference, d.DealId, d.IllustrationId, ci.ContactId
FROM utDeal d WITH (NOLOCK)
INNER JOIN utContactIllustration ci WITH (NOLOCK)
ON ci.IllustrationId = d.IllustrationId
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%'))
What exactly is the COALESCE function doing here with the parameter?Returns the first nonnull expression among its arguments.|||Ok,
What does that mean? it returns the first parameter that is null or it returns the first record that is null.|||Originally posted by SQLSlammer
Ok,
What does that mean? it returns the first parameter that is null or it returns the first record that is null.
declare @.id int,@.id2 int
set @.id=null
set @.id2=1
select COALESCE(@.id,@.id2)
It returns the first parameter that is not null...
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%'))
In your query COALESCE(@.DealReference,'%')) means that if @.DealReference is null then COALESCE returns '%' and finally it is LIKE '%'.|||coalesce returns the first non-null value in its list
in your particular example, it's a sloppy stored proc
if the parameter @.DealReference is null, then the sql statement will actually look like this:
... where d.DealReference LIKE (COALESCE(null,'%'))
but in that case, since it's a stored proc, it should not generate a WHERE clause at all
furthermore, since it's a LIKE condition, the @.DealReference has better include the wildcard characters, otherwise it will function as an equality
again, the stored proc should tailor the sql specifically|||Hi,
Thanks for that,
so basically it will return all records if the parameter is null, what would be a beter way of handling a null parameter?|||what would be a better way of handling a null parameter?
don't generate the WHERE clause
that, too, will return all records|||Hi,
Ok, I should explain a little more, there is lot more to this sp than I have shown, there are 7 parameters for filtering and I really don't want it to return all records cos that would be over 7 million records into the temp table which is pointless:
The full SP is attached and yes I know its not very good (I did not write this).
Any advice would be appreciated very much|||Originally posted by SQLSlammer
Hi,
Ok, I should explain a little more, there is lot more to this sp than I have shown, there are 7 parameters for filtering and I really don't want it to return all records cos that would be over 7 million records into the temp table which is pointless:
The full SP is attached and yes I know its not very good (I did not write this).
Any advice would be appreciated very much
Well, there is bad with using coalesce in this proc. I guess you could change a little logic in your proc:
You are inserting more records in table @.Deals than late you selecting from it because in select you are using more filters then for insert. You could use all filters during inserting - it will be more complicated query but it is worth to try.
INSERT @.Deals (DealReference, DealId, IllustrationId, ContactId)\par
SELECT d.DealReference, d.DealId, d.IllustrationId, ci.ContactId\par
FROM utDeal d WITH (NOLOCK)\par
\tab INNER JOIN utContactIllustration ci WITH (NOLOCK)\par
\tab\tab ON ci.IllustrationId = d.IllustrationId\par
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%')) \par
SELECT DISTINCT * FROM @.deals \par
WHERE \tab\par
\tab DealReference LIKE (COALESCE(@.DealReference,'%')) \par
AND\par
\tab UserName LIKE (COALESCE(@.UserName, '%'))\par
AND\par
\tab LastAction LIKE (COALESCE(@.ActionType, '%'))\par
AND\par
\tab PostCode LIKE (COALESCE(@.PostCode, '%'))\par
AND\par
\tab CurrentStage LIKE (COALESCE(@.Stage, '%'))\par
AND\par
\tab Surname LIKE (COALESCE(@.Surname, '%'))\par
AND\par
\tab Telephone LIKE (COALESCE(@.Telephone, '%'))\par
ORDER BY DealId\par|||you know your data better than i do, but the relevant statement in your proc is
INSERT @.Deals (DealReference, DealId, IllustrationId, ContactId)
SELECT d.DealReference, d.DealId, d.IllustrationId, ci.ContactId
FROM utDeal d WITH (NOLOCK)
INNER JOIN utContactIllustration ci WITH (NOLOCK)
ON ci.IllustrationId = d.IllustrationId
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%'))
so if @.DealReference is null, it will bring back all rows that satisfy that join, whether that's 7 million, i don't know, but it could be
I have a piece of a store procedure I don't quite understand, as follows:
SELECT d.DealReference, d.DealId, d.IllustrationId, ci.ContactId
FROM utDeal d WITH (NOLOCK)
INNER JOIN utContactIllustration ci WITH (NOLOCK)
ON ci.IllustrationId = d.IllustrationId
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%'))
What exactly is the COALESCE function doing here with the parameter?Returns the first nonnull expression among its arguments.|||Ok,
What does that mean? it returns the first parameter that is null or it returns the first record that is null.|||Originally posted by SQLSlammer
Ok,
What does that mean? it returns the first parameter that is null or it returns the first record that is null.
declare @.id int,@.id2 int
set @.id=null
set @.id2=1
select COALESCE(@.id,@.id2)
It returns the first parameter that is not null...
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%'))
In your query COALESCE(@.DealReference,'%')) means that if @.DealReference is null then COALESCE returns '%' and finally it is LIKE '%'.|||coalesce returns the first non-null value in its list
in your particular example, it's a sloppy stored proc
if the parameter @.DealReference is null, then the sql statement will actually look like this:
... where d.DealReference LIKE (COALESCE(null,'%'))
but in that case, since it's a stored proc, it should not generate a WHERE clause at all
furthermore, since it's a LIKE condition, the @.DealReference has better include the wildcard characters, otherwise it will function as an equality
again, the stored proc should tailor the sql specifically|||Hi,
Thanks for that,
so basically it will return all records if the parameter is null, what would be a beter way of handling a null parameter?|||what would be a better way of handling a null parameter?
don't generate the WHERE clause
that, too, will return all records|||Hi,
Ok, I should explain a little more, there is lot more to this sp than I have shown, there are 7 parameters for filtering and I really don't want it to return all records cos that would be over 7 million records into the temp table which is pointless:
The full SP is attached and yes I know its not very good (I did not write this).
Any advice would be appreciated very much|||Originally posted by SQLSlammer
Hi,
Ok, I should explain a little more, there is lot more to this sp than I have shown, there are 7 parameters for filtering and I really don't want it to return all records cos that would be over 7 million records into the temp table which is pointless:
The full SP is attached and yes I know its not very good (I did not write this).
Any advice would be appreciated very much
Well, there is bad with using coalesce in this proc. I guess you could change a little logic in your proc:
You are inserting more records in table @.Deals than late you selecting from it because in select you are using more filters then for insert. You could use all filters during inserting - it will be more complicated query but it is worth to try.
INSERT @.Deals (DealReference, DealId, IllustrationId, ContactId)\par
SELECT d.DealReference, d.DealId, d.IllustrationId, ci.ContactId\par
FROM utDeal d WITH (NOLOCK)\par
\tab INNER JOIN utContactIllustration ci WITH (NOLOCK)\par
\tab\tab ON ci.IllustrationId = d.IllustrationId\par
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%')) \par
SELECT DISTINCT * FROM @.deals \par
WHERE \tab\par
\tab DealReference LIKE (COALESCE(@.DealReference,'%')) \par
AND\par
\tab UserName LIKE (COALESCE(@.UserName, '%'))\par
AND\par
\tab LastAction LIKE (COALESCE(@.ActionType, '%'))\par
AND\par
\tab PostCode LIKE (COALESCE(@.PostCode, '%'))\par
AND\par
\tab CurrentStage LIKE (COALESCE(@.Stage, '%'))\par
AND\par
\tab Surname LIKE (COALESCE(@.Surname, '%'))\par
AND\par
\tab Telephone LIKE (COALESCE(@.Telephone, '%'))\par
ORDER BY DealId\par|||you know your data better than i do, but the relevant statement in your proc is
INSERT @.Deals (DealReference, DealId, IllustrationId, ContactId)
SELECT d.DealReference, d.DealId, d.IllustrationId, ci.ContactId
FROM utDeal d WITH (NOLOCK)
INNER JOIN utContactIllustration ci WITH (NOLOCK)
ON ci.IllustrationId = d.IllustrationId
WHERE d.DealReference LIKE (COALESCE(@.DealReference,'%'))
so if @.DealReference is null, it will bring back all rows that satisfy that join, whether that's 7 million, i don't know, but it could be
coalesce
Hi,
How can i display a integer value to it's description i a lookuptable? I did
something like this, but i still got the integer value.
select coalesce(myIntColumn, (select MyIntDescription from descriptions)
from payments
What is wrong with this?First of all, a parenth. is missing..
> select coalesce(myIntColumn, (select MyIntDescription from descriptions))
> from payments
Second, you should know that you are only able to get back ONE Value. If
dont know if your query mentioned above can handle this, i think it will
return more than one value.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jason" <jasonlewis@.hotrmail.com> schrieb im Newsbeitrag
news:ug%235OHlRFHA.3544@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can i display a integer value to it's description i a lookuptable? I
> did
> something like this, but i still got the integer value.
> select coalesce(myIntColumn, (select MyIntDescription from descriptions)
> from payments
>
> What is wrong with this?
>|||coalesce isnt designed for what you aare trying to do ( check BOL )
why not just join to your lookup table ? e.g.
select MYINTDESCRIPTION from PAYMENTS join DESCRIPTIONS on
PAYMENTS.MYINTCOLUMN = DESCRIPTIONS.INTCOLUMN
I would assume that the integer value in "descriptions" table is unique, so
put a clustered primary key on that...|||I assume you want a JOIN here:
SELECT P.myIntColumn, D.myIntDescription
FROM Payments AS P
INNER JOIN Descriptions AS D
ON P.myIntColumn = D.myIntColumn
David Portas
SQL Server MVP
--|||Jason
Use Northwind
select
coalesce(( select orderid from orders where orderid = 10248),
(select top 1 orderid from [order details]
where orderid = 10249
)
)
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:ug%235OHlRFHA.3544@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can i display a integer value to it's description i a lookuptable? I
did
> something like this, but i still got the integer value.
> select coalesce(myIntColumn, (select MyIntDescription from descriptions)
> from payments
>
> What is wrong with this?
>
How can i display a integer value to it's description i a lookuptable? I did
something like this, but i still got the integer value.
select coalesce(myIntColumn, (select MyIntDescription from descriptions)
from payments
What is wrong with this?First of all, a parenth. is missing..
> select coalesce(myIntColumn, (select MyIntDescription from descriptions))
> from payments
Second, you should know that you are only able to get back ONE Value. If
dont know if your query mentioned above can handle this, i think it will
return more than one value.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jason" <jasonlewis@.hotrmail.com> schrieb im Newsbeitrag
news:ug%235OHlRFHA.3544@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can i display a integer value to it's description i a lookuptable? I
> did
> something like this, but i still got the integer value.
> select coalesce(myIntColumn, (select MyIntDescription from descriptions)
> from payments
>
> What is wrong with this?
>|||coalesce isnt designed for what you aare trying to do ( check BOL )
why not just join to your lookup table ? e.g.
select MYINTDESCRIPTION from PAYMENTS join DESCRIPTIONS on
PAYMENTS.MYINTCOLUMN = DESCRIPTIONS.INTCOLUMN
I would assume that the integer value in "descriptions" table is unique, so
put a clustered primary key on that...|||I assume you want a JOIN here:
SELECT P.myIntColumn, D.myIntDescription
FROM Payments AS P
INNER JOIN Descriptions AS D
ON P.myIntColumn = D.myIntColumn
David Portas
SQL Server MVP
--|||Jason
Use Northwind
select
coalesce(( select orderid from orders where orderid = 10248),
(select top 1 orderid from [order details]
where orderid = 10249
)
)
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:ug%235OHlRFHA.3544@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can i display a integer value to it's description i a lookuptable? I
did
> something like this, but i still got the integer value.
> select coalesce(myIntColumn, (select MyIntDescription from descriptions)
> from payments
>
> What is wrong with this?
>
Cnot start SQL Server 2000sp3
I have installed MSDE version of SQL server 2000 and sp3 with merge modules
and I cannot start the SQL server when the instance name is other than the
default. Can someone tell me what is wrong?
Hi Yiannis,
From your descriptions, I understood that you could not start SQL Server's
instance when this instance is not the default one by MSDE. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my knowledge, database engine operates as a service or process
that is separate from any application using MSDE 2000. Either MSDE 2000 or
any other version of SQL Server can be running at the same time on the same
computer. Each copy is called an instance. Each instance is installed,
started, stopped, configured, and patched independently of the other
instances.
However, I am not sure your steps about the installation and start-up for
the instance and what error messages could you find Event Log. Would you
please give me detailed descriptions about it, which I believe, will get us
closer to the resolution Could you give me a descriptions, with which I
could reproduce it on my machine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Here is how things are. With a setup project I am using all the merge
modules to install the SQL MSDE to the machine. When I configure the server
to use the default instance everything is going fine. When I change the
instance name and I use a named one then when I try to start the server
(same command "start") the server doesn;t start at all. I am trying to start
the server with the command from the instance binn dir "sqlservr -scommerce"
and I cannot start it. When I use the sqlmanagr to start the server it is
starting but the command doesn't start it.
Running machine is an XP Professional version 2002.
From the command prompt the command is going till "SQL Server is ready for
client connections" and never gets to an end.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> From your descriptions, I understood that you could not start SQL Server's
> instance when this instance is not the default one by MSDE. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know
> Based on my knowledge, database engine operates as a service or process
> that is separate from any application using MSDE 2000. Either MSDE 2000 or
> any other version of SQL Server can be running at the same time on the
same
> computer. Each copy is called an instance. Each instance is installed,
> started, stopped, configured, and patched independently of the other
> instances.
> However, I am not sure your steps about the installation and start-up for
> the instance and what error messages could you find Event Log. Would you
> please give me detailed descriptions about it, which I believe, will get
us
> closer to the resolution Could you give me a descriptions, with which I
> could reproduce it on my machine?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for you update!
However, I am still not sure about the root cause of this issue, Would you
please help me collection more detailed information? More detailed
information, I believe, will get us closer to the resolutions
First of all, could you start MSSQL Services by means of Control Panel ->
Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
Services by running Command "net start mssqlserver" (without quotation
marks)?
Secondly, could you see some error logs when you are starting up the SQL
Server? Error Number will be the most helpful ones for us to
troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
about the startup and post it here?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer?
Yes I can.
Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
The server is doesn't start. When I press Enter a dialog opens and closes
but I don';t have a chance to see anything.
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
>
Here is the log file.
2004-05-28 16:34:39.69 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )
2004-05-28 16:34:39.72 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-28 16:34:39.73 server All rights reserved.
2004-05-28 16:34:39.74 server Server Process ID is 2680.
2004-05-28 16:34:39.74 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$COMMERCE\LOG\ERRORLOG'.
2004-05-28 16:34:39.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-05-28 16:34:39.82 server SQL Server configured for thread mode
processing.
2004-05-28 16:34:39.84 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-05-28 16:34:39.89 spid3 Starting up database 'master'.
2004-05-28 16:34:40.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-28 16:34:40.29 spid5 Starting up database 'model'.
2004-05-28 16:34:40.34 spid3 Server name is 'MANOSVMXP\COMMERCE'.
2004-05-28 16:34:40.35 spid3 Skipping startup of clean database id 4
2004-05-28 16:34:40.37 server SQL server listening on 192.5.129.70: 1041.
2004-05-28 16:34:40.38 server SQL server listening on 127.0.0.1: 1041.
2004-05-28 16:34:40.58 spid5 Clearing tempdb database.
2004-05-28 16:34:41.41 spid5 Starting up database 'tempdb'.
2004-05-28 16:34:41.76 spid3 Recovery complete.
2004-05-28 16:34:41.77 spid3 SQL global counter collection task is
created.
2004-05-28 16:34:42.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-05-28 16:34:42.69 server SQL Server is ready for client connections
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for you update!
> However, I am still not sure about the root cause of this issue, Would you
> please help me collection more detailed information? More detailed
> information, I believe, will get us closer to the resolutions
> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for your updates!
Since you could start MSSQL Services, could you tell me what's the command
in "Path to executable"? (You could find Path to executeable in Control
Panel -> Services -> Right Click MSSQLServer\InstanceName)
Secondly, try to find what's the result of command "net start
mssqlserver\InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
Finally, it seems OK with your Log files. Would you please tell me when if
hangs in "SQL Server is ready for client connections", Could you login the
server? If not, what's the error message and error number you will get?
Anyway, Would you please show me why do you like to startup
MSSQLServer\InstanceName with command? Maybe it will be easier for us
finding a workaround
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
MSSQL. "Commerce" is the instance name.
Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
System error 123 has occured.
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
it is hanging the command from a dos prompt and then I am trying from the
services by right clicking to start and I get an error (message actually)
which says "The MSSQL$COMMERCE service on Local Computer started and then
stopped. Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
>
I am using InstallShield to install an application to the target machine. I
have configured the merge modules of the SQL Server 2k with sp3 to install
and everything is working fine if I use the default instance name. Sinse
other software manufacturers are using the default instance name there is a
problem installing all software in one machine. So I thought that changing
the instance name of my app would solve this problem and I could have my app
running with a different instance name. There is where the problem started
and I cannot start the SQL server with this instance name. From my code I am
usinf the command to start the SQL.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
> Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||I am trying to start the SQL with SQL Server object and command start to
start it but since I cannot do it like this I am trying with command line
and this is not working either.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Since you could start MSSQL Services, could you tell me what's the command
> The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
> MSSQL. "Commerce" is the instance name.
>
> Secondly, try to find what's the result of command "net start
> System error 123 has occured.
>
if[vbcol=seagreen]
the
> it is hanging the command from a dos prompt and then I am trying from the
> services by right clicking to start and I get an error (message actually)
> which says "The MSSQL$COMMERCE service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> I am using InstallShield to install an application to the target machine.
I
> have configured the merge modules of the SQL Server 2k with sp3 to install
> and everything is working fine if I use the default instance name. Sinse
> other software manufacturers are using the default instance name there is
a
> problem installing all software in one machine. So I thought that changing
> the instance name of my app would solve this problem and I could have my
app
> running with a different instance name. There is where the problem started
> and I cannot start the SQL server with this instance name. From my code I
am[vbcol=seagreen]
> usinf the command to start the SQL.
>
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
command[vbcol=seagreen]
if[vbcol=seagreen]
the[vbcol=seagreen]
rights.
>
|||Hi Yiannis,
Oops, It's an type that you shoud use $ instead of \
try to find what's the result of command "net start
mssqlserver$InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
What's the result of it? Could you start SQL Server successfully?
If you could, will this satisfy your requirements?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
I did it and I get an error "The service name is invalid"
I was looking at my previous post and I realize that it doesn;t make sense
what I wrote. The way I am trying to start SQL is with the Server object
from SQL-DMO. Since I cannot do it like this I am trying to start the server
with the command line.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> What's the result of it? Could you start SQL Server successfully?
> If you could, will this satisfy your requirements?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
and I cannot start the SQL server when the instance name is other than the
default. Can someone tell me what is wrong?
Hi Yiannis,
From your descriptions, I understood that you could not start SQL Server's
instance when this instance is not the default one by MSDE. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my knowledge, database engine operates as a service or process
that is separate from any application using MSDE 2000. Either MSDE 2000 or
any other version of SQL Server can be running at the same time on the same
computer. Each copy is called an instance. Each instance is installed,
started, stopped, configured, and patched independently of the other
instances.
However, I am not sure your steps about the installation and start-up for
the instance and what error messages could you find Event Log. Would you
please give me detailed descriptions about it, which I believe, will get us
closer to the resolution
Could you give me a descriptions, with which Icould reproduce it on my machine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Here is how things are. With a setup project I am using all the merge
modules to install the SQL MSDE to the machine. When I configure the server
to use the default instance everything is going fine. When I change the
instance name and I use a named one then when I try to start the server
(same command "start") the server doesn;t start at all. I am trying to start
the server with the command from the instance binn dir "sqlservr -scommerce"
and I cannot start it. When I use the sqlmanagr to start the server it is
starting but the command doesn't start it.
Running machine is an XP Professional version 2002.
From the command prompt the command is going till "SQL Server is ready for
client connections" and never gets to an end.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> From your descriptions, I understood that you could not start SQL Server's
> instance when this instance is not the default one by MSDE. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know
> Based on my knowledge, database engine operates as a service or process
> that is separate from any application using MSDE 2000. Either MSDE 2000 or
> any other version of SQL Server can be running at the same time on the
same
> computer. Each copy is called an instance. Each instance is installed,
> started, stopped, configured, and patched independently of the other
> instances.
> However, I am not sure your steps about the installation and start-up for
> the instance and what error messages could you find Event Log. Would you
> please give me detailed descriptions about it, which I believe, will get
us
> closer to the resolution
Could you give me a descriptions, with which I> could reproduce it on my machine?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for you update!
However, I am still not sure about the root cause of this issue, Would you
please help me collection more detailed information? More detailed
information, I believe, will get us closer to the resolutions
First of all, could you start MSSQL Services by means of Control Panel ->
Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
Services by running Command "net start mssqlserver" (without quotation
marks)?
Secondly, could you see some error logs when you are starting up the SQL
Server? Error Number will be the most helpful ones for us to
troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
about the startup and post it here?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer?
Yes I can.
Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
The server is doesn't start. When I press Enter a dialog opens and closes
but I don';t have a chance to see anything.
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
>
Here is the log file.
2004-05-28 16:34:39.69 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )
2004-05-28 16:34:39.72 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-28 16:34:39.73 server All rights reserved.
2004-05-28 16:34:39.74 server Server Process ID is 2680.
2004-05-28 16:34:39.74 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$COMMERCE\LOG\ERRORLOG'.
2004-05-28 16:34:39.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-05-28 16:34:39.82 server SQL Server configured for thread mode
processing.
2004-05-28 16:34:39.84 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-05-28 16:34:39.89 spid3 Starting up database 'master'.
2004-05-28 16:34:40.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-28 16:34:40.29 spid5 Starting up database 'model'.
2004-05-28 16:34:40.34 spid3 Server name is 'MANOSVMXP\COMMERCE'.
2004-05-28 16:34:40.35 spid3 Skipping startup of clean database id 4
2004-05-28 16:34:40.37 server SQL server listening on 192.5.129.70: 1041.
2004-05-28 16:34:40.38 server SQL server listening on 127.0.0.1: 1041.
2004-05-28 16:34:40.58 spid5 Clearing tempdb database.
2004-05-28 16:34:41.41 spid5 Starting up database 'tempdb'.
2004-05-28 16:34:41.76 spid3 Recovery complete.
2004-05-28 16:34:41.77 spid3 SQL global counter collection task is
created.
2004-05-28 16:34:42.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-05-28 16:34:42.69 server SQL Server is ready for client connections
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for you update!
> However, I am still not sure about the root cause of this issue, Would you
> please help me collection more detailed information? More detailed
> information, I believe, will get us closer to the resolutions
> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for your updates!
Since you could start MSSQL Services, could you tell me what's the command
in "Path to executable"? (You could find Path to executeable in Control
Panel -> Services -> Right Click MSSQLServer\InstanceName)
Secondly, try to find what's the result of command "net start
mssqlserver\InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
Finally, it seems OK with your Log files. Would you please tell me when if
hangs in "SQL Server is ready for client connections", Could you login the
server? If not, what's the error message and error number you will get?
Anyway, Would you please show me why do you like to startup
MSSQLServer\InstanceName with command? Maybe it will be easier for us
finding a workaround
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
MSSQL. "Commerce" is the instance name.
Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
System error 123 has occured.
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
it is hanging the command from a dos prompt and then I am trying from the
services by right clicking to start and I get an error (message actually)
which says "The MSSQL$COMMERCE service on Local Computer started and then
stopped. Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
>
I am using InstallShield to install an application to the target machine. I
have configured the merge modules of the SQL Server 2k with sp3 to install
and everything is working fine if I use the default instance name. Sinse
other software manufacturers are using the default instance name there is a
problem installing all software in one machine. So I thought that changing
the instance name of my app would solve this problem and I could have my app
running with a different instance name. There is where the problem started
and I cannot start the SQL server with this instance name. From my code I am
usinf the command to start the SQL.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
> Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||I am trying to start the SQL with SQL Server object and command start to
start it but since I cannot do it like this I am trying with command line
and this is not working either.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Since you could start MSSQL Services, could you tell me what's the command
> The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
> MSSQL. "Commerce" is the instance name.
>
> Secondly, try to find what's the result of command "net start
> System error 123 has occured.
>
if[vbcol=seagreen]
the
> it is hanging the command from a dos prompt and then I am trying from the
> services by right clicking to start and I get an error (message actually)
> which says "The MSSQL$COMMERCE service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> I am using InstallShield to install an application to the target machine.
I
> have configured the merge modules of the SQL Server 2k with sp3 to install
> and everything is working fine if I use the default instance name. Sinse
> other software manufacturers are using the default instance name there is
a
> problem installing all software in one machine. So I thought that changing
> the instance name of my app would solve this problem and I could have my
app
> running with a different instance name. There is where the problem started
> and I cannot start the SQL server with this instance name. From my code I
am[vbcol=seagreen]
> usinf the command to start the SQL.
>
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
command[vbcol=seagreen]
if[vbcol=seagreen]
the[vbcol=seagreen]
rights.
>
|||Hi Yiannis,
Oops, It's an type that you shoud use $ instead of \
try to find what's the result of command "net start
mssqlserver$InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
What's the result of it? Could you start SQL Server successfully?
If you could, will this satisfy your requirements?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
I did it and I get an error "The service name is invalid"
I was looking at my previous post and I realize that it doesn;t make sense
what I wrote. The way I am trying to start SQL is with the Server object
from SQL-DMO. Since I cannot do it like this I am trying to start the server
with the command line.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> What's the result of it? Could you start SQL Server successfully?
> If you could, will this satisfy your requirements?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
Cnot start SQL Server 2000sp3
I have installed MSDE version of SQL server 2000 and sp3 with merge modules
and I cannot start the SQL server when the instance name is other than the
default. Can someone tell me what is wrong?Hi Yiannis,
From your descriptions, I understood that you could not start SQL Server's
instance when this instance is not the default one by MSDE. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)
Based on my knowledge, database engine operates as a service or process
that is separate from any application using MSDE 2000. Either MSDE 2000 or
any other version of SQL Server can be running at the same time on the same
computer. Each copy is called an instance. Each instance is installed,
started, stopped, configured, and patched independently of the other
instances.
However, I am not sure your steps about the installation and start-up for
the instance and what error messages could you find Event Log. Would you
please give me detailed descriptions about it, which I believe, will get us
closer to the resolution:) Could you give me a descriptions, with which I
could reproduce it on my machine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Here is how things are. With a setup project I am using all the merge
modules to install the SQL MSDE to the machine. When I configure the server
to use the default instance everything is going fine. When I change the
instance name and I use a named one then when I try to start the server
(same command "start") the server doesn;t start at all. I am trying to start
the server with the command from the instance binn dir "sqlservr -scommerce"
and I cannot start it. When I use the sqlmanagr to start the server it is
starting but the command doesn't start it.
Running machine is an XP Professional version 2002.
From the command prompt the command is going till "SQL Server is ready for
client connections" and never gets to an end.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> From your descriptions, I understood that you could not start SQL Server's
> instance when this instance is not the default one by MSDE. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know:)
> Based on my knowledge, database engine operates as a service or process
> that is separate from any application using MSDE 2000. Either MSDE 2000 or
> any other version of SQL Server can be running at the same time on the
same
> computer. Each copy is called an instance. Each instance is installed,
> started, stopped, configured, and patched independently of the other
> instances.
> However, I am not sure your steps about the installation and start-up for
> the instance and what error messages could you find Event Log. Would you
> please give me detailed descriptions about it, which I believe, will get
us
> closer to the resolution:) Could you give me a descriptions, with which I
> could reproduce it on my machine?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Yiannis,
Thanks for you update!
However, I am still not sure about the root cause of this issue, Would you
please help me collection more detailed information? More detailed
information, I believe, will get us closer to the resolutions :)
First of all, could you start MSSQL Services by means of Control Panel ->
Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
Services by running Command "net start mssqlserver" (without quotation
marks)?
Secondly, could you see some error logs when you are starting up the SQL
Server? Error Number will be the most helpful ones for us to
troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
about the startup and post it here?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer?
Yes I can.
Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
The server is doesn't start. When I press Enter a dialog opens and closes
but I don';t have a chance to see anything.
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
>
Here is the log file.
2004-05-28 16:34:39.69 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )
2004-05-28 16:34:39.72 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-28 16:34:39.73 server All rights reserved.
2004-05-28 16:34:39.74 server Server Process ID is 2680.
2004-05-28 16:34:39.74 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$COMMERCE\LOG\ERRORLOG'.
2004-05-28 16:34:39.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-05-28 16:34:39.82 server SQL Server configured for thread mode
processing.
2004-05-28 16:34:39.84 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-05-28 16:34:39.89 spid3 Starting up database 'master'.
2004-05-28 16:34:40.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-28 16:34:40.29 spid5 Starting up database 'model'.
2004-05-28 16:34:40.34 spid3 Server name is 'MANOSVMXP\COMMERCE'.
2004-05-28 16:34:40.35 spid3 Skipping startup of clean database id 4
2004-05-28 16:34:40.37 server SQL server listening on 192.5.129.70: 1041.
2004-05-28 16:34:40.38 server SQL server listening on 127.0.0.1: 1041.
2004-05-28 16:34:40.58 spid5 Clearing tempdb database.
2004-05-28 16:34:41.41 spid5 Starting up database 'tempdb'.
2004-05-28 16:34:41.76 spid3 Recovery complete.
2004-05-28 16:34:41.77 spid3 SQL global counter collection task is
created.
2004-05-28 16:34:42.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-05-28 16:34:42.69 server SQL Server is ready for client connections
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for you update!
> However, I am still not sure about the root cause of this issue, Would you
> please help me collection more detailed information? More detailed
> information, I believe, will get us closer to the resolutions :)
> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Yiannis,
Thanks for your updates!
Since you could start MSSQL Services, could you tell me what's the command
in "Path to executable"? (You could find Path to executeable in Control
Panel -> Services -> Right Click MSSQLServer\InstanceName)
Secondly, try to find what's the result of command "net start
mssqlserver\InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
Finally, it seems OK with your Log files. Would you please tell me when if
hangs in "SQL Server is ready for client connections", Could you login the
server? If not, what's the error message and error number you will get?
Anyway, Would you please show me why do you like to startup
MSSQLServer\InstanceName with command? Maybe it will be easier for us
finding a workaround:)
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
MSSQL. "Commerce" is the instance name.
Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
System error 123 has occured.
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
it is hanging the command from a dos prompt and then I am trying from the
services by right clicking to start and I get an error (message actually)
which says "The MSSQL$COMMERCE service on Local Computer started and then
stopped. Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround:)
>
I am using InstallShield to install an application to the target machine. I
have configured the merge modules of the SQL Server 2k with sp3 to install
and everything is working fine if I use the default instance name. Sinse
other software manufacturers are using the default instance name there is a
problem installing all software in one machine. So I thought that changing
the instance name of my app would solve this problem and I could have my app
running with a different instance name. There is where the problem started
and I cannot start the SQL server with this instance name. From my code I am
usinf the command to start the SQL.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
> Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround:)
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||I am trying to start the SQL with SQL Server object and command start to
start it but since I cannot do it like this I am trying with command line
and this is not working either.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl...
> Since you could start MSSQL Services, could you tell me what's the command
> > in "Path to executable"? (You could find Path to executeable in Control
> > Panel -> Services -> Right Click MSSQLServer\InstanceName)
> The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
> MSSQL. "Commerce" is the instance name.
>
> Secondly, try to find what's the result of command "net start
> > mssqlserver\InstanceName" you could do it in the following ways
> > 1. Strat -> Run -> typing "cmd" , without quatation marks
> > 2. "net start mssqlserver\InstanceName"
> System error 123 has occured.
>
> > Finally, it seems OK with your Log files. Would you please tell me when
if
> > hangs in "SQL Server is ready for client connections", Could you login
the
> > server? If not, what's the error message and error number you will get?
> it is hanging the command from a dos prompt and then I am trying from the
> services by right clicking to start and I get an error (message actually)
> which says "The MSSQL$COMMERCE service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> > Anyway, Would you please show me why do you like to startup
> > MSSQLServer\InstanceName with command? Maybe it will be easier for us
> > finding a workaround:)
> >
> I am using InstallShield to install an application to the target machine.
I
> have configured the merge modules of the SQL Server 2k with sp3 to install
> and everything is working fine if I use the default instance name. Sinse
> other software manufacturers are using the default instance name there is
a
> problem installing all software in one machine. So I thought that changing
> the instance name of my app would solve this problem and I could have my
app
> running with a different instance name. There is where the problem started
> and I cannot start the SQL server with this instance name. From my code I
am
> usinf the command to start the SQL.
>
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> > Hi Yiannis,
> >
> > Thanks for your updates!
> >
> > Since you could start MSSQL Services, could you tell me what's the
command
> > in "Path to executable"? (You could find Path to executeable in Control
> > Panel -> Services -> Right Click MSSQLServer\InstanceName)
> >
> > Secondly, try to find what's the result of command "net start
> > mssqlserver\InstanceName" you could do it in the following ways
> > 1. Strat -> Run -> typing "cmd" , without quatation marks
> > 2. "net start mssqlserver\InstanceName"
> >
> > Finally, it seems OK with your Log files. Would you please tell me when
if
> > hangs in "SQL Server is ready for client connections", Could you login
the
> > server? If not, what's the error message and error number you will get?
> >
> > Anyway, Would you please show me why do you like to startup
> > MSSQLServer\InstanceName with command? Maybe it will be easier for us
> > finding a workaround:)
> >
> > Sincerely yours,
> >
> > Mingqing Cheng
> > Microsoft Online Support
> > ---
> > Get Secure! - www.microsoft.com/security
> > This posting is provided "as is" with no warranties and confers no
rights.
> > Please reply to newsgroups only, many thanks!
> >
>|||Hi Yiannis,
Oops, It's an type that you shoud use $ instead of \
try to find what's the result of command "net start
mssqlserver$InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
What's the result of it? Could you start SQL Server successfully?
If you could, will this satisfy your requirements?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
I did it and I get an error "The service name is invalid"
I was looking at my previous post and I realize that it doesn;t make sense
what I wrote. The way I am trying to start SQL is with the Server object
from SQL-DMO. Since I cannot do it like this I am trying to start the server
with the command line.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> What's the result of it? Could you start SQL Server successfully?
> If you could, will this satisfy your requirements?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Yiannis,
Thanks for your updates!
Unfortunatly, I am still not sure why you could not open your server with
"net start mssqlserver$COMMERCE". Would you please show me some detailed
information about it?
From your deccriptions, I understood you would like to start SQL Server
with SQL-DMO. Have I understood you? If there is anything I misunderstood,
please feel free to let me know :)
Based on my knowledge, SQL-DMO have Start method to do the job
Start Method (SQLServer)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
ef_m_s_7vg2.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||> Unfortunatly, I am still not sure why you could not open your server with
> "net start mssqlserver$COMMERCE". Would you please show me some detailed
> information about it?
What kind of detailed information would you like?
> From your deccriptions, I understood you would like to start SQL Server
> with SQL-DMO. Have I understood you? If there is anything I misunderstood,
> please feel free to let me know :)
>
It is not that I would like to start SQL Server with SQL-DMO. It is that the
application I have starts SQL with SQL-DMO and when the instance name is the
default then everything is fine. The problem starts when the instance name
is other ther the default ie. COMMERCE.
Is there any possibility that the COMMERCE as an instance name is not an
allowed to use word?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Unfortunatly, I am still not sure why you could not open your server with
> "net start mssqlserver$COMMERCE". Would you please show me some detailed
> information about it?
> From your deccriptions, I understood you would like to start SQL Server
> with SQL-DMO. Have I understood you? If there is anything I misunderstood,
> please feel free to let me know :)
> Based on my knowledge, SQL-DMO have Start method to do the job
> Start Method (SQLServer)
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> ef_m_s_7vg2.asp
> Hope this helps and if you have any questions or concerns, don't hesitate
> to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Considering that the instance name of the SQL is "Commerce" can you please
tell me the exact command to start the SQL server with SQL-DMO.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> > Unfortunatly, I am still not sure why you could not open your server
with
> > "net start mssqlserver$COMMERCE". Would you please show me some detailed
> > information about it?
> What kind of detailed information would you like?
> > From your deccriptions, I understood you would like to start SQL Server
> > with SQL-DMO. Have I understood you? If there is anything I
misunderstood,
> > please feel free to let me know :)
> >
> It is not that I would like to start SQL Server with SQL-DMO. It is that
the
> application I have starts SQL with SQL-DMO and when the instance name is
the
> default then everything is fine. The problem starts when the instance name
> is other ther the default ie. COMMERCE.
> Is there any possibility that the COMMERCE as an instance name is not an
> allowed to use word?
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> > Hi Yiannis,
> >
> > Thanks for your updates!
> >
> > Unfortunatly, I am still not sure why you could not open your server
with
> > "net start mssqlserver$COMMERCE". Would you please show me some detailed
> > information about it?
> >
> > From your deccriptions, I understood you would like to start SQL Server
> > with SQL-DMO. Have I understood you? If there is anything I
misunderstood,
> > please feel free to let me know :)
> >
> > Based on my knowledge, SQL-DMO have Start method to do the job
> >
> > Start Method (SQLServer)
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> > ef_m_s_7vg2.asp
> >
> > Hope this helps and if you have any questions or concerns, don't
hesitate
> > to let me know. We are here to be of assistance!
> >
> > Sincerely yours,
> >
> > Mingqing Cheng
> > Microsoft Online Support
> > ---
> > Get Secure! - www.microsoft.com/security
> > This posting is provided "as is" with no warranties and confers no
rights.
> > Please reply to newsgroups only, many thanks!
> >
>|||Hi Yiannis,
We are looking for somebody who is familar with SQL DMO and will reply him with more information as soon as possible. Thanks very much.
Best regards,
Yanhong Huang
Microsoft Community Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Yiannis,
Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
information.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
ef_con01_5qup.asp?frame=true
SQL-DMO Syntax to start SQL server is ,
--Syntax
object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
Also, the SQL Server Service name of the instance can be accessed as
"MSSQL$<instance name>"
Here is a sample code snippet using C++ to start the sqlserver instace of
name "Commerce",
HRESULT hr;
LPSQLDMOSERVER pSQLServer;
WCHAR* szServiceName = L"MSSQL$Commerce";
BOOL fConnect=0;
WCHAR* szLogin= L"Login";
WCHAR* szPassword = L"pswd";
hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
if (SUCCEEDED(hr))
pSQLServer->SetName (szServiceName);
pSQLServer->Start(fConnect,szLogin,szPassword);
pSQLServer->Release();
Please let me know if this resolves the problem, else feel free to post
further questions,
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Sat, 5 Jun 2004 13:58:01 +0300
>Lines: 73
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 62.103.238.182
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Considering that the instance name of the SQL is "Commerce" can you please
>tell me the exact command to start the SQL server with SQL-DMO.
>
>
>"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
>news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
>> > Unfortunatly, I am still not sure why you could not open your server
>with
>> > "net start mssqlserver$COMMERCE". Would you please show me some
detailed
>> > information about it?
>> What kind of detailed information would you like?
>> > From your deccriptions, I understood you would like to start SQL Server
>> > with SQL-DMO. Have I understood you? If there is anything I
>misunderstood,
>> > please feel free to let me know :)
>> >
>> It is not that I would like to start SQL Server with SQL-DMO. It is that
>the
>> application I have starts SQL with SQL-DMO and when the instance name is
>the
>> default then everything is fine. The problem starts when the instance
name
>> is other ther the default ie. COMMERCE.
>> Is there any possibility that the COMMERCE as an instance name is not an
>> allowed to use word?
>>
>> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
message
>> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
>> > Hi Yiannis,
>> >
>> > Thanks for your updates!
>> >
>> > Unfortunatly, I am still not sure why you could not open your server
>with
>> > "net start mssqlserver$COMMERCE". Would you please show me some
detailed
>> > information about it?
>> >
>> > From your deccriptions, I understood you would like to start SQL Server
>> > with SQL-DMO. Have I understood you? If there is anything I
>misunderstood,
>> > please feel free to let me know :)
>> >
>> > Based on my knowledge, SQL-DMO have Start method to do the job
>> >
>> > Start Method (SQLServer)
>> >
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
r
>> > ef_m_s_7vg2.asp
>> >
>> > Hope this helps and if you have any questions or concerns, don't
>hesitate
>> > to let me know. We are here to be of assistance!
>> >
>> > Sincerely yours,
>> >
>> > Mingqing Cheng
>> > Microsoft Online Support
>> > ---
>> > Get Secure! - www.microsoft.com/security
>> > This posting is provided "as is" with no warranties and confers no
>rights.
>> > Please reply to newsgroups only, many thanks!
>> >
>>
>
>|||> pSQLServer->Start(fConnect,szLogin,szPassword);
You are missing one parameter which is the server (2nd parameter).
"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in message
news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> Hello Yiannis,
> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> information.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> ef_con01_5qup.asp?frame=true
>
> SQL-DMO Syntax to start SQL server is ,
> --Syntax
> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> Also, the SQL Server Service name of the instance can be accessed as
> "MSSQL$<instance name>"
> Here is a sample code snippet using C++ to start the sqlserver instace of
> name "Commerce",
> HRESULT hr;
> LPSQLDMOSERVER pSQLServer;
> WCHAR* szServiceName = L"MSSQL$Commerce";
> BOOL fConnect=0;
> WCHAR* szLogin= L"Login";
> WCHAR* szPassword = L"pswd";
> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
> if (SUCCEEDED(hr))
> pSQLServer->SetName (szServiceName);
> pSQLServer->Start(fConnect,szLogin,szPassword);
> pSQLServer->Release();
> Please let me know if this resolves the problem, else feel free to post
> further questions,
> Thanks for using MSDN Managed Newsgroup.
> Vikrant Dalwale
> Microsoft SQL Server Support Professional
>
> Microsoft highly recommends to all of our customers that they visit the
> http://www.microsoft.com/protect site and perform the three
straightforward
> steps listed to improve your computer?s security.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> >Subject: Re: Cnot start SQL Server 2000sp3
> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> >Lines: 73
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 62.103.238.182
> >Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
> phx.gbl
> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >Considering that the instance name of the SQL is "Commerce" can you
please
> >tell me the exact command to start the SQL server with SQL-DMO.
> >
> >
> >
> >
> >
> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> >> > Unfortunatly, I am still not sure why you could not open your server
> >with
> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> detailed
> >> > information about it?
> >>
> >> What kind of detailed information would you like?
> >>
> >> > From your deccriptions, I understood you would like to start SQL
Server
> >> > with SQL-DMO. Have I understood you? If there is anything I
> >misunderstood,
> >> > please feel free to let me know :)
> >> >
> >> It is not that I would like to start SQL Server with SQL-DMO. It is
that
> >the
> >> application I have starts SQL with SQL-DMO and when the instance name
is
> >the
> >> default then everything is fine. The problem starts when the instance
> name
> >> is other ther the default ie. COMMERCE.
> >> Is there any possibility that the COMMERCE as an instance name is not
an
> >> allowed to use word?
> >>
> >>
> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> message
> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> >> > Hi Yiannis,
> >> >
> >> > Thanks for your updates!
> >> >
> >> > Unfortunatly, I am still not sure why you could not open your server
> >with
> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> detailed
> >> > information about it?
> >> >
> >> > From your deccriptions, I understood you would like to start SQL
Server
> >> > with SQL-DMO. Have I understood you? If there is anything I
> >misunderstood,
> >> > please feel free to let me know :)
> >> >
> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> >> >
> >> > Start Method (SQLServer)
> >> >
> >>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> r
> >> > ef_m_s_7vg2.asp
> >> >
> >> > Hope this helps and if you have any questions or concerns, don't
> >hesitate
> >> > to let me know. We are here to be of assistance!
> >> >
> >> > Sincerely yours,
> >> >
> >> > Mingqing Cheng
> >> > Microsoft Online Support
> >> > ---
> >> > Get Secure! - www.microsoft.com/security
> >> > This posting is provided "as is" with no warranties and confers no
> >rights.
> >> > Please reply to newsgroups only, many thanks!
> >> >
> >>
> >>
> >
> >
> >
>|||Hello Yiannis,
Server Paramter is one of the 'optional' parameters. Since I set the
Service Name in
pSQLServer->SetName (szServiceName); I didn't use the Server Param.
Does that answer your question ?
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
<uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
<o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Tue, 8 Jun 2004 22:40:15 +0300
>Lines: 186
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 62.103.183.221
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09|||I have been trying to find an example (like the one you gave me) how I can
start an SQL server using SQL-DMO and I couldn't find anywhere.
I am not saying the MSDN but an example.
Thanks a lot for your help
"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in message
news:OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl...
>
> Hello Yiannis,
> Server Paramter is one of the 'optional' parameters. Since I set the
> Service Name in
> pSQLServer->SetName (szServiceName); I didn't use the Server Param.
> Does that answer your question ?
> Thanks for using MSDN Managed Newsgroup.
> Vikrant Dalwale
> Microsoft SQL Server Support Professional
>
> Microsoft highly recommends to all of our customers that they visit the
> http://www.microsoft.com/protect site and perform the three
straightforward
> steps listed to improve your computer?s security.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> <o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
> >Subject: Re: Cnot start SQL Server 2000sp3
> >Date: Tue, 8 Jun 2004 22:40:15 +0300
> >Lines: 186
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 62.103.183.221
> >Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> phx.gbl
> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344998
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >> pSQLServer->Start(fConnect,szLogin,szPassword);
> >
> >
> >You are missing one parameter which is the server (2nd parameter).
> >
> >
> >
> >
> >"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
message
> >news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> >>
> >> Hello Yiannis,
> >>
> >> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> >> information.
> >>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> r
> >> ef_con01_5qup.asp?frame=true
> >>
> >>
> >> SQL-DMO Syntax to start SQL server is ,
> >>
> >> --Syntax
> >> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> >>
> >> Also, the SQL Server Service name of the instance can be accessed as
> >> "MSSQL$<instance name>"
> >>
> >> Here is a sample code snippet using C++ to start the sqlserver instace
> of
> >> name "Commerce",
> >>
> >> HRESULT hr;
> >> LPSQLDMOSERVER pSQLServer;
> >> WCHAR* szServiceName = L"MSSQL$Commerce";
> >> BOOL fConnect=0;
> >> WCHAR* szLogin= L"Login";
> >> WCHAR* szPassword = L"pswd";
> >>
> >> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> >> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
> >>
> >> if (SUCCEEDED(hr))
> >> pSQLServer->SetName (szServiceName);
> >> pSQLServer->Start(fConnect,szLogin,szPassword);
> >>
> >> pSQLServer->Release();
> >>
> >> Please let me know if this resolves the problem, else feel free to post
> >> further questions,
> >>
> >> Thanks for using MSDN Managed Newsgroup.
> >>
> >> Vikrant Dalwale
> >>
> >> Microsoft SQL Server Support Professional
> >>
> >>
> >> Microsoft highly recommends to all of our customers that they visit
the
> >> http://www.microsoft.com/protect site and perform the three
> >straightforward
> >> steps listed to improve your computer?s security.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >rights.
> >>
> >>
> >>
> >> --
> >> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> >> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> >> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> >> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> >> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> >> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> >> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> >> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> >> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> >> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> >> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> >> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> >> >Subject: Re: Cnot start SQL Server 2000sp3
> >> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> >> >Lines: 73
> >> >X-Priority: 3
> >> >X-MSMail-Priority: Normal
> >> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> >> >Newsgroups: microsoft.public.sqlserver.server
> >> >NNTP-Posting-Host: 62.103.238.182
> >> >Path:
> >>
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> 1
> >> phx.gbl
> >> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> >> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >> >
> >> >Considering that the instance name of the SQL is "Commerce" can you
> >please
> >> >tell me the exact command to start the SQL server with SQL-DMO.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> >> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> >> >> > Unfortunatly, I am still not sure why you could not open your
server
> >> >with
> >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> >> detailed
> >> >> > information about it?
> >> >>
> >> >> What kind of detailed information would you like?
> >> >>
> >> >> > From your deccriptions, I understood you would like to start SQL
> >Server
> >> >> > with SQL-DMO. Have I understood you? If there is anything I
> >> >misunderstood,
> >> >> > please feel free to let me know :)
> >> >> >
> >> >> It is not that I would like to start SQL Server with SQL-DMO. It is
> >that
> >> >the
> >> >> application I have starts SQL with SQL-DMO and when the instance
name
> >is
> >> >the
> >> >> default then everything is fine. The problem starts when the
instance
> >> name
> >> >> is other ther the default ie. COMMERCE.
> >> >> Is there any possibility that the COMMERCE as an instance name is
not
> >an
> >> >> allowed to use word?
> >> >>
> >> >>
> >> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> >> message
> >> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> >> >> > Hi Yiannis,
> >> >> >
> >> >> > Thanks for your updates!
> >> >> >
> >> >> > Unfortunatly, I am still not sure why you could not open your
server
> >> >with
> >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> >> detailed
> >> >> > information about it?
> >> >> >
> >> >> > From your deccriptions, I understood you would like to start SQL
> >Server
> >> >> > with SQL-DMO. Have I understood you? If there is anything I
> >> >misunderstood,
> >> >> > please feel free to let me know :)
> >> >> >
> >> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> >> >> >
> >> >> > Start Method (SQLServer)
> >> >> >
> >> >>
> >>
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dm
> o
> >> r
> >> >> > ef_m_s_7vg2.asp
> >> >> >
> >> >> > Hope this helps and if you have any questions or concerns, don't
> >> >hesitate
> >> >> > to let me know. We are here to be of assistance!
> >> >> >
> >> >> > Sincerely yours,
> >> >> >
> >> >> > Mingqing Cheng
> >> >> > Microsoft Online Support
> >> >> > ---
> >> >> > Get Secure! - www.microsoft.com/security
> >> >> > This posting is provided "as is" with no warranties and confers no
> >> >rights.
> >> >> > Please reply to newsgroups only, many thanks!
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >
> >
> >
>|||I tried the command and I cannot make it work. I still have a problem
starting SQL. By the way I found a solution on an XP machine to start it by
the "net start MSSQL$COMMERCE". The problem now is on Windows 98. What
should I do?
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:OPvc#AfTEHA.644@.tk2msftngp13.phx.gbl...
> I have been trying to find an example (like the one you gave me) how I can
> start an SQL server using SQL-DMO and I couldn't find anywhere.
> I am not saying the MSDN but an example.
> Thanks a lot for your help
>
> "Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
message
> news:OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl...
> >
> >
> > Hello Yiannis,
> >
> > Server Paramter is one of the 'optional' parameters. Since I set the
> > Service Name in
> > pSQLServer->SetName (szServiceName); I didn't use the Server Param.
> >
> > Does that answer your question ?
> >
> > Thanks for using MSDN Managed Newsgroup.
> >
> > Vikrant Dalwale
> >
> > Microsoft SQL Server Support Professional
> >
> >
> > Microsoft highly recommends to all of our customers that they visit the
> > http://www.microsoft.com/protect site and perform the three
> straightforward
> > steps listed to improve your computer?s security.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > --
> > >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> > >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> > <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> > <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> > <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> > <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> > <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> > <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> > <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> > <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> > <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> > <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> > <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> > <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> > <o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
> > >Subject: Re: Cnot start SQL Server 2000sp3
> > >Date: Tue, 8 Jun 2004 22:40:15 +0300
> > >Lines: 186
> > >X-Priority: 3
> > >X-MSMail-Priority: Normal
> > >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> > >Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
> > >Newsgroups: microsoft.public.sqlserver.server
> > >NNTP-Posting-Host: 62.103.183.221
> > >Path:
> >
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> > phx.gbl
> > >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344998
> > >X-Tomcat-NG: microsoft.public.sqlserver.server
> > >
> > >> pSQLServer->Start(fConnect,szLogin,szPassword);
> > >
> > >
> > >You are missing one parameter which is the server (2nd parameter).
> > >
> > >
> > >
> > >
> > >"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
> message
> > >news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> > >>
> > >> Hello Yiannis,
> > >>
> > >> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> > >> information.
> > >>
> >
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> > r
> > >> ef_con01_5qup.asp?frame=true
> > >>
> > >>
> > >> SQL-DMO Syntax to start SQL server is ,
> > >>
> > >> --Syntax
> > >> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> > >>
> > >> Also, the SQL Server Service name of the instance can be accessed as
> > >> "MSSQL$<instance name>"
> > >>
> > >> Here is a sample code snippet using C++ to start the sqlserver
instace
> > of
> > >> name "Commerce",
> > >>
> > >> HRESULT hr;
> > >> LPSQLDMOSERVER pSQLServer;
> > >> WCHAR* szServiceName = L"MSSQL$Commerce";
> > >> BOOL fConnect=0;
> > >> WCHAR* szLogin= L"Login";
> > >> WCHAR* szPassword = L"pswd";
> > >>
> > >> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> > >> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**)
&pSQLServer);
> > >>
> > >> if (SUCCEEDED(hr))
> > >> pSQLServer->SetName (szServiceName);
> > >> pSQLServer->Start(fConnect,szLogin,szPassword);
> > >>
> > >> pSQLServer->Release();
> > >>
> > >> Please let me know if this resolves the problem, else feel free to
post
> > >> further questions,
> > >>
> > >> Thanks for using MSDN Managed Newsgroup.
> > >>
> > >> Vikrant Dalwale
> > >>
> > >> Microsoft SQL Server Support Professional
> > >>
> > >>
> > >> Microsoft highly recommends to all of our customers that they visit
> the
> > >> http://www.microsoft.com/protect site and perform the three
> > >straightforward
> > >> steps listed to improve your computer?s security.
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >rights.
> > >>
> > >>
> > >>
> > >> --
> > >> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> > >> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> > >> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> > >> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> > >> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> > >> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> > >> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> > >> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> > >> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> > >> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> > >> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> > >> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> > >> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> > >> >Subject: Re: Cnot start SQL Server 2000sp3
> > >> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> > >> >Lines: 73
> > >> >X-Priority: 3
> > >> >X-MSMail-Priority: Normal
> > >> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> > >> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> > >> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> > >> >Newsgroups: microsoft.public.sqlserver.server
> > >> >NNTP-Posting-Host: 62.103.238.182
> > >> >Path:
> > >>
> >
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> > 1
> > >> phx.gbl
> > >> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> > >> >X-Tomcat-NG: microsoft.public.sqlserver.server
> > >> >
> > >> >Considering that the instance name of the SQL is "Commerce" can you
> > >please
> > >> >tell me the exact command to start the SQL server with SQL-DMO.
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> > >> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> > >> >> > Unfortunatly, I am still not sure why you could not open your
> server
> > >> >with
> > >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> > >> detailed
> > >> >> > information about it?
> > >> >>
> > >> >> What kind of detailed information would you like?
> > >> >>
> > >> >> > From your deccriptions, I understood you would like to start SQL
> > >Server
> > >> >> > with SQL-DMO. Have I understood you? If there is anything I
> > >> >misunderstood,
> > >> >> > please feel free to let me know :)
> > >> >> >
> > >> >> It is not that I would like to start SQL Server with SQL-DMO. It
is
> > >that
> > >> >the
> > >> >> application I have starts SQL with SQL-DMO and when the instance
> name
> > >is
> > >> >the
> > >> >> default then everything is fine. The problem starts when the
> instance
> > >> name
> > >> >> is other ther the default ie. COMMERCE.
> > >> >> Is there any possibility that the COMMERCE as an instance name is
> not
> > >an
> > >> >> allowed to use word?
> > >> >>
> > >> >>
> > >> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> > >> message
> > >> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> > >> >> > Hi Yiannis,
> > >> >> >
> > >> >> > Thanks for your updates!
> > >> >> >
> > >> >> > Unfortunatly, I am still not sure why you could not open your
> server
> > >> >with
> > >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> > >> detailed
> > >> >> > information about it?
> > >> >> >
> > >> >> > From your deccriptions, I understood you would like to start SQL
> > >Server
> > >> >> > with SQL-DMO. Have I understood you? If there is anything I
> > >> >misunderstood,
> > >> >> > please feel free to let me know :)
> > >> >> >
> > >> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> > >> >> >
> > >> >> > Start Method (SQLServer)
> > >> >> >
> > >> >>
> > >>
> >
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dm
> > o
> > >> r
> > >> >> > ef_m_s_7vg2.asp
> > >> >> >
> > >> >> > Hope this helps and if you have any questions or concerns, don't
> > >> >hesitate
> > >> >> > to let me know. We are here to be of assistance!
> > >> >> >
> > >> >> > Sincerely yours,
> > >> >> >
> > >> >> > Mingqing Cheng
> > >> >> > Microsoft Online Support
> > >> >> > ---
> > >> >> > Get Secure! - www.microsoft.com/security
> > >> >> > This posting is provided "as is" with no warranties and confers
no
> > >> >rights.
> > >> >> > Please reply to newsgroups only, many thanks!
> > >> >> >
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >> >
> > >>
> > >
> > >
> > >
> >
>|||Hello Yiannis,
Thanks for your patience.
On win98 OS, MSDE runs only as an application and NOT as a Service. With
Net start MSSQL$Commerce you are trying to run the MSDE as a service and it
won't work.
FYI..following are the limitations of MSDE running on Win9x box,
Microsoft Windows® 98 does not provide support for the following features:
Microsoft Windows NT® authentication
-Fiber mode scheduling
-Asynchronous I/O
-Read ahead
-Performance Monitor counters
-Scatter/Gather I/O
-Named pipes server network library
-Appletalk server or client network library
-Banyan Vines server network library
-Runs as application not as service.
So, you might wanna run the MSDE app along with the OS start ( By including
it in the autoexe.bat) or may wanna start it as a seperate application
(just like
any other apps.exe )
Does that answer your question ?
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
<uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
<o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
<uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
<OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl>
<OPvc#AfTEHA.644@.tk2msftngp13.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Thu, 10 Jun 2004 09:54:39 +0300
>Lines: 294
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <#EGtKfrTEHA.3012@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: athei53-b-338.otenet.gr 62.103.183.98
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
and I cannot start the SQL server when the instance name is other than the
default. Can someone tell me what is wrong?Hi Yiannis,
From your descriptions, I understood that you could not start SQL Server's
instance when this instance is not the default one by MSDE. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)
Based on my knowledge, database engine operates as a service or process
that is separate from any application using MSDE 2000. Either MSDE 2000 or
any other version of SQL Server can be running at the same time on the same
computer. Each copy is called an instance. Each instance is installed,
started, stopped, configured, and patched independently of the other
instances.
However, I am not sure your steps about the installation and start-up for
the instance and what error messages could you find Event Log. Would you
please give me detailed descriptions about it, which I believe, will get us
closer to the resolution:) Could you give me a descriptions, with which I
could reproduce it on my machine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Here is how things are. With a setup project I am using all the merge
modules to install the SQL MSDE to the machine. When I configure the server
to use the default instance everything is going fine. When I change the
instance name and I use a named one then when I try to start the server
(same command "start") the server doesn;t start at all. I am trying to start
the server with the command from the instance binn dir "sqlservr -scommerce"
and I cannot start it. When I use the sqlmanagr to start the server it is
starting but the command doesn't start it.
Running machine is an XP Professional version 2002.
From the command prompt the command is going till "SQL Server is ready for
client connections" and never gets to an end.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> From your descriptions, I understood that you could not start SQL Server's
> instance when this instance is not the default one by MSDE. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know:)
> Based on my knowledge, database engine operates as a service or process
> that is separate from any application using MSDE 2000. Either MSDE 2000 or
> any other version of SQL Server can be running at the same time on the
same
> computer. Each copy is called an instance. Each instance is installed,
> started, stopped, configured, and patched independently of the other
> instances.
> However, I am not sure your steps about the installation and start-up for
> the instance and what error messages could you find Event Log. Would you
> please give me detailed descriptions about it, which I believe, will get
us
> closer to the resolution:) Could you give me a descriptions, with which I
> could reproduce it on my machine?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Yiannis,
Thanks for you update!
However, I am still not sure about the root cause of this issue, Would you
please help me collection more detailed information? More detailed
information, I believe, will get us closer to the resolutions :)
First of all, could you start MSSQL Services by means of Control Panel ->
Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
Services by running Command "net start mssqlserver" (without quotation
marks)?
Secondly, could you see some error logs when you are starting up the SQL
Server? Error Number will be the most helpful ones for us to
troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
about the startup and post it here?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer?
Yes I can.
Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
The server is doesn't start. When I press Enter a dialog opens and closes
but I don';t have a chance to see anything.
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
>
Here is the log file.
2004-05-28 16:34:39.69 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )
2004-05-28 16:34:39.72 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-28 16:34:39.73 server All rights reserved.
2004-05-28 16:34:39.74 server Server Process ID is 2680.
2004-05-28 16:34:39.74 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$COMMERCE\LOG\ERRORLOG'.
2004-05-28 16:34:39.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-05-28 16:34:39.82 server SQL Server configured for thread mode
processing.
2004-05-28 16:34:39.84 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-05-28 16:34:39.89 spid3 Starting up database 'master'.
2004-05-28 16:34:40.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-28 16:34:40.29 spid5 Starting up database 'model'.
2004-05-28 16:34:40.34 spid3 Server name is 'MANOSVMXP\COMMERCE'.
2004-05-28 16:34:40.35 spid3 Skipping startup of clean database id 4
2004-05-28 16:34:40.37 server SQL server listening on 192.5.129.70: 1041.
2004-05-28 16:34:40.38 server SQL server listening on 127.0.0.1: 1041.
2004-05-28 16:34:40.58 spid5 Clearing tempdb database.
2004-05-28 16:34:41.41 spid5 Starting up database 'tempdb'.
2004-05-28 16:34:41.76 spid3 Recovery complete.
2004-05-28 16:34:41.77 spid3 SQL global counter collection task is
created.
2004-05-28 16:34:42.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-05-28 16:34:42.69 server SQL Server is ready for client connections
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for you update!
> However, I am still not sure about the root cause of this issue, Would you
> please help me collection more detailed information? More detailed
> information, I believe, will get us closer to the resolutions :)
> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Yiannis,
Thanks for your updates!
Since you could start MSSQL Services, could you tell me what's the command
in "Path to executable"? (You could find Path to executeable in Control
Panel -> Services -> Right Click MSSQLServer\InstanceName)
Secondly, try to find what's the result of command "net start
mssqlserver\InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
Finally, it seems OK with your Log files. Would you please tell me when if
hangs in "SQL Server is ready for client connections", Could you login the
server? If not, what's the error message and error number you will get?
Anyway, Would you please show me why do you like to startup
MSSQLServer\InstanceName with command? Maybe it will be easier for us
finding a workaround:)
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
MSSQL. "Commerce" is the instance name.
Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
System error 123 has occured.
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
it is hanging the command from a dos prompt and then I am trying from the
services by right clicking to start and I get an error (message actually)
which says "The MSSQL$COMMERCE service on Local Computer started and then
stopped. Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround:)
>
I am using InstallShield to install an application to the target machine. I
have configured the merge modules of the SQL Server 2k with sp3 to install
and everything is working fine if I use the default instance name. Sinse
other software manufacturers are using the default instance name there is a
problem installing all software in one machine. So I thought that changing
the instance name of my app would solve this problem and I could have my app
running with a different instance name. There is where the problem started
and I cannot start the SQL server with this instance name. From my code I am
usinf the command to start the SQL.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
> Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround:)
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||I am trying to start the SQL with SQL Server object and command start to
start it but since I cannot do it like this I am trying with command line
and this is not working either.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl...
> Since you could start MSSQL Services, could you tell me what's the command
> > in "Path to executable"? (You could find Path to executeable in Control
> > Panel -> Services -> Right Click MSSQLServer\InstanceName)
> The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
> MSSQL. "Commerce" is the instance name.
>
> Secondly, try to find what's the result of command "net start
> > mssqlserver\InstanceName" you could do it in the following ways
> > 1. Strat -> Run -> typing "cmd" , without quatation marks
> > 2. "net start mssqlserver\InstanceName"
> System error 123 has occured.
>
> > Finally, it seems OK with your Log files. Would you please tell me when
if
> > hangs in "SQL Server is ready for client connections", Could you login
the
> > server? If not, what's the error message and error number you will get?
> it is hanging the command from a dos prompt and then I am trying from the
> services by right clicking to start and I get an error (message actually)
> which says "The MSSQL$COMMERCE service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> > Anyway, Would you please show me why do you like to startup
> > MSSQLServer\InstanceName with command? Maybe it will be easier for us
> > finding a workaround:)
> >
> I am using InstallShield to install an application to the target machine.
I
> have configured the merge modules of the SQL Server 2k with sp3 to install
> and everything is working fine if I use the default instance name. Sinse
> other software manufacturers are using the default instance name there is
a
> problem installing all software in one machine. So I thought that changing
> the instance name of my app would solve this problem and I could have my
app
> running with a different instance name. There is where the problem started
> and I cannot start the SQL server with this instance name. From my code I
am
> usinf the command to start the SQL.
>
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> > Hi Yiannis,
> >
> > Thanks for your updates!
> >
> > Since you could start MSSQL Services, could you tell me what's the
command
> > in "Path to executable"? (You could find Path to executeable in Control
> > Panel -> Services -> Right Click MSSQLServer\InstanceName)
> >
> > Secondly, try to find what's the result of command "net start
> > mssqlserver\InstanceName" you could do it in the following ways
> > 1. Strat -> Run -> typing "cmd" , without quatation marks
> > 2. "net start mssqlserver\InstanceName"
> >
> > Finally, it seems OK with your Log files. Would you please tell me when
if
> > hangs in "SQL Server is ready for client connections", Could you login
the
> > server? If not, what's the error message and error number you will get?
> >
> > Anyway, Would you please show me why do you like to startup
> > MSSQLServer\InstanceName with command? Maybe it will be easier for us
> > finding a workaround:)
> >
> > Sincerely yours,
> >
> > Mingqing Cheng
> > Microsoft Online Support
> > ---
> > Get Secure! - www.microsoft.com/security
> > This posting is provided "as is" with no warranties and confers no
rights.
> > Please reply to newsgroups only, many thanks!
> >
>|||Hi Yiannis,
Oops, It's an type that you shoud use $ instead of \
try to find what's the result of command "net start
mssqlserver$InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
What's the result of it? Could you start SQL Server successfully?
If you could, will this satisfy your requirements?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
I did it and I get an error "The service name is invalid"
I was looking at my previous post and I realize that it doesn;t make sense
what I wrote. The way I am trying to start SQL is with the Server object
from SQL-DMO. Since I cannot do it like this I am trying to start the server
with the command line.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> What's the result of it? Could you start SQL Server successfully?
> If you could, will this satisfy your requirements?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Yiannis,
Thanks for your updates!
Unfortunatly, I am still not sure why you could not open your server with
"net start mssqlserver$COMMERCE". Would you please show me some detailed
information about it?
From your deccriptions, I understood you would like to start SQL Server
with SQL-DMO. Have I understood you? If there is anything I misunderstood,
please feel free to let me know :)
Based on my knowledge, SQL-DMO have Start method to do the job
Start Method (SQLServer)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
ef_m_s_7vg2.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||> Unfortunatly, I am still not sure why you could not open your server with
> "net start mssqlserver$COMMERCE". Would you please show me some detailed
> information about it?
What kind of detailed information would you like?
> From your deccriptions, I understood you would like to start SQL Server
> with SQL-DMO. Have I understood you? If there is anything I misunderstood,
> please feel free to let me know :)
>
It is not that I would like to start SQL Server with SQL-DMO. It is that the
application I have starts SQL with SQL-DMO and when the instance name is the
default then everything is fine. The problem starts when the instance name
is other ther the default ie. COMMERCE.
Is there any possibility that the COMMERCE as an instance name is not an
allowed to use word?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Unfortunatly, I am still not sure why you could not open your server with
> "net start mssqlserver$COMMERCE". Would you please show me some detailed
> information about it?
> From your deccriptions, I understood you would like to start SQL Server
> with SQL-DMO. Have I understood you? If there is anything I misunderstood,
> please feel free to let me know :)
> Based on my knowledge, SQL-DMO have Start method to do the job
> Start Method (SQLServer)
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> ef_m_s_7vg2.asp
> Hope this helps and if you have any questions or concerns, don't hesitate
> to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> ---
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Considering that the instance name of the SQL is "Commerce" can you please
tell me the exact command to start the SQL server with SQL-DMO.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> > Unfortunatly, I am still not sure why you could not open your server
with
> > "net start mssqlserver$COMMERCE". Would you please show me some detailed
> > information about it?
> What kind of detailed information would you like?
> > From your deccriptions, I understood you would like to start SQL Server
> > with SQL-DMO. Have I understood you? If there is anything I
misunderstood,
> > please feel free to let me know :)
> >
> It is not that I would like to start SQL Server with SQL-DMO. It is that
the
> application I have starts SQL with SQL-DMO and when the instance name is
the
> default then everything is fine. The problem starts when the instance name
> is other ther the default ie. COMMERCE.
> Is there any possibility that the COMMERCE as an instance name is not an
> allowed to use word?
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> > Hi Yiannis,
> >
> > Thanks for your updates!
> >
> > Unfortunatly, I am still not sure why you could not open your server
with
> > "net start mssqlserver$COMMERCE". Would you please show me some detailed
> > information about it?
> >
> > From your deccriptions, I understood you would like to start SQL Server
> > with SQL-DMO. Have I understood you? If there is anything I
misunderstood,
> > please feel free to let me know :)
> >
> > Based on my knowledge, SQL-DMO have Start method to do the job
> >
> > Start Method (SQLServer)
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> > ef_m_s_7vg2.asp
> >
> > Hope this helps and if you have any questions or concerns, don't
hesitate
> > to let me know. We are here to be of assistance!
> >
> > Sincerely yours,
> >
> > Mingqing Cheng
> > Microsoft Online Support
> > ---
> > Get Secure! - www.microsoft.com/security
> > This posting is provided "as is" with no warranties and confers no
rights.
> > Please reply to newsgroups only, many thanks!
> >
>|||Hi Yiannis,
We are looking for somebody who is familar with SQL DMO and will reply him with more information as soon as possible. Thanks very much.
Best regards,
Yanhong Huang
Microsoft Community Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Yiannis,
Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
information.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
ef_con01_5qup.asp?frame=true
SQL-DMO Syntax to start SQL server is ,
--Syntax
object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
Also, the SQL Server Service name of the instance can be accessed as
"MSSQL$<instance name>"
Here is a sample code snippet using C++ to start the sqlserver instace of
name "Commerce",
HRESULT hr;
LPSQLDMOSERVER pSQLServer;
WCHAR* szServiceName = L"MSSQL$Commerce";
BOOL fConnect=0;
WCHAR* szLogin= L"Login";
WCHAR* szPassword = L"pswd";
hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
if (SUCCEEDED(hr))
pSQLServer->SetName (szServiceName);
pSQLServer->Start(fConnect,szLogin,szPassword);
pSQLServer->Release();
Please let me know if this resolves the problem, else feel free to post
further questions,
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Sat, 5 Jun 2004 13:58:01 +0300
>Lines: 73
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 62.103.238.182
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Considering that the instance name of the SQL is "Commerce" can you please
>tell me the exact command to start the SQL server with SQL-DMO.
>
>
>"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
>news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
>> > Unfortunatly, I am still not sure why you could not open your server
>with
>> > "net start mssqlserver$COMMERCE". Would you please show me some
detailed
>> > information about it?
>> What kind of detailed information would you like?
>> > From your deccriptions, I understood you would like to start SQL Server
>> > with SQL-DMO. Have I understood you? If there is anything I
>misunderstood,
>> > please feel free to let me know :)
>> >
>> It is not that I would like to start SQL Server with SQL-DMO. It is that
>the
>> application I have starts SQL with SQL-DMO and when the instance name is
>the
>> default then everything is fine. The problem starts when the instance
name
>> is other ther the default ie. COMMERCE.
>> Is there any possibility that the COMMERCE as an instance name is not an
>> allowed to use word?
>>
>> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
message
>> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
>> > Hi Yiannis,
>> >
>> > Thanks for your updates!
>> >
>> > Unfortunatly, I am still not sure why you could not open your server
>with
>> > "net start mssqlserver$COMMERCE". Would you please show me some
detailed
>> > information about it?
>> >
>> > From your deccriptions, I understood you would like to start SQL Server
>> > with SQL-DMO. Have I understood you? If there is anything I
>misunderstood,
>> > please feel free to let me know :)
>> >
>> > Based on my knowledge, SQL-DMO have Start method to do the job
>> >
>> > Start Method (SQLServer)
>> >
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
r
>> > ef_m_s_7vg2.asp
>> >
>> > Hope this helps and if you have any questions or concerns, don't
>hesitate
>> > to let me know. We are here to be of assistance!
>> >
>> > Sincerely yours,
>> >
>> > Mingqing Cheng
>> > Microsoft Online Support
>> > ---
>> > Get Secure! - www.microsoft.com/security
>> > This posting is provided "as is" with no warranties and confers no
>rights.
>> > Please reply to newsgroups only, many thanks!
>> >
>>
>
>|||> pSQLServer->Start(fConnect,szLogin,szPassword);
You are missing one parameter which is the server (2nd parameter).
"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in message
news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> Hello Yiannis,
> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> information.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> ef_con01_5qup.asp?frame=true
>
> SQL-DMO Syntax to start SQL server is ,
> --Syntax
> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> Also, the SQL Server Service name of the instance can be accessed as
> "MSSQL$<instance name>"
> Here is a sample code snippet using C++ to start the sqlserver instace of
> name "Commerce",
> HRESULT hr;
> LPSQLDMOSERVER pSQLServer;
> WCHAR* szServiceName = L"MSSQL$Commerce";
> BOOL fConnect=0;
> WCHAR* szLogin= L"Login";
> WCHAR* szPassword = L"pswd";
> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
> if (SUCCEEDED(hr))
> pSQLServer->SetName (szServiceName);
> pSQLServer->Start(fConnect,szLogin,szPassword);
> pSQLServer->Release();
> Please let me know if this resolves the problem, else feel free to post
> further questions,
> Thanks for using MSDN Managed Newsgroup.
> Vikrant Dalwale
> Microsoft SQL Server Support Professional
>
> Microsoft highly recommends to all of our customers that they visit the
> http://www.microsoft.com/protect site and perform the three
straightforward
> steps listed to improve your computer?s security.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> >Subject: Re: Cnot start SQL Server 2000sp3
> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> >Lines: 73
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 62.103.238.182
> >Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
> phx.gbl
> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >Considering that the instance name of the SQL is "Commerce" can you
please
> >tell me the exact command to start the SQL server with SQL-DMO.
> >
> >
> >
> >
> >
> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> >> > Unfortunatly, I am still not sure why you could not open your server
> >with
> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> detailed
> >> > information about it?
> >>
> >> What kind of detailed information would you like?
> >>
> >> > From your deccriptions, I understood you would like to start SQL
Server
> >> > with SQL-DMO. Have I understood you? If there is anything I
> >misunderstood,
> >> > please feel free to let me know :)
> >> >
> >> It is not that I would like to start SQL Server with SQL-DMO. It is
that
> >the
> >> application I have starts SQL with SQL-DMO and when the instance name
is
> >the
> >> default then everything is fine. The problem starts when the instance
> name
> >> is other ther the default ie. COMMERCE.
> >> Is there any possibility that the COMMERCE as an instance name is not
an
> >> allowed to use word?
> >>
> >>
> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> message
> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> >> > Hi Yiannis,
> >> >
> >> > Thanks for your updates!
> >> >
> >> > Unfortunatly, I am still not sure why you could not open your server
> >with
> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> detailed
> >> > information about it?
> >> >
> >> > From your deccriptions, I understood you would like to start SQL
Server
> >> > with SQL-DMO. Have I understood you? If there is anything I
> >misunderstood,
> >> > please feel free to let me know :)
> >> >
> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> >> >
> >> > Start Method (SQLServer)
> >> >
> >>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> r
> >> > ef_m_s_7vg2.asp
> >> >
> >> > Hope this helps and if you have any questions or concerns, don't
> >hesitate
> >> > to let me know. We are here to be of assistance!
> >> >
> >> > Sincerely yours,
> >> >
> >> > Mingqing Cheng
> >> > Microsoft Online Support
> >> > ---
> >> > Get Secure! - www.microsoft.com/security
> >> > This posting is provided "as is" with no warranties and confers no
> >rights.
> >> > Please reply to newsgroups only, many thanks!
> >> >
> >>
> >>
> >
> >
> >
>|||Hello Yiannis,
Server Paramter is one of the 'optional' parameters. Since I set the
Service Name in
pSQLServer->SetName (szServiceName); I didn't use the Server Param.
Does that answer your question ?
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
<uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
<o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Tue, 8 Jun 2004 22:40:15 +0300
>Lines: 186
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 62.103.183.221
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09|||I have been trying to find an example (like the one you gave me) how I can
start an SQL server using SQL-DMO and I couldn't find anywhere.
I am not saying the MSDN but an example.
Thanks a lot for your help
"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in message
news:OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl...
>
> Hello Yiannis,
> Server Paramter is one of the 'optional' parameters. Since I set the
> Service Name in
> pSQLServer->SetName (szServiceName); I didn't use the Server Param.
> Does that answer your question ?
> Thanks for using MSDN Managed Newsgroup.
> Vikrant Dalwale
> Microsoft SQL Server Support Professional
>
> Microsoft highly recommends to all of our customers that they visit the
> http://www.microsoft.com/protect site and perform the three
straightforward
> steps listed to improve your computer?s security.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> <o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
> >Subject: Re: Cnot start SQL Server 2000sp3
> >Date: Tue, 8 Jun 2004 22:40:15 +0300
> >Lines: 186
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 62.103.183.221
> >Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> phx.gbl
> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344998
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >> pSQLServer->Start(fConnect,szLogin,szPassword);
> >
> >
> >You are missing one parameter which is the server (2nd parameter).
> >
> >
> >
> >
> >"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
message
> >news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> >>
> >> Hello Yiannis,
> >>
> >> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> >> information.
> >>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> r
> >> ef_con01_5qup.asp?frame=true
> >>
> >>
> >> SQL-DMO Syntax to start SQL server is ,
> >>
> >> --Syntax
> >> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> >>
> >> Also, the SQL Server Service name of the instance can be accessed as
> >> "MSSQL$<instance name>"
> >>
> >> Here is a sample code snippet using C++ to start the sqlserver instace
> of
> >> name "Commerce",
> >>
> >> HRESULT hr;
> >> LPSQLDMOSERVER pSQLServer;
> >> WCHAR* szServiceName = L"MSSQL$Commerce";
> >> BOOL fConnect=0;
> >> WCHAR* szLogin= L"Login";
> >> WCHAR* szPassword = L"pswd";
> >>
> >> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> >> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
> >>
> >> if (SUCCEEDED(hr))
> >> pSQLServer->SetName (szServiceName);
> >> pSQLServer->Start(fConnect,szLogin,szPassword);
> >>
> >> pSQLServer->Release();
> >>
> >> Please let me know if this resolves the problem, else feel free to post
> >> further questions,
> >>
> >> Thanks for using MSDN Managed Newsgroup.
> >>
> >> Vikrant Dalwale
> >>
> >> Microsoft SQL Server Support Professional
> >>
> >>
> >> Microsoft highly recommends to all of our customers that they visit
the
> >> http://www.microsoft.com/protect site and perform the three
> >straightforward
> >> steps listed to improve your computer?s security.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >rights.
> >>
> >>
> >>
> >> --
> >> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> >> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> >> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> >> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> >> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> >> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> >> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> >> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> >> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> >> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> >> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> >> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> >> >Subject: Re: Cnot start SQL Server 2000sp3
> >> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> >> >Lines: 73
> >> >X-Priority: 3
> >> >X-MSMail-Priority: Normal
> >> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> >> >Newsgroups: microsoft.public.sqlserver.server
> >> >NNTP-Posting-Host: 62.103.238.182
> >> >Path:
> >>
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> 1
> >> phx.gbl
> >> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> >> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >> >
> >> >Considering that the instance name of the SQL is "Commerce" can you
> >please
> >> >tell me the exact command to start the SQL server with SQL-DMO.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> >> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> >> >> > Unfortunatly, I am still not sure why you could not open your
server
> >> >with
> >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> >> detailed
> >> >> > information about it?
> >> >>
> >> >> What kind of detailed information would you like?
> >> >>
> >> >> > From your deccriptions, I understood you would like to start SQL
> >Server
> >> >> > with SQL-DMO. Have I understood you? If there is anything I
> >> >misunderstood,
> >> >> > please feel free to let me know :)
> >> >> >
> >> >> It is not that I would like to start SQL Server with SQL-DMO. It is
> >that
> >> >the
> >> >> application I have starts SQL with SQL-DMO and when the instance
name
> >is
> >> >the
> >> >> default then everything is fine. The problem starts when the
instance
> >> name
> >> >> is other ther the default ie. COMMERCE.
> >> >> Is there any possibility that the COMMERCE as an instance name is
not
> >an
> >> >> allowed to use word?
> >> >>
> >> >>
> >> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> >> message
> >> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> >> >> > Hi Yiannis,
> >> >> >
> >> >> > Thanks for your updates!
> >> >> >
> >> >> > Unfortunatly, I am still not sure why you could not open your
server
> >> >with
> >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> >> detailed
> >> >> > information about it?
> >> >> >
> >> >> > From your deccriptions, I understood you would like to start SQL
> >Server
> >> >> > with SQL-DMO. Have I understood you? If there is anything I
> >> >misunderstood,
> >> >> > please feel free to let me know :)
> >> >> >
> >> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> >> >> >
> >> >> > Start Method (SQLServer)
> >> >> >
> >> >>
> >>
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dm
> o
> >> r
> >> >> > ef_m_s_7vg2.asp
> >> >> >
> >> >> > Hope this helps and if you have any questions or concerns, don't
> >> >hesitate
> >> >> > to let me know. We are here to be of assistance!
> >> >> >
> >> >> > Sincerely yours,
> >> >> >
> >> >> > Mingqing Cheng
> >> >> > Microsoft Online Support
> >> >> > ---
> >> >> > Get Secure! - www.microsoft.com/security
> >> >> > This posting is provided "as is" with no warranties and confers no
> >> >rights.
> >> >> > Please reply to newsgroups only, many thanks!
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >
> >
> >
>|||I tried the command and I cannot make it work. I still have a problem
starting SQL. By the way I found a solution on an XP machine to start it by
the "net start MSSQL$COMMERCE". The problem now is on Windows 98. What
should I do?
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:OPvc#AfTEHA.644@.tk2msftngp13.phx.gbl...
> I have been trying to find an example (like the one you gave me) how I can
> start an SQL server using SQL-DMO and I couldn't find anywhere.
> I am not saying the MSDN but an example.
> Thanks a lot for your help
>
> "Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
message
> news:OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl...
> >
> >
> > Hello Yiannis,
> >
> > Server Paramter is one of the 'optional' parameters. Since I set the
> > Service Name in
> > pSQLServer->SetName (szServiceName); I didn't use the Server Param.
> >
> > Does that answer your question ?
> >
> > Thanks for using MSDN Managed Newsgroup.
> >
> > Vikrant Dalwale
> >
> > Microsoft SQL Server Support Professional
> >
> >
> > Microsoft highly recommends to all of our customers that they visit the
> > http://www.microsoft.com/protect site and perform the three
> straightforward
> > steps listed to improve your computer?s security.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > --
> > >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> > >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> > <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> > <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> > <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> > <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> > <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> > <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> > <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> > <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> > <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> > <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> > <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> > <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> > <o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
> > >Subject: Re: Cnot start SQL Server 2000sp3
> > >Date: Tue, 8 Jun 2004 22:40:15 +0300
> > >Lines: 186
> > >X-Priority: 3
> > >X-MSMail-Priority: Normal
> > >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> > >Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
> > >Newsgroups: microsoft.public.sqlserver.server
> > >NNTP-Posting-Host: 62.103.183.221
> > >Path:
> >
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> > phx.gbl
> > >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344998
> > >X-Tomcat-NG: microsoft.public.sqlserver.server
> > >
> > >> pSQLServer->Start(fConnect,szLogin,szPassword);
> > >
> > >
> > >You are missing one parameter which is the server (2nd parameter).
> > >
> > >
> > >
> > >
> > >"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
> message
> > >news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> > >>
> > >> Hello Yiannis,
> > >>
> > >> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> > >> information.
> > >>
> >
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> > r
> > >> ef_con01_5qup.asp?frame=true
> > >>
> > >>
> > >> SQL-DMO Syntax to start SQL server is ,
> > >>
> > >> --Syntax
> > >> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> > >>
> > >> Also, the SQL Server Service name of the instance can be accessed as
> > >> "MSSQL$<instance name>"
> > >>
> > >> Here is a sample code snippet using C++ to start the sqlserver
instace
> > of
> > >> name "Commerce",
> > >>
> > >> HRESULT hr;
> > >> LPSQLDMOSERVER pSQLServer;
> > >> WCHAR* szServiceName = L"MSSQL$Commerce";
> > >> BOOL fConnect=0;
> > >> WCHAR* szLogin= L"Login";
> > >> WCHAR* szPassword = L"pswd";
> > >>
> > >> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> > >> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**)
&pSQLServer);
> > >>
> > >> if (SUCCEEDED(hr))
> > >> pSQLServer->SetName (szServiceName);
> > >> pSQLServer->Start(fConnect,szLogin,szPassword);
> > >>
> > >> pSQLServer->Release();
> > >>
> > >> Please let me know if this resolves the problem, else feel free to
post
> > >> further questions,
> > >>
> > >> Thanks for using MSDN Managed Newsgroup.
> > >>
> > >> Vikrant Dalwale
> > >>
> > >> Microsoft SQL Server Support Professional
> > >>
> > >>
> > >> Microsoft highly recommends to all of our customers that they visit
> the
> > >> http://www.microsoft.com/protect site and perform the three
> > >straightforward
> > >> steps listed to improve your computer?s security.
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >rights.
> > >>
> > >>
> > >>
> > >> --
> > >> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> > >> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> > >> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> > >> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> > >> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> > >> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> > >> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> > >> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> > >> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> > >> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> > >> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> > >> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> > >> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> > >> >Subject: Re: Cnot start SQL Server 2000sp3
> > >> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> > >> >Lines: 73
> > >> >X-Priority: 3
> > >> >X-MSMail-Priority: Normal
> > >> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> > >> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> > >> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> > >> >Newsgroups: microsoft.public.sqlserver.server
> > >> >NNTP-Posting-Host: 62.103.238.182
> > >> >Path:
> > >>
> >
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> > 1
> > >> phx.gbl
> > >> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> > >> >X-Tomcat-NG: microsoft.public.sqlserver.server
> > >> >
> > >> >Considering that the instance name of the SQL is "Commerce" can you
> > >please
> > >> >tell me the exact command to start the SQL server with SQL-DMO.
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> > >> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> > >> >> > Unfortunatly, I am still not sure why you could not open your
> server
> > >> >with
> > >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> > >> detailed
> > >> >> > information about it?
> > >> >>
> > >> >> What kind of detailed information would you like?
> > >> >>
> > >> >> > From your deccriptions, I understood you would like to start SQL
> > >Server
> > >> >> > with SQL-DMO. Have I understood you? If there is anything I
> > >> >misunderstood,
> > >> >> > please feel free to let me know :)
> > >> >> >
> > >> >> It is not that I would like to start SQL Server with SQL-DMO. It
is
> > >that
> > >> >the
> > >> >> application I have starts SQL with SQL-DMO and when the instance
> name
> > >is
> > >> >the
> > >> >> default then everything is fine. The problem starts when the
> instance
> > >> name
> > >> >> is other ther the default ie. COMMERCE.
> > >> >> Is there any possibility that the COMMERCE as an instance name is
> not
> > >an
> > >> >> allowed to use word?
> > >> >>
> > >> >>
> > >> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> > >> message
> > >> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> > >> >> > Hi Yiannis,
> > >> >> >
> > >> >> > Thanks for your updates!
> > >> >> >
> > >> >> > Unfortunatly, I am still not sure why you could not open your
> server
> > >> >with
> > >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> > >> detailed
> > >> >> > information about it?
> > >> >> >
> > >> >> > From your deccriptions, I understood you would like to start SQL
> > >Server
> > >> >> > with SQL-DMO. Have I understood you? If there is anything I
> > >> >misunderstood,
> > >> >> > please feel free to let me know :)
> > >> >> >
> > >> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> > >> >> >
> > >> >> > Start Method (SQLServer)
> > >> >> >
> > >> >>
> > >>
> >
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dm
> > o
> > >> r
> > >> >> > ef_m_s_7vg2.asp
> > >> >> >
> > >> >> > Hope this helps and if you have any questions or concerns, don't
> > >> >hesitate
> > >> >> > to let me know. We are here to be of assistance!
> > >> >> >
> > >> >> > Sincerely yours,
> > >> >> >
> > >> >> > Mingqing Cheng
> > >> >> > Microsoft Online Support
> > >> >> > ---
> > >> >> > Get Secure! - www.microsoft.com/security
> > >> >> > This posting is provided "as is" with no warranties and confers
no
> > >> >rights.
> > >> >> > Please reply to newsgroups only, many thanks!
> > >> >> >
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >> >
> > >>
> > >
> > >
> > >
> >
>|||Hello Yiannis,
Thanks for your patience.
On win98 OS, MSDE runs only as an application and NOT as a Service. With
Net start MSSQL$Commerce you are trying to run the MSDE as a service and it
won't work.
FYI..following are the limitations of MSDE running on Win9x box,
Microsoft Windows® 98 does not provide support for the following features:
Microsoft Windows NT® authentication
-Fiber mode scheduling
-Asynchronous I/O
-Read ahead
-Performance Monitor counters
-Scatter/Gather I/O
-Named pipes server network library
-Appletalk server or client network library
-Banyan Vines server network library
-Runs as application not as service.
So, you might wanna run the MSDE app along with the OS start ( By including
it in the autoexe.bat) or may wanna start it as a seperate application
(just like
any other apps.exe )
Does that answer your question ?
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
<uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
<o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
<uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
<OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl>
<OPvc#AfTEHA.644@.tk2msftngp13.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Thu, 10 Jun 2004 09:54:39 +0300
>Lines: 294
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <#EGtKfrTEHA.3012@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: athei53-b-338.otenet.gr 62.103.183.98
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
Subscribe to:
Posts (Atom)