var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Missing system stored procedures
When I create a new database, the system stored procedures are missing;
I'm logged in as sa.
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
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.
Whatdya know....I gotta script that for often...it's the only thing I don't script
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%)
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
I thought they had more to do with Visual Source Safe then with the DB Diagram feature...