Install Error - 'NOLOCK'

I get the following error when installing SQL Server Express SP2 on Windows
XP SP2 with all current updates. The only other thing installed is .NET 2.0.
Does anyone know how to resolve the issue.
[Microsoft][SQL Native Client][SQL Server]Could not continue scan with NOLOCK
due to data movement
Thanks,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-msde/200706/1
jwbutler,
I do not know, but I have would ask: Is your SQL Express engine still
running when you apply SP2?
The error reported is one that SQL Server throws when SELECTing with NOLOCK
and the data is deleted during a narrow window of time, as described here:
http://support.microsoft.com/kb/815008. Could that be happening to you? If
so, shut down SQL Express and try the update.
RLF
"jwbutler via droptable.com" <u16619@.uwe> wrote in message
news:7455d61651947@.uwe...
>I get the following error when installing SQL Server Express SP2 on Windows
> XP SP2 with all current updates. The only other thing installed is .NET
> 2.0.
> Does anyone know how to resolve the issue.
> [Microsoft][SQL Native Client][SQL Server]Could not continue scan with
> NOLOCK
> due to data movement
> Thanks,
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server-msde/200706/1
>
sql

Installation

Hi,
I'm using the most current version of MSDE, I've ran all my updates on a
2000 Pro machine.
Someone else did the install and I'm receiving an error message that SQL is
not installed properly
or has been tampered with, pleas uninstall and reinstall, so I went to the
add/remove and uninstalled
MSDE and reinstalled but I'm still receiving the same error message. I go
to Services to start it and
it won't start.
So that's where I'm at, thanks, Craig
Hi Craig,
Thank you for using Microsoft NewsGroup!
Since the installation issue might be related to many possibilities, please
collect the following information to help my analyze this issue, thank you!
1. Take a screenshot of the error message, and send it to me, my email:
v-warnw@.microsoft.com
Create a screenshot
=================
a) When the message appears in the window, press PrScrn (the key right of
F12).
b) Click start menu->all programs->accessories->paint.
c) Press Ctrl+V to paste the screen shot into the paint, and save the
picture in GIF file type.
2. Collect related MPSREPORT to me.
1). Please go to the following link, and download the MPSRPT SQL.exe.
http://www.microsoft.com/downloads/d...c7c-7ca5-408f-
88b7-f9c79b7306c0&displaylang=en
2). Double click to open this file, click Yes to start to collect the
information.
3). When the tool is done you will see an Explorer Window open up. In the
Explorer window should be a .CAB and a .NFO file that you need to send to
me.
If there is anything unclear, please feel free to let me know. Thank you!
Sincerely,
Warner Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Warner,
It appears that the user had a bad hard drive.
Thanks for your time, Craig
"Warner wang" <v-warnw@.microsoft.com> wrote in message
news:nRchyXgMGHA.128@.TK2MSFTNGXA01.phx.gbl...
> Hi Craig,
> Thank you for using Microsoft NewsGroup!
> Since the installation issue might be related to many possibilities,
> please
> collect the following information to help my analyze this issue, thank
> you!
> 1. Take a screenshot of the error message, and send it to me, my email:
> v-warnw@.microsoft.com
> Create a screenshot
> =================
> a) When the message appears in the window, press PrScrn (the key right of
> F12).
> b) Click start menu->all programs->accessories->paint.
> c) Press Ctrl+V to paste the screen shot into the paint, and save the
> picture in GIF file type.
> 2. Collect related MPSREPORT to me.
> 1). Please go to the following link, and download the MPSRPT SQL.exe.
> http://www.microsoft.com/downloads/d...c7c-7ca5-408f-
> 88b7-f9c79b7306c0&displaylang=en
> 2). Double click to open this file, click Yes to start to collect the
> information.
> 3). When the tool is done you will see an Explorer Window open up. In the
> Explorer window should be a .CAB and a .NFO file that you need to send to
> me.
> If there is anything unclear, please feel free to let me know. Thank you!
> Sincerely,
> Warner Wang
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hi Craig,
I am glad to know you figured this out. If you need my further assistance,
please feel free to let me know by posting to this web. Thank you very much!
Sincerely,
Warner Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

inserting the date into SQL Server problem

Im having problems inserting the current date into SQL server from my ASP.net application.

The error that asp.net throws is:

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. "

In my page, im setting the date as follows:

Dim strDate as Date

strDate = now()

Then in my page I call a function called "do_store"

This works fin putting my variables into my database until I tried adding the date to the statement. Here is my function. Can anyone see my problem?

Public Function do_store(ByVal strTestID As String, ByVal strUserName As String, ByVal strUserID As String, ByVal strWrong As String, ByVal strRight As String, ByVal strAnswers As String, ByVal strDate As Date)
Dim strSQL As String
Dim sConn As String
Dim oConn As SqlConnection
'do the insert into the database
strSQL = "insert into test_results (test_plan_id, user_name, user_id, questions_wrong, questions_right, questions_answered, date_time) values (" & strTestID & ", '" & strUserName & "', " & strUserID & ", " & strWrong & ", " & strRight & ", " & strAnswers & ", '" & strDate & "')"
sConn = ConfigurationSettings.AppSettings("ConnectionString")
oConn = New SqlConnection(sConn)
Dim myCommand As SqlCommand

myCommand = New SqlCommand(strSQL, oConn)
myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
End Function::Im having problems inserting the current date into SQL server from my ASP.net
::application.
::
::The error that asp.net throws is:
::
::"The conversion of a char data type to a datetime data type resulted in an out-of-range
::datetime value. The statement has been terminated. "

* Your datetime formates between the server and your process dont match.

Means: your server expects (for example) YMD, and you deliver YDM. Result: the date gets interpreted as month, and this can result in you "entering" month values from 13-31, which ARE out of range.

You need to make sure that the string you create actually is what the SQL Server expects.

BTW - if this is for a website, your code is insecure and very sucesseptable to a SQL INJECTION ATTACK.

Please read up the fundamental basics of SQL security - do it now.|||How do I check what format SQL Server wants?
how can I format the date so it fits into SQL server?
I got it all running locally (SQL Server and VS.NET) so Presumed their locale setting would be the same.
Im only building this as an intranet so its not open to the big bad world.|||This is explained in the SQL Server oducmentaiton. Actually you should not care - you should ALAWYS insert datetimes as ISO form, country independant. The correct way to insert this is:

return String.Format ("'{0:yyyy-MM-dd HH:mm:ss}'", Value);

At least this is what our EntityBroker O/R mapping framework uses, and it works so far.

The documentation of SQL Server has more information on this.

inserting the current date and time into SQL Server database

I need an SQL string that inserts the current date into a database.

So far I have tried:

SQL = "INSERT INTO X (START_DATE) VALUES('" & Date.Now &"')"

mycomm =

New SqlCommand(sql, myconn)

mycomm.ExecuteNonQuery()

However, there is a problem with the SQL command. The problem is related to the date. Is there a way of programatically inserting the current date/time into the SQL database? Language used is VB.

GetDate() is a function in SQL Server that returns the current timestamp. So you can directly use that.

SQL = "INSERT INTO X (START_DATE) VALUES( GetDate())"