Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lin100
Yak Posting Veteran
70 Posts |
 Posted - 2008-03-23 : 15:29:45
|
| What are these 31 dt Stored Procedures that exist inthe Northwind, NorthwindCS, and Pubs database in SQL 2000 Server ?I look it up in the help file but I can 't find any information about it.1) What is the purpose of each procedure?2) How do you use it ?1) dt_addtosourcecontroldt_addtosourcecontrol_udt_adduserobjectdt_adduserobject_vcsdt_checkinobjectdt_checkinobject_udt_checkoutobjectdt_checkoutobject_udt_displayoaerrordt_displayoaerror_udt_droppropertiesbyiddt_dropuserobjectbyiddt_generateansinamedt_getobjwithpropdt_getobjwithprop_udt_getpropertiesbyiddt_getpropertiesbyid_udt_getpropertiesbyid_vcsdt_getpropertiesbyid_vcs_udt_isundersourcecontroldt_isundersourcecontrol_udt_removefromsourcecontroldt_setpropertybyiddt_setpropertybyid_udt_validateloginparamsdt_validateloginparams_udt_vcsenableddt_verstamp006dt_verstamp007dt_whocheckedout31) dt_whocheckedout_u |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 15:56:26
|
| Those are system sps created when you use visual tools. |
 |
|
|
Lin100
Yak Posting Veteran
70 Posts |
Posted - 2008-03-23 : 16:07:51
|
| Hi rmiao. 1) When you said visual tools do you mean "SQL Server Enterprise Manager" or something else?2) Where can I get information on how to use it ?3) The database msdb is also in SQL 2000 Server, and the 31 dt procedures mentioned above are not there. Why is it so? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 16:49:57
|
| 1. when you create diagram or use dts.2. check books online, and you don't call them usually.3. you maybe not do anything memtioned above in msdb. |
|
|
|
|
|
|
What are these 31 dt Stored Procedures ?