May 10, 2007 at 6:49 pm
hey all,
Today I installed a named instance on my enterprise db server. Idid this cause an application needed me to have case-sensitive SQL server. anyway, installed it and it looks good, db was insalled ok..but I have no stored procedures.....how do I get them back???
Also, I kinda wanna change the name of my named instance, can I do that? Thanks!!!
May 10, 2007 at 7:07 pm
Was the problem in a newly restored database?
In a newly installed database?
Found any errors in the scripts that were ran?
Or maybe some scripts that were not run?
May 10, 2007 at 7:13 pm
only one database was installed and I don't even have the normal SP's ....like for sp_detachdb ....
May 10, 2007 at 7:16 pm
If those are not around, then how come the server be up and running?? Are you sure that the server is running? Are you sure you checked in the Master database for those procs?
May 10, 2007 at 7:20 pm
It's possible your login cannot see them. I'm not sure which sql version you're running; for 2005 try this
use master
go
GRANT VIEW ANY DEFINITION TO login_name;
go
The system procs are under the sys schema;
May 11, 2007 at 7:12 am
i'm logging in as SA, so that wouldn't make sense...
May 11, 2007 at 11:41 am
OK, it appears that the stored procedures are included when looking at entprise manager, but when i'm logged into query analyzer, I don't have them...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply