Qry: update person_course datetimestamp = 10/6/1900 12:00:01 AM fails!

I am trying to modify data in a SQL Server database using the query below. But it fails; why??

update person_course datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470

I get
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'datetimestamp'.You need the key word SET

update person_course SET datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470|||Thanks. I saw it after I had sent the message. Aaarrrgh!!! Long day I guess.

Q: restrict other users

Hello,
I need to restrict other users to modify database including network
administrator. I go to permission tab and remove all checks and set
everything for my user but it seem administrator still have ability to modify
it.
How can I get only one user do everything and the rest have only read access?
Thanks,
Jim."JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:ADF936CE-5020-4CE0-A5E9-8C0EE086069C@.microsoft.com...
> Hello,
> I need to restrict other users to modify database including network
> administrator. I go to permission tab and remove all checks and set
> everything for my user but it seem administrator still have ability to
modify
> it.
> How can I get only one user do everything and the rest have only read
access?
> Thanks,
> Jim.
By default the BUILTIN\Administrators group is mapped to the sysadmin fixed
server role. To prevent this, first ensure that your user is mapped to the
sysadmin role, then either delete the admistrators login (stop them logging
in), or remove it from the sysadmin role. If everyone needs read access
then grant the appropriate permissions to the public role.
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004