Where are my system stored procedures?
-
I create a couple of databases for some testing yesterday and part of my testing is using some of the system stored procedures.
When I tried to run one of the procedures, it failed. When I started troubleshooting, I noticed that my system stored procedures were not there.
I think I have seen something like this in the past where they were not there at first but then they appeared.
Anybody have any ideas?
Thanks,
hawg
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
-
There's a check box in the SQL Server Registration that specifies show system databases and system objects. Check that, but otherwise it may be a permissions issue.
-
Thanks, I checked that box but it was set to allow me to see the system objects. I am the system admin so I can see everything.
The strange thing was, I created a dummy table in the database and when I did, the dtproperties table showed up then the system stored procedures showed up. I don't know why. I am going to have to research that some more.
I don't know if I have ever really looked at a new database before I created any objects. I only did that here because I was just using it for testing and I didn't really need any user objects to start.
Strange!
hawg
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
-
I have experienced similar results when creating a new database. I believe nothing is visible until at least one user object is available. Just so you know you are not alone.
If the phone doesn't ring...It's me.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply