I have a server that has a few system stored procedures missing, among them
sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
installation of a service pack. This server is going away in a couple of
weeks, but in the meatime, I would like to get put these system stored
procedures back, but have been unsuccessful doing so.
Does any have a suggestion, besides restoring master?
Copy them from another SQL Server. Script them out and execute in the server
where they are missing.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"RogerT" <RogerT@.discussions.microsoft.com> wrote in message
news:2840B89F-C2FF-46D1-ACE3-F48CD2A9CF06@.microsoft.com...
>I have a server that has a few system stored procedures missing, among them
> sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
> installation of a service pack. This server is going away in a couple of
> weeks, but in the meatime, I would like to get put these system stored
> procedures back, but have been unsuccessful doing so.
> Does any have a suggestion, besides restoring master?
|||What did you do to try to get the procedures back? Did you
try reapplying the latest Service Pack? If you had problems
with applying one of the service packs, you'd probably want
to make sure nothing else has been impacted.
-Sue
On Fri, 6 Oct 2006 15:40:02 -0700, RogerT
<RogerT@.discussions.microsoft.com> wrote:
>I have a server that has a few system stored procedures missing, among them
>sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
>installation of a service pack. This server is going away in a couple of
>weeks, but in the meatime, I would like to get put these system stored
>procedures back, but have been unsuccessful doing so.
>Does any have a suggestion, besides restoring master?
Showing posts with label among. Show all posts
Showing posts with label among. Show all posts
Monday, March 12, 2012
Missing System Stored Procedures
I have a server that has a few system stored procedures missing, among them
sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
installation of a service pack. This server is going away in a couple of
weeks, but in the meatime, I would like to get put these system stored
procedures back, but have been unsuccessful doing so.
Does any have a suggestion, besides restoring master?Copy them from another SQL Server. Script them out and execute in the server
where they are missing.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"RogerT" <RogerT@.discussions.microsoft.com> wrote in message
news:2840B89F-C2FF-46D1-ACE3-F48CD2A9CF06@.microsoft.com...
>I have a server that has a few system stored procedures missing, among them
> sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
> installation of a service pack. This server is going away in a couple of
> weeks, but in the meatime, I would like to get put these system stored
> procedures back, but have been unsuccessful doing so.
> Does any have a suggestion, besides restoring master?|||What did you do to try to get the procedures back? Did you
try reapplying the latest Service Pack? If you had problems
with applying one of the service packs, you'd probably want
to make sure nothing else has been impacted.
-Sue
On Fri, 6 Oct 2006 15:40:02 -0700, RogerT
<RogerT@.discussions.microsoft.com> wrote:
>I have a server that has a few system stored procedures missing, among them
>sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
>installation of a service pack. This server is going away in a couple of
>weeks, but in the meatime, I would like to get put these system stored
>procedures back, but have been unsuccessful doing so.
>Does any have a suggestion, besides restoring master?
sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
installation of a service pack. This server is going away in a couple of
weeks, but in the meatime, I would like to get put these system stored
procedures back, but have been unsuccessful doing so.
Does any have a suggestion, besides restoring master?Copy them from another SQL Server. Script them out and execute in the server
where they are missing.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"RogerT" <RogerT@.discussions.microsoft.com> wrote in message
news:2840B89F-C2FF-46D1-ACE3-F48CD2A9CF06@.microsoft.com...
>I have a server that has a few system stored procedures missing, among them
> sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
> installation of a service pack. This server is going away in a couple of
> weeks, but in the meatime, I would like to get put these system stored
> procedures back, but have been unsuccessful doing so.
> Does any have a suggestion, besides restoring master?|||What did you do to try to get the procedures back? Did you
try reapplying the latest Service Pack? If you had problems
with applying one of the service packs, you'd probably want
to make sure nothing else has been impacted.
-Sue
On Fri, 6 Oct 2006 15:40:02 -0700, RogerT
<RogerT@.discussions.microsoft.com> wrote:
>I have a server that has a few system stored procedures missing, among them
>sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
>installation of a service pack. This server is going away in a couple of
>weeks, but in the meatime, I would like to get put these system stored
>procedures back, but have been unsuccessful doing so.
>Does any have a suggestion, besides restoring master?
Missing System Stored Procedures
I have a server that has a few system stored procedures missing, among them
sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
installation of a service pack. This server is going away in a couple of
weeks, but in the meatime, I would like to get put these system stored
procedures back, but have been unsuccessful doing so.
Does any have a suggestion, besides restoring master?Copy them from another SQL Server. Script them out and execute in the server
where they are missing.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"RogerT" <RogerT@.discussions.microsoft.com> wrote in message
news:2840B89F-C2FF-46D1-ACE3-F48CD2A9CF06@.microsoft.com...
>I have a server that has a few system stored procedures missing, among them
> sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
> installation of a service pack. This server is going away in a couple of
> weeks, but in the meatime, I would like to get put these system stored
> procedures back, but have been unsuccessful doing so.
> Does any have a suggestion, besides restoring master?|||What did you do to try to get the procedures back? Did you
try reapplying the latest Service Pack? If you had problems
with applying one of the service packs, you'd probably want
to make sure nothing else has been impacted.
-Sue
On Fri, 6 Oct 2006 15:40:02 -0700, RogerT
<RogerT@.discussions.microsoft.com> wrote:
>I have a server that has a few system stored procedures missing, among them
>sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
>installation of a service pack. This server is going away in a couple of
>weeks, but in the meatime, I would like to get put these system stored
>procedures back, but have been unsuccessful doing so.
>Does any have a suggestion, besides restoring master?
sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
installation of a service pack. This server is going away in a couple of
weeks, but in the meatime, I would like to get put these system stored
procedures back, but have been unsuccessful doing so.
Does any have a suggestion, besides restoring master?Copy them from another SQL Server. Script them out and execute in the server
where they are missing.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"RogerT" <RogerT@.discussions.microsoft.com> wrote in message
news:2840B89F-C2FF-46D1-ACE3-F48CD2A9CF06@.microsoft.com...
>I have a server that has a few system stored procedures missing, among them
> sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
> installation of a service pack. This server is going away in a couple of
> weeks, but in the meatime, I would like to get put these system stored
> procedures back, but have been unsuccessful doing so.
> Does any have a suggestion, besides restoring master?|||What did you do to try to get the procedures back? Did you
try reapplying the latest Service Pack? If you had problems
with applying one of the service packs, you'd probably want
to make sure nothing else has been impacted.
-Sue
On Fri, 6 Oct 2006 15:40:02 -0700, RogerT
<RogerT@.discussions.microsoft.com> wrote:
>I have a server that has a few system stored procedures missing, among them
>sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
>installation of a service pack. This server is going away in a couple of
>weeks, but in the meatime, I would like to get put these system stored
>procedures back, but have been unsuccessful doing so.
>Does any have a suggestion, besides restoring master?
Monday, February 20, 2012
missing Enterprise Manager after installation of MSDE
My MSAccess application uses MSDE. For creating the setup, I use
InstallShield Developer 8, which installs the MSDE. Among the features for
MSDE, included in the redistributables is the Enterprise Manager.
But after executing the setup I cannot find the Enterprise Manager.
I think, I need the Enterprise Manager to connect to the Database to which
my Access application must be connected.
Or does there exist another method, to set up the connection?
Thank for help,
Rudolf
I didnt think MSDE came with Enterprise Manager at all. Including it in release files generated by InstallShield Developer presupposes that it comes with MSDE. Can someone confirm that it Enterprise Manager does come with MSDE (2000 Release A)?
Mark Ferguson
"Rudolf Hennemuth" wrote:
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
>
|||EM does *not* come with MSDE. You get a database without much interface.
jan
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
news:C71FA1B3-2E82-4DF2-9DCB-D9278C18AA63@.microsoft.com...
> I didnt think MSDE came with Enterprise Manager at all. Including it in
release files generated by InstallShield Developer presupposes that it comes
with MSDE. Can someone confirm that it Enterprise Manager does come with
MSDE (2000 Release A)?[vbcol=seagreen]
> --
> Mark Ferguson
>
> "Rudolf Hennemuth" wrote:
for[vbcol=seagreen]
which[vbcol=seagreen]
|||hi,
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> ha scritto nel messaggio
news:u%23sJmh6UEHA.2408@.tk2msftngp13.phx.gbl...
> EM does *not* come with MSDE. You get a database without much interface.
and in addition to Jan answer, including Enterprise Manager component and
related MMC snap-in dependencies in a personal deployment package violates
Microsoft EULA... at least the standard one
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hello,
There is no Entreprise manager for MSDE (even if a SQL Manager from SQL2000
can work with MSDE). It is one of the differences between SQL Server and
MSDE (no graphical tool).
You can use SQL DMO to make a lot of things (create database, restore a
backup...)
Marc Allard
Allcomp
"Rudolf Hennemuth" <Rudolf.Hennemuth@.diese-gmbh.de> a crit dans le message
de news:ufwZBX4UEHA.2816@.TK2MSFTNGP11.phx.gbl...
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
|||There is another way...Microsoft freely distributes a SQl Server Web Data Administrator. See:
http://www.microsoft.com/downloads/d...displaylang=en
Mark Ferguson
"Rudolf Hennemuth" wrote:
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
>
|||Thanks,
this was the best hint, which solve my problem.
Rudolf
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> schrieb im
Newsbeitrag news:20B68A31-4DA9-4281-AE16-40D8DCFFF9CE@.microsoft.com...
> There is another way...Microsoft freely distributes a SQl Server Web Data
Administrator. See:
>
http://www.microsoft.com/downloads/d...displaylang=en[vbcol=seagreen]
> --
> Mark Ferguson
>
> "Rudolf Hennemuth" wrote:
for[vbcol=seagreen]
which[vbcol=seagreen]
InstallShield Developer 8, which installs the MSDE. Among the features for
MSDE, included in the redistributables is the Enterprise Manager.
But after executing the setup I cannot find the Enterprise Manager.
I think, I need the Enterprise Manager to connect to the Database to which
my Access application must be connected.
Or does there exist another method, to set up the connection?
Thank for help,
Rudolf
I didnt think MSDE came with Enterprise Manager at all. Including it in release files generated by InstallShield Developer presupposes that it comes with MSDE. Can someone confirm that it Enterprise Manager does come with MSDE (2000 Release A)?
Mark Ferguson
"Rudolf Hennemuth" wrote:
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
>
|||EM does *not* come with MSDE. You get a database without much interface.
jan
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> wrote in message
news:C71FA1B3-2E82-4DF2-9DCB-D9278C18AA63@.microsoft.com...
> I didnt think MSDE came with Enterprise Manager at all. Including it in
release files generated by InstallShield Developer presupposes that it comes
with MSDE. Can someone confirm that it Enterprise Manager does come with
MSDE (2000 Release A)?[vbcol=seagreen]
> --
> Mark Ferguson
>
> "Rudolf Hennemuth" wrote:
for[vbcol=seagreen]
which[vbcol=seagreen]
|||hi,
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> ha scritto nel messaggio
news:u%23sJmh6UEHA.2408@.tk2msftngp13.phx.gbl...
> EM does *not* come with MSDE. You get a database without much interface.
and in addition to Jan answer, including Enterprise Manager component and
related MMC snap-in dependencies in a personal deployment package violates
Microsoft EULA... at least the standard one
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hello,
There is no Entreprise manager for MSDE (even if a SQL Manager from SQL2000
can work with MSDE). It is one of the differences between SQL Server and
MSDE (no graphical tool).
You can use SQL DMO to make a lot of things (create database, restore a
backup...)
Marc Allard
Allcomp
"Rudolf Hennemuth" <Rudolf.Hennemuth@.diese-gmbh.de> a crit dans le message
de news:ufwZBX4UEHA.2816@.TK2MSFTNGP11.phx.gbl...
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
|||There is another way...Microsoft freely distributes a SQl Server Web Data Administrator. See:
http://www.microsoft.com/downloads/d...displaylang=en
Mark Ferguson
"Rudolf Hennemuth" wrote:
> My MSAccess application uses MSDE. For creating the setup, I use
> InstallShield Developer 8, which installs the MSDE. Among the features for
> MSDE, included in the redistributables is the Enterprise Manager.
> But after executing the setup I cannot find the Enterprise Manager.
> I think, I need the Enterprise Manager to connect to the Database to which
> my Access application must be connected.
> Or does there exist another method, to set up the connection?
> Thank for help,
> Rudolf
>
>
|||Thanks,
this was the best hint, which solve my problem.
Rudolf
"Mark Ferguson" <MarkFerguson@.discussions.microsoft.com> schrieb im
Newsbeitrag news:20B68A31-4DA9-4281-AE16-40D8DCFFF9CE@.microsoft.com...
> There is another way...Microsoft freely distributes a SQl Server Web Data
Administrator. See:
>
http://www.microsoft.com/downloads/d...displaylang=en[vbcol=seagreen]
> --
> Mark Ferguson
>
> "Rudolf Hennemuth" wrote:
for[vbcol=seagreen]
which[vbcol=seagreen]
Subscribe to:
Posts (Atom)