Hi
We are currently migrating from MSSQL 2000 enterprice to MSSQL 2005
Enterprice, and with that doing a revision of our users.
We would like to be able to do a restore a backup of Production to test.
We would like user privileges on the servers to differ so a given user can
execute some stored procedures on one environment but not the other. Say, we
don’t want a service in test with the wrong connection string to be have
access to production.
We have previously done this by using local user groups on the servers, but
we loose the mapping between the Login name and the user name when we do the
restores.
Any ideas or best practices?
Best regards
MikaelMikael
> We would like to be able to do a restore a backup of Production to test.
No problem, just RESTORE command
> We would like user privileges on the servers to differ so a given user can
> execute some stored procedures on one environment but not the other. Say,
> we
> dont want a service in test with the wrong connection string to be have
> access to production.
MS has introduced in SS2005 lots of new features, like SCHEMA for example.
I'd suggets you to spend a hew days to study it
> We have previously done this by using local user groups on the servers,
> but
> we loose the mapping between the Login name and the user name when we do
> the
> restores.
http://blogs.msdn.com/lcris/archive.../03/567680.aspx
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:48261D3D-86AC-4B6F-8B0A-380101564866@.microsoft.com...
> Hi
> We are currently migrating from MSSQL 2000 enterprice to MSSQL 2005
> Enterprice, and with that doing a revision of our users.
> We would like to be able to do a restore a backup of Production to test.
> We would like user privileges on the servers to differ so a given user can
> execute some stored procedures on one environment but not the other. Say,
> we
> dont want a service in test with the wrong connection string to be have
> access to production.
> We have previously done this by using local user groups on the servers,
> but
> we loose the mapping between the Login name and the user name when we do
> the
> restores.
> Any ideas or best practices?
>
> --
> Best regards
> Mikael
Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts
Thursday, March 29, 2012
Enumerating SQL Server database tables rows and sprocs using MFC
Hi,
I've been looking around for a while now after an efficient way to enumerate
tables, rows and sprocs of a MsSQL database. The best I could come up with
was SQL DMO, but one cannot have it installed without installing SQL Server
itself or MSDE, so I'm looking for alternative.
After a table name was fetched, I will need to know the rows it contains,
what type they are, and what are the indexes and identity defined for this
table. Effectively, if I could somehow get the CREATE SQL statement from the
DB itself that would be ideal. Also, I will need a way to get the sprocs
code from the DB, and all that without having any prequisites on either
sides - client and server.
I'm using VC++ with MFC. No managed C++ or .NET, unless I can use the
algorythm in an unmanaged enviroment.
Any links, articles, replies and sample code would be highly appreciated.
Thanks in advance,
Stilgar.Stilgar wrote:
> Hi,
> I've been looking around for a while now after an efficient way to enumera
te
> tables, rows and sprocs of a MsSQL database. The best I could come up with
> was SQL DMO, but one cannot have it installed without installing SQL Serve
r
> itself or MSDE, so I'm looking for alternative.
> After a table name was fetched, I will need to know the rows it contains,
> what type they are, and what are the indexes and identity defined for this
> table. Effectively, if I could somehow get the CREATE SQL statement from t
he
> DB itself that would be ideal. Also, I will need a way to get the sprocs
> code from the DB, and all that without having any prequisites on either
> sides - client and server.
> I'm using VC++ with MFC. No managed C++ or .NET, unless I can use the
> algorythm in an unmanaged enviroment.
> Any links, articles, replies and sample code would be highly appreciated.
> Thanks in advance,
> Stilgar.
To connect to the database you'll normally need an ODBC or OLEDB driver
and the usual way to get that is to install the client connectivity
from the SQL Server disc or install MDAC from microsoft.com (unless you
plan to write your own ODBC/OLEDB client).
The metadata is available in the ADO object model or through TSQL
commands that return a recordset. SQL Server provides the Information
Schema views for that purpose and you can read about them in Books
Online.
David Portas
SQL Server MVP
--|||Will DESCRIBE <tablename> work on MsSql?
For each row simply do SELECT * FROM <table>
- MR
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:%23RANlXE7FHA.3876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I've been looking around for a while now after an efficient way to
> enumerate tables, rows and sprocs of a MsSQL database.|||DESCRIBE <tablename> doesn't seem to work with MsSQL. I've executed it and
it errored.
How can I get the field types using SELECT *? Not to mention indexes and
determine what is the identity field?
Stilgar.
"Mark Randall" <markyr@.gmail.com> wrote in message
news:%23oLYohE7FHA.3588@.TK2MSFTNGP15.phx.gbl...
> Will DESCRIBE <tablename> work on MsSql?
> For each row simply do SELECT * FROM <table>
> - MR
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:%23RANlXE7FHA.3876@.TK2MSFTNGP09.phx.gbl...
>|||I'm using ODBC. Can you shortlist the main TSQL commands? I couldn't find
them myself, as I don't know what to look for exactly here.
How can MDAC help here?
Stilgar.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1132322428.645339.183190@.g44g2000cwa.googlegroups.com...
> Stilgar wrote:
> To connect to the database you'll normally need an ODBC or OLEDB driver
> and the usual way to get that is to install the client connectivity
> from the SQL Server disc or install MDAC from microsoft.com (unless you
> plan to write your own ODBC/OLEDB client).
> The metadata is available in the ADO object model or through TSQL
> commands that return a recordset. SQL Server provides the Information
> Schema views for that purpose and you can read about them in Books
> Online.
> --
> David Portas
> SQL Server MVP
> --
>|||http://msdn.microsoft.com/library/d...r />
_9sfo.asp
Click 'Up One Level' and there you go ... I tried to give you that direct
link but ...
-Mark
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:%231s$CpE7FHA.476@.TK2MSFTNGP15.phx.gbl...
> I'm using ODBC. Can you shortlist the main TSQL commands? I couldn't find
> them myself, as I don't know what to look for exactly here.
> How can MDAC help here?
> Stilgar.
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1132322428.645339.183190@.g44g2000cwa.googlegroups.com...
>|||Hello Stilgar,
Take a look at the GetSchema() method using the most recent SqlClient bit
drops. BobB has good article about them at [0], but that's framed in ADO.NET
terms. I believe you can use the same patterns in C++/MFC, however. Just
harder :)
[0] http://msdn.microsoft.com/library/d...net2schemas.asp
Long live the fighters!
Kent Tegels
DevelopMentor|||I got an even better one - EXEC sp_tables, sp_columns <table>,
sp_stored_procedures.
Thanks for your help.
Stilgar.
"Mark Nijhof" <Mark@.Nijhof.com> wrote in message
news:urPdcHF7FHA.1184@.TK2MSFTNGP12.phx.gbl...
> http://msdn.microsoft.com/library/d.../>
es_9sfo.asp
> Click 'Up One Level' and there you go ... I tried to give you that direct
> link but ...
> -Mark
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:%231s$CpE7FHA.476@.TK2MSFTNGP15.phx.gbl...
>|||...And I have an even better Idea;
go to
http://dev.mysql.com/downloads/
and download the MySQL++, this makes connecting from VC++ to a MySQL
database really easy, no ODBC, or any other connectors, straight to the
MySQL database.
John
The_Code_Master@.hotmail.com
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:eg$xYBU7FHA.2036@.TK2MSFTNGP14.phx.gbl...
> I got an even better one - EXEC sp_tables, sp_columns <table>,
> sp_stored_procedures.
> Thanks for your help.
> Stilgar.
> "Mark Nijhof" <Mark@.Nijhof.com> wrote in message
> news:urPdcHF7FHA.1184@.TK2MSFTNGP12.phx.gbl...
http://msdn.microsoft.com/library/d...-us/tsqlref/ts_
sa-ses_9sfo.asp
direct
find
message
either
driver
you
>|||Sure, only problem is I asked about MS SQL Server, not MySQL. Thanks, but
I'm already familiar with it.
Stilgar.
"The Code Master" <The_Code_Master@.hotmail.com> wrote in message
news:BPOff.21604$tV6.12458@.newssvr27.news.prodigy.net...
> ...And I have an even better Idea;
> go to
> http://dev.mysql.com/downloads/
> and download the MySQL++, this makes connecting from VC++ to a MySQL
> database really easy, no ODBC, or any other connectors, straight to the
> MySQL database.
> John
> The_Code_Master@.hotmail.com
>
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:eg$xYBU7FHA.2036@.TK2MSFTNGP14.phx.gbl...
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_[/ur
l]
> sa-ses_9sfo.asp
> direct
> find
> message
> either
> driver
> you
>
I've been looking around for a while now after an efficient way to enumerate
tables, rows and sprocs of a MsSQL database. The best I could come up with
was SQL DMO, but one cannot have it installed without installing SQL Server
itself or MSDE, so I'm looking for alternative.
After a table name was fetched, I will need to know the rows it contains,
what type they are, and what are the indexes and identity defined for this
table. Effectively, if I could somehow get the CREATE SQL statement from the
DB itself that would be ideal. Also, I will need a way to get the sprocs
code from the DB, and all that without having any prequisites on either
sides - client and server.
I'm using VC++ with MFC. No managed C++ or .NET, unless I can use the
algorythm in an unmanaged enviroment.
Any links, articles, replies and sample code would be highly appreciated.
Thanks in advance,
Stilgar.Stilgar wrote:
> Hi,
> I've been looking around for a while now after an efficient way to enumera
te
> tables, rows and sprocs of a MsSQL database. The best I could come up with
> was SQL DMO, but one cannot have it installed without installing SQL Serve
r
> itself or MSDE, so I'm looking for alternative.
> After a table name was fetched, I will need to know the rows it contains,
> what type they are, and what are the indexes and identity defined for this
> table. Effectively, if I could somehow get the CREATE SQL statement from t
he
> DB itself that would be ideal. Also, I will need a way to get the sprocs
> code from the DB, and all that without having any prequisites on either
> sides - client and server.
> I'm using VC++ with MFC. No managed C++ or .NET, unless I can use the
> algorythm in an unmanaged enviroment.
> Any links, articles, replies and sample code would be highly appreciated.
> Thanks in advance,
> Stilgar.
To connect to the database you'll normally need an ODBC or OLEDB driver
and the usual way to get that is to install the client connectivity
from the SQL Server disc or install MDAC from microsoft.com (unless you
plan to write your own ODBC/OLEDB client).
The metadata is available in the ADO object model or through TSQL
commands that return a recordset. SQL Server provides the Information
Schema views for that purpose and you can read about them in Books
Online.
David Portas
SQL Server MVP
--|||Will DESCRIBE <tablename> work on MsSql?
For each row simply do SELECT * FROM <table>
- MR
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:%23RANlXE7FHA.3876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I've been looking around for a while now after an efficient way to
> enumerate tables, rows and sprocs of a MsSQL database.|||DESCRIBE <tablename> doesn't seem to work with MsSQL. I've executed it and
it errored.
How can I get the field types using SELECT *? Not to mention indexes and
determine what is the identity field?
Stilgar.
"Mark Randall" <markyr@.gmail.com> wrote in message
news:%23oLYohE7FHA.3588@.TK2MSFTNGP15.phx.gbl...
> Will DESCRIBE <tablename> work on MsSql?
> For each row simply do SELECT * FROM <table>
> - MR
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:%23RANlXE7FHA.3876@.TK2MSFTNGP09.phx.gbl...
>|||I'm using ODBC. Can you shortlist the main TSQL commands? I couldn't find
them myself, as I don't know what to look for exactly here.
How can MDAC help here?
Stilgar.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1132322428.645339.183190@.g44g2000cwa.googlegroups.com...
> Stilgar wrote:
> To connect to the database you'll normally need an ODBC or OLEDB driver
> and the usual way to get that is to install the client connectivity
> from the SQL Server disc or install MDAC from microsoft.com (unless you
> plan to write your own ODBC/OLEDB client).
> The metadata is available in the ADO object model or through TSQL
> commands that return a recordset. SQL Server provides the Information
> Schema views for that purpose and you can read about them in Books
> Online.
> --
> David Portas
> SQL Server MVP
> --
>|||http://msdn.microsoft.com/library/d...r />
_9sfo.asp
Click 'Up One Level' and there you go ... I tried to give you that direct
link but ...
-Mark
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:%231s$CpE7FHA.476@.TK2MSFTNGP15.phx.gbl...
> I'm using ODBC. Can you shortlist the main TSQL commands? I couldn't find
> them myself, as I don't know what to look for exactly here.
> How can MDAC help here?
> Stilgar.
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1132322428.645339.183190@.g44g2000cwa.googlegroups.com...
>|||Hello Stilgar,
Take a look at the GetSchema() method using the most recent SqlClient bit
drops. BobB has good article about them at [0], but that's framed in ADO.NET
terms. I believe you can use the same patterns in C++/MFC, however. Just
harder :)
[0] http://msdn.microsoft.com/library/d...net2schemas.asp
Long live the fighters!
Kent Tegels
DevelopMentor|||I got an even better one - EXEC sp_tables, sp_columns <table>,
sp_stored_procedures.
Thanks for your help.
Stilgar.
"Mark Nijhof" <Mark@.Nijhof.com> wrote in message
news:urPdcHF7FHA.1184@.TK2MSFTNGP12.phx.gbl...
> http://msdn.microsoft.com/library/d.../>
es_9sfo.asp
> Click 'Up One Level' and there you go ... I tried to give you that direct
> link but ...
> -Mark
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:%231s$CpE7FHA.476@.TK2MSFTNGP15.phx.gbl...
>|||...And I have an even better Idea;
go to
http://dev.mysql.com/downloads/
and download the MySQL++, this makes connecting from VC++ to a MySQL
database really easy, no ODBC, or any other connectors, straight to the
MySQL database.
John
The_Code_Master@.hotmail.com
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:eg$xYBU7FHA.2036@.TK2MSFTNGP14.phx.gbl...
> I got an even better one - EXEC sp_tables, sp_columns <table>,
> sp_stored_procedures.
> Thanks for your help.
> Stilgar.
> "Mark Nijhof" <Mark@.Nijhof.com> wrote in message
> news:urPdcHF7FHA.1184@.TK2MSFTNGP12.phx.gbl...
http://msdn.microsoft.com/library/d...-us/tsqlref/ts_
sa-ses_9sfo.asp
direct
find
message
either
driver
you
>|||Sure, only problem is I asked about MS SQL Server, not MySQL. Thanks, but
I'm already familiar with it.
Stilgar.
"The Code Master" <The_Code_Master@.hotmail.com> wrote in message
news:BPOff.21604$tV6.12458@.newssvr27.news.prodigy.net...
> ...And I have an even better Idea;
> go to
> http://dev.mysql.com/downloads/
> and download the MySQL++, this makes connecting from VC++ to a MySQL
> database really easy, no ODBC, or any other connectors, straight to the
> MySQL database.
> John
> The_Code_Master@.hotmail.com
>
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:eg$xYBU7FHA.2036@.TK2MSFTNGP14.phx.gbl...
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_[/ur
l]
> sa-ses_9sfo.asp
> direct
> find
> message
> either
> driver
> you
>
Monday, March 19, 2012
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
Friday, March 9, 2012
enterprise manager login to local server
I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
Steve
Whats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
Steve
Whats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.
enterprise manager login to local server
I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.
enterprise manager login to local server
I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.
Enterprise manager has gone KAPUT!
Hello There,
We have an issue at our company where none of our computers can connect into one of our MSSQL databases. The DB engine is MSSQL 2000(ver 8).
We were able to access this DB through Enterprise Manager last week, but all of a sudden, nobody can interface with the DB anymore. My techy-admin guy doesn't know what happened. We've tried many other programs which are like Enterprise manager, but nothing can connect to this DB. Fortunately, our websites that use this DB can still talk to it fine.
So, does anyone know of anything that might be causing this? I know the information is vague, but thats all I have to work with. We don't have a clue what happened to our Enterprise Manager access to our DB.
Thanks for your suggestions,
Andres G.
We have an issue at our company where none of our computers can connect into one of our MSSQL databases. The DB engine is MSSQL 2000(ver 8).
We were able to access this DB through Enterprise Manager last week, but all of a sudden, nobody can interface with the DB anymore. My techy-admin guy doesn't know what happened. We've tried many other programs which are like Enterprise manager, but nothing can connect to this DB. Fortunately, our websites that use this DB can still talk to it fine.
So, does anyone know of anything that might be causing this? I know the information is vague, but thats all I have to work with. We don't have a clue what happened to our Enterprise Manager access to our DB.
Thanks for your suggestions,
Andres G.
To save your data please remove the last backup .bak file to a different server and install SQL Server in another box to see if you can register this server. If you cannot then you may have to run setup and take the repair option this is where the last backup being moved to another server is important, if the repair damage your database you can recreate the database with the.bak file through the backup and restore wizard in Enterprise manager by choosing the restore from device option. There are third party tools you can test drive. Hope this helps.
Sunday, February 19, 2012
enterprise manager alignment problem
Hi,
After I installed SP3 for MSSQL 2000, the display in the enterprise manager
is not as before. There is an alignment problem of right to left.
For example when displaying all rows of a table, the rows of the datagarid
are aligned
to the right instead to the left.
How can I fix it?
--
Ohad Young
Medical Informatics Research Center
Ben Gurion University
Information System Eng
Office Phone: 972-8-6477160
Cellular Phone: 972-54-518301
E-Mail: ohadyn@.bgumail.bgu.ac.ilHi Sue,
Yes, the locale (in the regional settings) are set to English(United
States).
It was OK before I installed SP3. It only started after SP3 was installed.
Ohad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
> I've seen this once or twice before with different regional
> settings. Is your locale set to English(United States) ? If
> not, try setting to that and see if the alignment goes back
> to what you expected.
> -Sue
> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
> <ohadyn@.bgumail.bgu.ac.il> wrote:
> >Hi,
> >After I installed SP3 for MSSQL 2000, the display in the enterprise
manager
> >is not as before. There is an alignment problem of right to left.
> >For example when displaying all rows of a table, the rows of the
datagarid
> >are aligned
> >to the right instead to the left.
> >
> >How can I fix it?
>|||I'm out of ideas - I've only seen it with the locale issue.
I'd check that the same SPs were applied to server and
clients. I'd check MDAC configuration/versions as well.
Maybe someone else has some ideas on whatever else could be
going on.
-Sue
On Tue, 26 Aug 2003 20:41:40 +0200, "Ohad Young"
<ohadyn@.bgumail.bgu.ac.il> wrote:
>Hi Sue,
>Yes, the locale (in the regional settings) are set to English(United
>States).
>It was OK before I installed SP3. It only started after SP3 was installed.
>Ohad
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
>> I've seen this once or twice before with different regional
>> settings. Is your locale set to English(United States) ? If
>> not, try setting to that and see if the alignment goes back
>> to what you expected.
>> -Sue
>> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
>> <ohadyn@.bgumail.bgu.ac.il> wrote:
>> >Hi,
>> >After I installed SP3 for MSSQL 2000, the display in the enterprise
>manager
>> >is not as before. There is an alignment problem of right to left.
>> >For example when displaying all rows of a table, the rows of the
>datagarid
>> >are aligned
>> >to the right instead to the left.
>> >
>> >How can I fix it?
>|||Hi Ohad,
This problem is strange. Do you mean the SQL Enterprise Manager and SQL
Server are installed on the same machine? Does this problem occur on the
other computer? Maybe you could try to reinstall the SQL Server Enterprise
Manager, and then check to see if the problem occurs again. For more
information regarding installing the SQL Server Enterprise Manager, please
refer to the article below:
This step-by-step guide describes how to install a SQL Server 2000 basic
local installation.
303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
http://support.microsoft.com/?id=303747
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
I have the same alignment problem with EM sp3 on both WinXP and Win2K.
When the locale is set to Hebrew, the EM screens (layout and data) are
aligned to the right.
Changing the locale to English fixes the problem on both platforms.
I must use hebrew as my locale, otherwise outlook and other apps
display hebrew text as gibberish...
Ofer
v-yshao@.online.microsoft.com (Michael Shao [MSFT]) wrote in message news:<YevPw1JbDHA.2116@.cpmsftngxa06.phx.gbl>...
> Hi Ohad,
> This problem is strange. Do you mean the SQL Enterprise Manager and SQL
> Server are installed on the same machine? Does this problem occur on the
> other computer? Maybe you could try to reinstall the SQL Server Enterprise
> Manager, and then check to see if the problem occurs again. For more
> information regarding installing the SQL Server Enterprise Manager, please
> refer to the article below:
> This step-by-step guide describes how to install a SQL Server 2000 basic
> local installation.
> 303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
> http://support.microsoft.com/?id=303747
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.|||Hello Ohad,
My name is Venu Cherukupalli and I will be the
support engineer working with you on this issue. I have sent an EMail to
you regarding the action plan but I did not get any response. As per that
Email, the action plan is
1) Send me a screenshot of the Enterprise Manager which is posing problems.
2) Using Access, try to create a Linked Table to a SQL Server and see if
you notice the same problem in the designer.
Let me know if you have any questions or concerns.
Thanks
Venu Cherukupalli
Microsoft SQL Server Support
After I installed SP3 for MSSQL 2000, the display in the enterprise manager
is not as before. There is an alignment problem of right to left.
For example when displaying all rows of a table, the rows of the datagarid
are aligned
to the right instead to the left.
How can I fix it?
--
Ohad Young
Medical Informatics Research Center
Ben Gurion University
Information System Eng
Office Phone: 972-8-6477160
Cellular Phone: 972-54-518301
E-Mail: ohadyn@.bgumail.bgu.ac.ilHi Sue,
Yes, the locale (in the regional settings) are set to English(United
States).
It was OK before I installed SP3. It only started after SP3 was installed.
Ohad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
> I've seen this once or twice before with different regional
> settings. Is your locale set to English(United States) ? If
> not, try setting to that and see if the alignment goes back
> to what you expected.
> -Sue
> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
> <ohadyn@.bgumail.bgu.ac.il> wrote:
> >Hi,
> >After I installed SP3 for MSSQL 2000, the display in the enterprise
manager
> >is not as before. There is an alignment problem of right to left.
> >For example when displaying all rows of a table, the rows of the
datagarid
> >are aligned
> >to the right instead to the left.
> >
> >How can I fix it?
>|||I'm out of ideas - I've only seen it with the locale issue.
I'd check that the same SPs were applied to server and
clients. I'd check MDAC configuration/versions as well.
Maybe someone else has some ideas on whatever else could be
going on.
-Sue
On Tue, 26 Aug 2003 20:41:40 +0200, "Ohad Young"
<ohadyn@.bgumail.bgu.ac.il> wrote:
>Hi Sue,
>Yes, the locale (in the regional settings) are set to English(United
>States).
>It was OK before I installed SP3. It only started after SP3 was installed.
>Ohad
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
>> I've seen this once or twice before with different regional
>> settings. Is your locale set to English(United States) ? If
>> not, try setting to that and see if the alignment goes back
>> to what you expected.
>> -Sue
>> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
>> <ohadyn@.bgumail.bgu.ac.il> wrote:
>> >Hi,
>> >After I installed SP3 for MSSQL 2000, the display in the enterprise
>manager
>> >is not as before. There is an alignment problem of right to left.
>> >For example when displaying all rows of a table, the rows of the
>datagarid
>> >are aligned
>> >to the right instead to the left.
>> >
>> >How can I fix it?
>|||Hi Ohad,
This problem is strange. Do you mean the SQL Enterprise Manager and SQL
Server are installed on the same machine? Does this problem occur on the
other computer? Maybe you could try to reinstall the SQL Server Enterprise
Manager, and then check to see if the problem occurs again. For more
information regarding installing the SQL Server Enterprise Manager, please
refer to the article below:
This step-by-step guide describes how to install a SQL Server 2000 basic
local installation.
303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
http://support.microsoft.com/?id=303747
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
I have the same alignment problem with EM sp3 on both WinXP and Win2K.
When the locale is set to Hebrew, the EM screens (layout and data) are
aligned to the right.
Changing the locale to English fixes the problem on both platforms.
I must use hebrew as my locale, otherwise outlook and other apps
display hebrew text as gibberish...
Ofer
v-yshao@.online.microsoft.com (Michael Shao [MSFT]) wrote in message news:<YevPw1JbDHA.2116@.cpmsftngxa06.phx.gbl>...
> Hi Ohad,
> This problem is strange. Do you mean the SQL Enterprise Manager and SQL
> Server are installed on the same machine? Does this problem occur on the
> other computer? Maybe you could try to reinstall the SQL Server Enterprise
> Manager, and then check to see if the problem occurs again. For more
> information regarding installing the SQL Server Enterprise Manager, please
> refer to the article below:
> This step-by-step guide describes how to install a SQL Server 2000 basic
> local installation.
> 303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
> http://support.microsoft.com/?id=303747
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.|||Hello Ohad,
My name is Venu Cherukupalli and I will be the
support engineer working with you on this issue. I have sent an EMail to
you regarding the action plan but I did not get any response. As per that
Email, the action plan is
1) Send me a screenshot of the Enterprise Manager which is posing problems.
2) Using Access, try to create a Linked Table to a SQL Server and see if
you notice the same problem in the designer.
Let me know if you have any questions or concerns.
Thanks
Venu Cherukupalli
Microsoft SQL Server Support
Enterprise Manager 2000?
Hi all... I'm a total novice to MSSQL.
My web host says I need a copy of Enterprise Manager 2000 to access a MSSQL
DB they have set up on my site.
After looking at the MS site and various product literature... I am TOTALLY
confused.
What must I buy... the most minimum thing... to get a copy of Enterprise Ma
nager 2000. OR - is this anthing that is available for download anywhere?
Obviously, I'm not RUNNING SQL, I just need to manage a database that my web
host is running on their server.
Thanks in advance...
TimThis is quite a common question so I trying to find a "legally correct"
answer. However, in the mean time you could use this
SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tmilo" <webmaster@.emailmover.com> wrote in message
news:397DCFF7-CD92-4478-9585-C3C3DEA07573@.microsoft.com...
> Hi all... I'm a total novice to MSSQL.
> My web host says I need a copy of Enterprise Manager 2000 to access a
MSSQL DB they have set up on my site.
> After looking at the MS site and various product literature... I am
TOTALLY confused.
> What must I buy... the most minimum thing... to get a copy of Enterprise
Manager 2000. OR - is this anthing that is available for download
anywhere?
> Obviously, I'm not RUNNING SQL, I just need to manage a database that my
web host is running on their server.
> Thanks in advance...
> Tim|||Thanks for the link, but.... unless I'm mistaken, the web solution you poi
nted me to is another server installed MS product. I'm not on a dedicated s
erver, so I cannot install additional software on it. So, I guess I'm stil
l where I started, and that
is what I must buy, at a minumum, to get a copy of Enterprise Manager. Or,
perhaps someone knows of an equivalent (and hopefully cheap) product?|||Hi,
Jasper pointed you to a correct link. To be more detailed
MS Web Data administrator acts similar to Enterprise
manager with reasonable functionalities. You dont need to
Install this on the Database Server(ISP).
The supported OS for running this tool are Windows XP and
Windows 2000 Server which has IIS . What else u r looking
for? Just Install this on your machine and you can manage
remote databases on a fly.
I am afraid you cannot use Enterprise manager until you
are a owner of a copy of SQL Server
Developer /standard/Personal/Enterpsise Editions.
Regards
Thirumal
>--Original Message--
>Thanks for the link, but.... unless I'm mistaken, the
web solution you pointed me to is another server installed
MS product. I'm not on a dedicated server, so I cannot
install additional software on it. So, I guess I'm still
where I started, and that is what I must buy, at a
minumum, to get a copy of Enterprise Manager. Or,
perhaps someone knows of an equivalent (and hopefully
cheap) product?
>
>.
>|||Developer Edition you can get for $49, and it includes a database engine as
well. I'm pretty sure you will be allowed to use that EM against your SQL
Server, but you'd want to check to be certain.
Also, on my web-site, the links section, you find URL's to a number of other
management tools, some free.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tmilo" <webmaster@.emailmover.com> wrote in message
news:2CC334F4-E3E7-446D-9D94-469F4318DAD2@.microsoft.com...
> Thanks for the link, but.... unless I'm mistaken, the web solution you
pointed me to is another server installed MS product. I'm not on a
dedicated server, so I cannot install additional software on it. So, I
guess I'm still where I started, and that is what I must buy, at a minumum,
to get a copy of Enterprise Manager. Or, perhaps someone knows of an
equivalent (and hopefully cheap) product?
>
>|||> I'm pretty sure you will be allowed to use that EM against your SQL
> Server, but you'd want to check to be certain.
I was told that my claim above is incorrect. I'm trying to hunt down some
documentation or link about it and will post back if I find such.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ejiBpMmDEHA.3016@.TK2MSFTNGP11.phx.gbl...
> Developer Edition you can get for $49, and it includes a database engine
as
> well. I'm pretty sure you will be allowed to use that EM against your SQL
> Server, but you'd want to check to be certain.
> Also, on my web-site, the links section, you find URL's to a number of
other
> management tools, some free.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tmilo" <webmaster@.emailmover.com> wrote in message
> news:2CC334F4-E3E7-446D-9D94-469F4318DAD2@.microsoft.com...
> pointed me to is another server installed MS product. I'm not on a
> dedicated server, so I cannot install additional software on it. So, I
> guess I'm still where I started, and that is what I must buy, at a
minumum,
> to get a copy of Enterprise Manager. Or, perhaps someone knows of an
> equivalent (and hopefully cheap) product?
>|||Thanks all... I bought a copy of MSSQL Developer's version today. It sho
uld fit my needs nicely.
Appreciate the feedback!|||My MVP lead found such a reference for me. A below URL:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
There's a Q:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
In the answer, there's this section:
"Note: The tools and services included with SQL Server Developer Edition may
not be used to manage production server environments."
This is pretty clear on the subject. I have requested from MS to provide
some FAQ or URL which discusses this scenario explicitly. If such will
appear, I don't know, or how long it would take...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OYM3DGpDEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I was told that my claim above is incorrect. I'm trying to hunt down some
> documentation or link about it and will post back if I find such.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ejiBpMmDEHA.3016@.TK2MSFTNGP11.phx.gbl...
> as
SQL
> other
you
> minumum,
>
My web host says I need a copy of Enterprise Manager 2000 to access a MSSQL
DB they have set up on my site.
After looking at the MS site and various product literature... I am TOTALLY
confused.
What must I buy... the most minimum thing... to get a copy of Enterprise Ma
nager 2000. OR - is this anthing that is available for download anywhere?
Obviously, I'm not RUNNING SQL, I just need to manage a database that my web
host is running on their server.
Thanks in advance...
TimThis is quite a common question so I trying to find a "legally correct"
answer. However, in the mean time you could use this
SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tmilo" <webmaster@.emailmover.com> wrote in message
news:397DCFF7-CD92-4478-9585-C3C3DEA07573@.microsoft.com...
> Hi all... I'm a total novice to MSSQL.
> My web host says I need a copy of Enterprise Manager 2000 to access a
MSSQL DB they have set up on my site.
> After looking at the MS site and various product literature... I am
TOTALLY confused.
> What must I buy... the most minimum thing... to get a copy of Enterprise
Manager 2000. OR - is this anthing that is available for download
anywhere?
> Obviously, I'm not RUNNING SQL, I just need to manage a database that my
web host is running on their server.
> Thanks in advance...
> Tim|||Thanks for the link, but.... unless I'm mistaken, the web solution you poi
nted me to is another server installed MS product. I'm not on a dedicated s
erver, so I cannot install additional software on it. So, I guess I'm stil
l where I started, and that
is what I must buy, at a minumum, to get a copy of Enterprise Manager. Or,
perhaps someone knows of an equivalent (and hopefully cheap) product?|||Hi,
Jasper pointed you to a correct link. To be more detailed
MS Web Data administrator acts similar to Enterprise
manager with reasonable functionalities. You dont need to
Install this on the Database Server(ISP).
The supported OS for running this tool are Windows XP and
Windows 2000 Server which has IIS . What else u r looking
for? Just Install this on your machine and you can manage
remote databases on a fly.
I am afraid you cannot use Enterprise manager until you
are a owner of a copy of SQL Server
Developer /standard/Personal/Enterpsise Editions.
Regards
Thirumal
>--Original Message--
>Thanks for the link, but.... unless I'm mistaken, the
web solution you pointed me to is another server installed
MS product. I'm not on a dedicated server, so I cannot
install additional software on it. So, I guess I'm still
where I started, and that is what I must buy, at a
minumum, to get a copy of Enterprise Manager. Or,
perhaps someone knows of an equivalent (and hopefully
cheap) product?
>
>.
>|||Developer Edition you can get for $49, and it includes a database engine as
well. I'm pretty sure you will be allowed to use that EM against your SQL
Server, but you'd want to check to be certain.
Also, on my web-site, the links section, you find URL's to a number of other
management tools, some free.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tmilo" <webmaster@.emailmover.com> wrote in message
news:2CC334F4-E3E7-446D-9D94-469F4318DAD2@.microsoft.com...
> Thanks for the link, but.... unless I'm mistaken, the web solution you
pointed me to is another server installed MS product. I'm not on a
dedicated server, so I cannot install additional software on it. So, I
guess I'm still where I started, and that is what I must buy, at a minumum,
to get a copy of Enterprise Manager. Or, perhaps someone knows of an
equivalent (and hopefully cheap) product?
>
>|||> I'm pretty sure you will be allowed to use that EM against your SQL
> Server, but you'd want to check to be certain.
I was told that my claim above is incorrect. I'm trying to hunt down some
documentation or link about it and will post back if I find such.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ejiBpMmDEHA.3016@.TK2MSFTNGP11.phx.gbl...
> Developer Edition you can get for $49, and it includes a database engine
as
> well. I'm pretty sure you will be allowed to use that EM against your SQL
> Server, but you'd want to check to be certain.
> Also, on my web-site, the links section, you find URL's to a number of
other
> management tools, some free.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tmilo" <webmaster@.emailmover.com> wrote in message
> news:2CC334F4-E3E7-446D-9D94-469F4318DAD2@.microsoft.com...
> pointed me to is another server installed MS product. I'm not on a
> dedicated server, so I cannot install additional software on it. So, I
> guess I'm still where I started, and that is what I must buy, at a
minumum,
> to get a copy of Enterprise Manager. Or, perhaps someone knows of an
> equivalent (and hopefully cheap) product?
>|||Thanks all... I bought a copy of MSSQL Developer's version today. It sho
uld fit my needs nicely.
Appreciate the feedback!|||My MVP lead found such a reference for me. A below URL:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
There's a Q:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
In the answer, there's this section:
"Note: The tools and services included with SQL Server Developer Edition may
not be used to manage production server environments."
This is pretty clear on the subject. I have requested from MS to provide
some FAQ or URL which discusses this scenario explicitly. If such will
appear, I don't know, or how long it would take...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OYM3DGpDEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I was told that my claim above is incorrect. I'm trying to hunt down some
> documentation or link about it and will post back if I find such.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ejiBpMmDEHA.3016@.TK2MSFTNGP11.phx.gbl...
> as
SQL
> other
you
> minumum,
>
Subscribe to:
Posts (Atom)