Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Missing system stored procedures

    When I create a new database, the system stored procedures are missing;

    dt_addtosourcecontrol_u
    dt_checkinobject_u
    etc.

    I'm logged in as sa.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Is that the only 2?

    I've never used them before...but the appear in all the databases I've created.

    What version are you using?

    And can you see them in master?
    Last edited by Brett Kaiser; 02-25-05 at 11:23.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Those procedures are magically created by Enterprise Manager, as far as I can tell. Even if you are logged into EM as someone with no create procedure rights. I would not worry over them, unless you have errors. You may need to apply a service pack to the client, at worst.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Whatdya know....I gotta script that for often...it's the only thing I don't script

    Code:
    CREATE DATABASE [myDB99]  
    	ON (NAME = N'myDB99'
    		, FILENAME = N'd:\database\njros1d151dev\MSSQL$NJROS1D151DEV\data\myDB99.mdf' 
    		, SIZE = 209, FILEGROWTH = 10%) 
      LOG   ON (NAME = N'myDB99_log', FILENAME = N'd:\database\njros1d151dev\MSSQL$NJROS1D151DEV\data\myDB99.ldf' 
    		, SIZE = 61
    		, FILEGROWTH = 10%)
     COLLATE SQL_Latin1_General_CP1_CI_AS
    GO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    These procs are created automagically when you use the database diagrams feature in EM. These procedures have something to do with the creation of the diagrams (though i do not exactly know what).

    I would not worry about them ... i have not ever seen anybody use them ... except the Enterprise Manager.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    I thought they had more to do with Visual Source Safe then with the DB Diagram feature...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •