December 13, 2007 at 11:51 pm
Hi i manage to successfully transfer data rom a source server to a destination server using DTS but some system tables and system SP's are not copied to the destination server. I cannot manually create this system tables and system SP's because once i do that they will become user tables and user SP's and i dont know if they play a major role in the server once it is back to production. Can someone tell me if this system table and system SP's are "auto created once the server is in production mode? If not how can i transfer this system table/SP's???
System Table
dtproperties
System SP's
dt_addtosourcecontrol
dt_addtosourcecontrol_u
dt_adduserobject
dt_adduserobject_vcs
dt_checkinobject
dt_checkinobject_u
dt_checkoutobject
dt_checkoutobject_u
dt_displayoaerror
dt_displayoaerror_u
dt_droppropertiesbyid
dt_dropuserobjectbyid
dt_generateansiname
dt_getobjwithprop
dt_getobjwithprop_u
dt_getpropertiesbyid
dt_getpropertiesbyid_u
dt_getpropertiesbyid_vcs
dt_getpropertiesbyid_vcs_u
dt_isundersourcecontrol
dt_isundersourcecontrol_u
dt_removefromsourcecontrol
dt_setpropertybyid
dt_setpropertybyid_u
dt_validateloginparams
dt_validateloginparams_u
dt_vcsenabled
dt_verstamp006
dt_verstamp007
dt_whocheckedout
dt_whocheckedout_u
"-=Still Learning=-"
Lester Policarpio
December 14, 2007 at 12:56 am
All these proceures and the dtpropertties table are used to create diagrams in SQL 2000. You can safely ignore them when transferring you're data. If your new server is SQL 2000 they will be (re)created as soon as you click on the Diagrams node under your database in EM.
[font="Verdana"]Markus Bohse[/font]
December 14, 2007 at 2:41 am
(Take A Deep Breath) Thanks MarkusB 😀 I'll be transferring today at 11:00 AM wish me luck 😎
"-=Still Learning=-"
Lester Policarpio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply