Re: Using the SharePoint 2003 OM, can the Created and Last Modified dates be overridden when a document is added to a doc library?

From: Bil Simser (bil_simser_at_cpr.ca)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 04:22:23 -0700

"Michael Herman (Parallelspace)" <mwherman@parallelspace.net.no#$#spam>
wrote in message news:OkUDHOZ8DHA.2432@TK2MSFTNGP10.phx.gbl...
> Using the SharePoint 2003 OM, can the Created and Last Modified date
> properties for a document be overridden and set a specific value when the
> document is added to a doc library?
>
> If not, presumably the appropriate SQL content database table entries
could
> be directly updated (although not recommended)?

These seem to be properties that are either the internal SQL values or
columns in the database, but the OM doesn't have any access to these fields
except in a read-only manner. While you might be able to manipulate the SQL
data directly I would suggest you just don't as there are too many things
behind the scenes, now or in the future, where that might put you in a world
of hurt and potentially invalidate your entire system. Just because you can
fire up Enterprise Manager and poke around in the db, doesn't mean you
should. There had to be a way to store data somehow and that's the way MS
did it and there's a method to their madness to accessing things via the OM. 

-- 
Bil Simser
Development Evangelist
Canadian Pacific Railway
(403) 319-7987

Relevant Pages

  • Steps for Migrating WSS 3.0 from Windows Internal Database to Microsoft SQL 2005
    ... done the stupid things I did when I started playing with Sharepoint ... when I first installed it and assuming that it would find the SQL 2005 ... Windows Internal Database). ... Reboot the server to finish up any uninstall scripts. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... directly at the SQL 2005 database, ... Document List) must update the database directly with the GMT0 ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Configuring Full Text Search FOr SharePoint Web
    ... My SharePoint database had been upgraded to SQL and the data was being ... You need to make sure that you have upgrade your sharepoint instance to ...
    (microsoft.public.windows.server.sbs)
  • Re: Question about forms and data storage
    ... app that synchs the data from SQL to a list, ... or look at moving the core data into the sharepoint ... list over the database... ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: HELP HELP!! PLEASE - Company web issue
    ... All I know is that when I installed SQL as an "after the fact" process, ... gave me the option to convert my sharepoint. ... > We're starting to get beyond my level of experience with SQL and SBS. ... >>> You receive a "Cannot connect to configuration database" error message ...
    (microsoft.public.windows.server.sbs)