Error 15457

I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?It's not a "real" error, since the severity is 0. It's safe to ignore it.
It's just a PITA.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"john Schuster" <schuster@.llnl.gov> wrote in message
news:2277b01c45d4f$190760d0$a101280a@.phx
.gbl...
I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?

Error 15457

I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?It's not a "real" error, since the severity is 0. It's safe to ignore it.
It's just a PITA.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"john Schuster" <schuster@.llnl.gov> wrote in message
news:2277b01c45d4f$190760d0$a101280a@.phx.gbl...
I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?

Error 15457

I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?
It's not a "real" error, since the severity is 0. It's safe to ignore it.
It's just a PITA.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"john Schuster" <schuster@.llnl.gov> wrote in message
news:2277b01c45d4f$190760d0$a101280a@.phx.gbl...
I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?
|||It's not a "real" error, since the severity is 0. It's safe to ignore it.
It's just a PITA.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"john Schuster" <schuster@.llnl.gov> wrote in message
news:2277b01c45d4f$190760d0$a101280a@.phx.gbl...
I recently set up a maintenance plan using the MS SQL
Maintenance plan wizard. Every thing seems to be working
fine with one exception I keep getting the following error:
"Error 15457, Severity 0, Configuration option '%ls'
changed from %ld to %ld. Run the RECONFIGURE statement to
install"
Does anyone know how to solver this?

Error = Arithmetic overflow error converting expression to data type smalldatetim

$exception {"Arithmetic overflow error converting expression to data type smalldatetime.\r\nThe statement has been terminated."} System.Exception {System.Data.SqlClient.SqlException}

occurs

here is my code

protectedvoid EmailSubmitBtn_Click(object sender,EventArgs e)

{

SqlDataSource NewsletterSqlDataSource =newSqlDataSource();

NewsletterSqlDataSource.ConnectionString =

ConfigurationManager.ConnectionStrings["NewsletterConnectionString"].ToString();

//Text version

NewsletterSqlDataSource.InsertCommandType =

SqlDataSourceCommandType.Text;

NewsletterSqlDataSource.InsertCommand =

"INSERT INTO NewsLetter (EmailAddress, IPAddress, DateTimeStamp) VALUES (@.EmailAddress, @.IPAddress, @.DateTimeStamp)";

//storeprocedure version//NewsletterSqlDataSource.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;//NewsletterSqlDataSource.InsertCommand = "EmailInsert";

NewsletterSqlDataSource.InsertParameters.Add(

"EmailAddress", EmailTb.Text);

NewsletterSqlDataSource.InsertParameters.Add(

"IPAddress", Request.UserHostAddress.ToString());

NewsletterSqlDataSource.InsertParameters.Add(

"DateTimeStamp",DateTime.Now.ToString());int rowsAffected = 0;try

{

rowsAffected = NewsletterSqlDataSource.Insert();

}

catch (Exception ex)

{

Server.Transfer(

"NewsletterProblem.aspx");

}

finally

{

NewsletterSqlDataSource =

null;

}

if (rowsAffected != 1)

{

Server.Transfer(

"NewsletterProblem.aspx");

}

else

{

Server.Transfer(

"NewsletterSuccess.aspx");

}

Do not pass the Value asDateTime.Now.ToString() . Just pass the value asDateTime.Now if the db datatype is smalldatetime. If the input datatype for stored procedure is string , try

DateTime

.Now.ToShortDateString(); . Let me know if you need any clarifications

Error : Timeout expired

I am developing a .NET web application. We are using SQL 2000. I am getting
this Exception message while executing a query.
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."
This query fails when I execute it for the first time. After ttat the query
works most of the times, but I still receive this message sometimes. I am
unable to find out why this occurs.
This is query that is causing the timeout exception
private const string SQL_UNASSIGN_TRAINING = "UPDATE tblAssignedTraining
SET IsWaivedOff = 1 WHERE TrainingId = @.TrainingId AND UserId = @.UserId AND
Status <> 4";
The following is the database design for the tblAssignedTraining table.
Status - Integer (can have value 1, 2, 3 or 4)
TrainingId - Integer
UserId - varchar(50)
IsWaivedOff - Bit
Any help would be highly appreciated.
TIA,
GaryWhen posting table structure, please post DDL (CREATE TABLE statements)
including relevant constraints and indexes.
To prevent a table scan, you'll need an index (or primary key or unique
constraint) on TrainingId and/or UserId. This will help both
performance and concurrency.
You can set the CommandTimeout property of your command object to
override the default (which I believe is 30 seconds). Also, there is a
bug in the .NET Framework 1.0 in which the timeout setting was not
honored under certain conditions. This was corrected in .NET Framework
1.0 SP2 and does not occur with .NET Framework 1.1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Gary" <msnews@.microsoft.com> wrote in message
news:OcOQv6NXDHA.212@.TK2MSFTNGP12.phx.gbl...
> I am developing a .NET web application. We are using SQL 2000. I am
getting
> this Exception message while executing a query.
> "Timeout expired. The timeout period elapsed prior to completion of
the
> operation or the server is not responding."
> This query fails when I execute it for the first time. After ttat the
query
> works most of the times, but I still receive this message sometimes. I
am
> unable to find out why this occurs.
> This is query that is causing the timeout exception
> private const string SQL_UNASSIGN_TRAINING = "UPDATE
tblAssignedTraining
> SET IsWaivedOff = 1 WHERE TrainingId = @.TrainingId AND UserId =@.UserId AND
> Status <> 4";
> The following is the database design for the tblAssignedTraining
table.
> Status - Integer (can have value 1, 2, 3 or 4)
> TrainingId - Integer
> UserId - varchar(50)
> IsWaivedOff - Bit
> Any help would be highly appreciated.
> TIA,
> Gary
>
>|||You should have an index on one of the columns to ensure the query executes
fast...
"Gary" <msnews@.microsoft.com> wrote in message
news:OcOQv6NXDHA.212@.TK2MSFTNGP12.phx.gbl...
> I am developing a .NET web application. We are using SQL 2000. I am
getting
> this Exception message while executing a query.
> "Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding."
> This query fails when I execute it for the first time. After ttat the
query
> works most of the times, but I still receive this message sometimes. I am
> unable to find out why this occurs.
> This is query that is causing the timeout exception
> private const string SQL_UNASSIGN_TRAINING = "UPDATE tblAssignedTraining
> SET IsWaivedOff = 1 WHERE TrainingId = @.TrainingId AND UserId = @.UserId
AND
> Status <> 4";
> The following is the database design for the tblAssignedTraining table.
> Status - Integer (can have value 1, 2, 3 or 4)
> TrainingId - Integer
> UserId - varchar(50)
> IsWaivedOff - Bit
> Any help would be highly appreciated.
> TIA,
> Gary
>
>