Anyone knows any tutorials on th use of ERWin ?there should be one with the install-cd.
jobi
"Alan" <NOSPAMalanpltse@.yahoo.com.au> wrote in message
news:OEVoAfcoDHA.3256@.tk2msftngp13.phx.gbl...
> Anyone knows any tutorials on th use of ERWin ?
>|||erwin has some serious problems with matching indexes and foreign keys
between the model and the sql2000 db. it sort of works, but it sort of
doesn't. get ready to be aggravated.
the best advice i can give you on the use of erwin is to always
carefully read the script generated by complete compare so that you know
exactly what it's going to do to the db.
even though erwin has some serious glitches in it, i haven't found a
better tool for migrating schema changes from one db to another.
jobi wrote:
> there should be one with the install-cd.
> jobi
> "Alan" <NOSPAMalanpltse@.yahoo.com.au> wrote in message
> news:OEVoAfcoDHA.3256@.tk2msftngp13.phx.gbl...
> > Anyone knows any tutorials on th use of ERWin ?|||As always, you have to use these tools only after you know their soft spots.
Have them script their changes, check that thoroughly.
Evaluate the software before you buy it.
jobi
"chxxx" <chxxx@.dontemailme.com> wrote in message
news:3FA7B3A4.3DD2910@.dontemailme.com...
> erwin has some serious problems with matching indexes and foreign keys
> between the model and the sql2000 db. it sort of works, but it sort of
> doesn't. get ready to be aggravated.
> the best advice i can give you on the use of erwin is to always
> carefully read the script generated by complete compare so that you know
> exactly what it's going to do to the db.
> even though erwin has some serious glitches in it, i haven't found a
> better tool for migrating schema changes from one db to another.
> jobi wrote:
> > there should be one with the install-cd.
> >
> > jobi
> > "Alan" <NOSPAMalanpltse@.yahoo.com.au> wrote in message
> > news:OEVoAfcoDHA.3256@.tk2msftngp13.phx.gbl...
> > > Anyone knows any tutorials on th use of ERWin ?
>
Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts
Wednesday, March 28, 2012
Modelling Time Span with OLAP tools
This is more of a design question. I am trying to create a fact table for ti
me spans. For example an order might go through the following status of Crea
ted, In-Progress, Delivered. The time span between any 2 states could range
from minutes to days to mon
ths. I want to be able to see the current status and also the status as of l
ast month, or last quarter or some other previous date.
Some of the recommendations by extert sites are to have a date in your fact
table for each status accompained by a field
for storing a value 1. So the order fact by look like
Order Id
Order Create Date
Order Created Value
Order In-Progress Date
Order In-Progress Value
Order Delivered Date
Order Delivered Value
Also I am creating my own time dimension. The above approach will work very
well when you use SQLs to access your star schema, but I am not so sure this
approach will work for olap tools like MSAS.
Is there an alternative?
ThanksWhat you have here looks like an accumulating snapshot fact table. These
are best employed IMHO where you have a business process/relatively short
with milestones which you want to track.
It means that you have less rows in your fact table but that you will
revisit the row to perform UPDATEs, something not typically done.
This type of fact table is good for measuring time lags between business
processes i.e.
Time from Order -> Sale
Time from Sale -> Ship
The way I do this is to create a view over the top of the fact table which
calculates these figures for me. This way i can then use it as a measure
just like any other. I usually do it to difference in hours.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Break It" <anonymous@.discussions.microsoft.com> wrote in message
news:13CB4DFA-500D-4268-B850-5EE207F917CD@.microsoft.com...
> This is more of a design question. I am trying to create a fact table for
time spans. For example an order might go through the following status of
Created, In-Progress, Delivered. The time span between any 2 states could
range from minutes to days to months. I want to be able to see the current
status and also the status as of last month, or last quarter or some other
previous date.
> Some of the recommendations by extert sites are to have a date in your
fact table for each status accompained by a field
> for storing a value 1. So the order fact by look like
> Order Id
> Order Create Date
> Order Created Value
> Order In-Progress Date
> Order In-Progress Value
> Order Delivered Date
> Order Delivered Value
> Also I am creating my own time dimension. The above approach will work
very well when you use SQLs to access your star schema, but I am not so sure
this approach will work for olap tools like MSAS.
> Is there an alternative?
> Thanks
me spans. For example an order might go through the following status of Crea
ted, In-Progress, Delivered. The time span between any 2 states could range
from minutes to days to mon
ths. I want to be able to see the current status and also the status as of l
ast month, or last quarter or some other previous date.
Some of the recommendations by extert sites are to have a date in your fact
table for each status accompained by a field
for storing a value 1. So the order fact by look like
Order Id
Order Create Date
Order Created Value
Order In-Progress Date
Order In-Progress Value
Order Delivered Date
Order Delivered Value
Also I am creating my own time dimension. The above approach will work very
well when you use SQLs to access your star schema, but I am not so sure this
approach will work for olap tools like MSAS.
Is there an alternative?
ThanksWhat you have here looks like an accumulating snapshot fact table. These
are best employed IMHO where you have a business process/relatively short
with milestones which you want to track.
It means that you have less rows in your fact table but that you will
revisit the row to perform UPDATEs, something not typically done.
This type of fact table is good for measuring time lags between business
processes i.e.
Time from Order -> Sale
Time from Sale -> Ship
The way I do this is to create a view over the top of the fact table which
calculates these figures for me. This way i can then use it as a measure
just like any other. I usually do it to difference in hours.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Break It" <anonymous@.discussions.microsoft.com> wrote in message
news:13CB4DFA-500D-4268-B850-5EE207F917CD@.microsoft.com...
> This is more of a design question. I am trying to create a fact table for
time spans. For example an order might go through the following status of
Created, In-Progress, Delivered. The time span between any 2 states could
range from minutes to days to months. I want to be able to see the current
status and also the status as of last month, or last quarter or some other
previous date.
> Some of the recommendations by extert sites are to have a date in your
fact table for each status accompained by a field
> for storing a value 1. So the order fact by look like
> Order Id
> Order Create Date
> Order Created Value
> Order In-Progress Date
> Order In-Progress Value
> Order Delivered Date
> Order Delivered Value
> Also I am creating my own time dimension. The above approach will work
very well when you use SQLs to access your star schema, but I am not so sure
this approach will work for olap tools like MSAS.
> Is there an alternative?
> Thanks
Monday, March 26, 2012
Mobile Only? Why?
I've just finished installing the workstation tools from the SQL Server 2005
DVD (No database engine).
I've also installed Visual Studio 2005, with just the VB option and the
other standard stuff.
When I start the Management Studio, connect to a server (doesn't matter what
version), then open a new query, the query is disconnected and the only
connection option is for SQL Server Mobile.
Anyone have any ideas?
I've installed (and repaired) the native client. I can browse servers and
see objects, etc., just no queries. I've installed/uninstalled three times.
Thanks all.
Am I correct that you are talking about the New Query dialog box in
Management Studio? On the File menu, point to New, do you see Database
Engine Query as one of the choices?
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
> I've just finished installing the workstation tools from the SQL Server
> 2005 DVD (No database engine).
> I've also installed Visual Studio 2005, with just the VB option and the
> other standard stuff.
> When I start the Management Studio, connect to a server (doesn't matter
> what version), then open a new query, the query is disconnected and the
> only connection option is for SQL Server Mobile.
> Anyone have any ideas?
> I've installed (and repaired) the native client. I can browse servers and
> see objects, etc., just no queries. I've installed/uninstalled three
> times.
> Thanks all.
>
|||Yes, the dropdown (to select a provider) is disabled with SQL Server Mobile
being the selected item.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Am I correct that you are talking about the New Query dialog box in
> Management Studio? On the File menu, point to New, do you see Database
> Engine Query as one of the choices?
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
>
|||I've shopped your e-mail around Microsoft a bit, and we can't think of any
reasonable way you could get into that condition. The obvious but cop-out
answer is that either Management Studio or the underlying Visual Studio is
somehow damaged. It's less likely to be related to the SQL Native Client.
Some more questions:
Are you using the RTM version of SQL Server Management Studio?
How consistent is this problem? That is, there are several ways to open the
Connect to Server dialog box in Management Studio:
- On the File menu, point to New, and then click Database Engine Query
- On the Standard toolbar, click New Query
- On the Standard toolbar, click Database Engine Query
- On the Object Explorer toolbar, click Connect, and then click Database
Engine
Do you only get SQL Server Mobile with any of those ways?
What about registering servers? On the View menu click Register Servers. In
the Registered Servers window toolbar, click Database Engine. Now can you
register a Database Engine by right-clicking Database Engine, point to New,
and then click Server Registration? Now is the Server type listed as
"Database Engine"?
Can you connect to the Database Engine from the Server Explorer of Visual
Studio?
(I'm interested in assisting you but I will not be available again until
Monday. Sorry. Holiday plans.)
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
> Yes, the dropdown (to select a provider) is disabled with SQL Server
> Mobile being the selected item.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
>
|||Yes, I'm using the version handed out in Vegas at the launch.
I have tried all the connection methods detailed below with the same
results. I am able to register, and connect to a database server and browse
objects, etc.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
> I've shopped your e-mail around Microsoft a bit, and we can't think of any
> reasonable way you could get into that condition. The obvious but cop-out
> answer is that either Management Studio or the underlying Visual Studio is
> somehow damaged. It's less likely to be related to the SQL Native Client.
> Some more questions:
> Are you using the RTM version of SQL Server Management Studio?
> How consistent is this problem? That is, there are several ways to open
> the Connect to Server dialog box in Management Studio:
> - On the File menu, point to New, and then click Database Engine Query
> - On the Standard toolbar, click New Query
> - On the Standard toolbar, click Database Engine Query
> - On the Object Explorer toolbar, click Connect, and then click Database
> Engine
> Do you only get SQL Server Mobile with any of those ways?
> What about registering servers? On the View menu click Register Servers.
> In the Registered Servers window toolbar, click Database Engine. Now can
> you register a Database Engine by right-clicking Database Engine, point to
> New, and then click Server Registration? Now is the Server type listed as
> "Database Engine"?
> Can you connect to the Database Engine from the Server Explorer of Visual
> Studio?
> (I'm interested in assisting you but I will not be available again until
> Monday. Sorry. Holiday plans.)
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
>
|||If you can browse objects, I presume that means you can connect with Object
Explorer. What happens in Object Explorer if you right-click a database, and
then click New Query? You should get a Database Engine query window. Does
that work? This will tell us if the Query Editor is working properly.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
> Yes, I'm using the version handed out in Vegas at the launch.
> I have tried all the connection methods detailed below with the same
> results. I am able to register, and connect to a database server and
> browse objects, etc.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||It comes up as a disconnected query. When I right-click in the query window
and select connect, the connection dialog appears.
In this dialog, the dropdown (to select a provider) is disabled and SQL
Server Mobile is the selected item.
Thanks.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
> If you can browse objects, I presume that means you can connect with
> Object Explorer. What happens in Object Explorer if you right-click a
> database, and then click New Query? You should get a Database Engine query
> window. Does that work? This will tell us if the Query Editor is working
> properly.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
>
|||I sorry. I know this must be frustrating for you, but I can think of no
reason for this. Since you have already uninstalled and reinstalled that
should have fixed any damaged binaries or registry entries. I'm out of
ideas. I guess that means you need a call to product support.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
> It comes up as a disconnected query. When I right-click in the query
> window and select connect, the connection dialog appears.
> In this dialog, the dropdown (to select a provider) is disabled and SQL
> Server Mobile is the selected item.
> Thanks.
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
>
|||Thanks for trying, anyway.
I'm out of ideas, also. I have successfully installed it on a second
workstation and laptop, both more or less identically configured.
It's probably about time I rebuilt this one anyway, it's been five years...
Thanks again.
Dave
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:eyd$Pyp9FHA.952@.TK2MSFTNGP12.phx.gbl...
>I sorry. I know this must be frustrating for you, but I can think of no
>reason for this. Since you have already uninstalled and reinstalled that
>should have fixed any damaged binaries or registry entries. I'm out of
>ideas. I guess that means you need a call to product support.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
>
sql
DVD (No database engine).
I've also installed Visual Studio 2005, with just the VB option and the
other standard stuff.
When I start the Management Studio, connect to a server (doesn't matter what
version), then open a new query, the query is disconnected and the only
connection option is for SQL Server Mobile.
Anyone have any ideas?
I've installed (and repaired) the native client. I can browse servers and
see objects, etc., just no queries. I've installed/uninstalled three times.
Thanks all.
Am I correct that you are talking about the New Query dialog box in
Management Studio? On the File menu, point to New, do you see Database
Engine Query as one of the choices?
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
> I've just finished installing the workstation tools from the SQL Server
> 2005 DVD (No database engine).
> I've also installed Visual Studio 2005, with just the VB option and the
> other standard stuff.
> When I start the Management Studio, connect to a server (doesn't matter
> what version), then open a new query, the query is disconnected and the
> only connection option is for SQL Server Mobile.
> Anyone have any ideas?
> I've installed (and repaired) the native client. I can browse servers and
> see objects, etc., just no queries. I've installed/uninstalled three
> times.
> Thanks all.
>
|||Yes, the dropdown (to select a provider) is disabled with SQL Server Mobile
being the selected item.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Am I correct that you are talking about the New Query dialog box in
> Management Studio? On the File menu, point to New, do you see Database
> Engine Query as one of the choices?
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
>
|||I've shopped your e-mail around Microsoft a bit, and we can't think of any
reasonable way you could get into that condition. The obvious but cop-out
answer is that either Management Studio or the underlying Visual Studio is
somehow damaged. It's less likely to be related to the SQL Native Client.
Some more questions:
Are you using the RTM version of SQL Server Management Studio?
How consistent is this problem? That is, there are several ways to open the
Connect to Server dialog box in Management Studio:
- On the File menu, point to New, and then click Database Engine Query
- On the Standard toolbar, click New Query
- On the Standard toolbar, click Database Engine Query
- On the Object Explorer toolbar, click Connect, and then click Database
Engine
Do you only get SQL Server Mobile with any of those ways?
What about registering servers? On the View menu click Register Servers. In
the Registered Servers window toolbar, click Database Engine. Now can you
register a Database Engine by right-clicking Database Engine, point to New,
and then click Server Registration? Now is the Server type listed as
"Database Engine"?
Can you connect to the Database Engine from the Server Explorer of Visual
Studio?
(I'm interested in assisting you but I will not be available again until
Monday. Sorry. Holiday plans.)
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
> Yes, the dropdown (to select a provider) is disabled with SQL Server
> Mobile being the selected item.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
>
|||Yes, I'm using the version handed out in Vegas at the launch.
I have tried all the connection methods detailed below with the same
results. I am able to register, and connect to a database server and browse
objects, etc.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
> I've shopped your e-mail around Microsoft a bit, and we can't think of any
> reasonable way you could get into that condition. The obvious but cop-out
> answer is that either Management Studio or the underlying Visual Studio is
> somehow damaged. It's less likely to be related to the SQL Native Client.
> Some more questions:
> Are you using the RTM version of SQL Server Management Studio?
> How consistent is this problem? That is, there are several ways to open
> the Connect to Server dialog box in Management Studio:
> - On the File menu, point to New, and then click Database Engine Query
> - On the Standard toolbar, click New Query
> - On the Standard toolbar, click Database Engine Query
> - On the Object Explorer toolbar, click Connect, and then click Database
> Engine
> Do you only get SQL Server Mobile with any of those ways?
> What about registering servers? On the View menu click Register Servers.
> In the Registered Servers window toolbar, click Database Engine. Now can
> you register a Database Engine by right-clicking Database Engine, point to
> New, and then click Server Registration? Now is the Server type listed as
> "Database Engine"?
> Can you connect to the Database Engine from the Server Explorer of Visual
> Studio?
> (I'm interested in assisting you but I will not be available again until
> Monday. Sorry. Holiday plans.)
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
>
|||If you can browse objects, I presume that means you can connect with Object
Explorer. What happens in Object Explorer if you right-click a database, and
then click New Query? You should get a Database Engine query window. Does
that work? This will tell us if the Query Editor is working properly.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
> Yes, I'm using the version handed out in Vegas at the launch.
> I have tried all the connection methods detailed below with the same
> results. I am able to register, and connect to a database server and
> browse objects, etc.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||It comes up as a disconnected query. When I right-click in the query window
and select connect, the connection dialog appears.
In this dialog, the dropdown (to select a provider) is disabled and SQL
Server Mobile is the selected item.
Thanks.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
> If you can browse objects, I presume that means you can connect with
> Object Explorer. What happens in Object Explorer if you right-click a
> database, and then click New Query? You should get a Database Engine query
> window. Does that work? This will tell us if the Query Editor is working
> properly.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
>
|||I sorry. I know this must be frustrating for you, but I can think of no
reason for this. Since you have already uninstalled and reinstalled that
should have fixed any damaged binaries or registry entries. I'm out of
ideas. I guess that means you need a call to product support.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
> It comes up as a disconnected query. When I right-click in the query
> window and select connect, the connection dialog appears.
> In this dialog, the dropdown (to select a provider) is disabled and SQL
> Server Mobile is the selected item.
> Thanks.
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
>
|||Thanks for trying, anyway.
I'm out of ideas, also. I have successfully installed it on a second
workstation and laptop, both more or less identically configured.
It's probably about time I rebuilt this one anyway, it's been five years...
Thanks again.
Dave
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:eyd$Pyp9FHA.952@.TK2MSFTNGP12.phx.gbl...
>I sorry. I know this must be frustrating for you, but I can think of no
>reason for this. Since you have already uninstalled and reinstalled that
>should have fixed any damaged binaries or registry entries. I'm out of
>ideas. I guess that means you need a call to product support.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
>
sql
Wednesday, March 21, 2012
MMC Cannot open
who knows how to fix this:
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
This may be because the file doesnt exist, is not an MMC console, or
was created by a later version of MMC. This may also be because
you do not have sufficient access rights to the file.
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advance
Jane
Jane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>
|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now.
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas.
Cheers
Jane
|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane
|||Thanks for your help, but it doesn't work. Any ideas?
Jane
-- Dinesh T.K wrote: --
Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane
|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps[vbcol=seagreen]
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know[vbcol=seagreen]
> what to do now.
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps[vbcol=seagreen]
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know[vbcol=seagreen]
> what to do now.
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
This may be because the file doesnt exist, is not an MMC console, or
was created by a later version of MMC. This may also be because
you do not have sufficient access rights to the file.
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advance
Jane
Jane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>
|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now.
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas.
Cheers
Jane
|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane
|||Thanks for your help, but it doesn't work. Any ideas?
Jane
-- Dinesh T.K wrote: --
Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane
|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps[vbcol=seagreen]
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know[vbcol=seagreen]
> what to do now.
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps[vbcol=seagreen]
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know[vbcol=seagreen]
> what to do now.
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
MMC Cannot open
who knows how to fix this
MMC cannot open the file C:\Program Files\Microsoft SQ
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC
This may be because the file doesnt exist, is not an MMC console, o
was created by a later version of MMC. This may also be becaus
you do not have sufficient access rights to the file
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advanc
JanJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas
Cheer
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas
Jan
-- Dinesh T.K wrote: --
Jane
Refer the steps 3 to 5 given in the 'workaround' section of this article
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000
http://support.microsoft.com/default.aspx?id=27245
PS: I know that the title of the article doesnt concern you, but those step
might help
-
Dines
SQL Server MV
-
-
SQL Server FAQ a
http://www.tkdinesh.co
"Jane" <anonymous@.discussions.microsoft.com> wrote in messag
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com..
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000
The problem is very strange. I suppose I am locked by the server. Don't kno
what to do now
> As I said, I am new to SQL Server, I am trying to explore it. But ther
isn't a senior member in our team, so your help turns to be very importan
for me. I am looking forward to any ideas
> Cheer
> Jan|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>sql
MMC cannot open the file C:\Program Files\Microsoft SQ
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC
This may be because the file doesnt exist, is not an MMC console, o
was created by a later version of MMC. This may also be becaus
you do not have sufficient access rights to the file
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advanc
JanJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas
Cheer
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas
Jan
-- Dinesh T.K wrote: --
Jane
Refer the steps 3 to 5 given in the 'workaround' section of this article
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000
http://support.microsoft.com/default.aspx?id=27245
PS: I know that the title of the article doesnt concern you, but those step
might help
-
Dines
SQL Server MV
-
-
SQL Server FAQ a
http://www.tkdinesh.co
"Jane" <anonymous@.discussions.microsoft.com> wrote in messag
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com..
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000
The problem is very strange. I suppose I am locked by the server. Don't kno
what to do now
> As I said, I am new to SQL Server, I am trying to explore it. But ther
isn't a senior member in our team, so your help turns to be very importan
for me. I am looking forward to any ideas
> Cheer
> Jan|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>sql
MMC Cannot open
who knows how to fix this:
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
This may be because the file doesnt exist, is not an MMC console, or
was created by a later version of MMC. This may also be because
you do not have sufficient access rights to the file.
I have rebooted the server, and restarted my machine, uninstalled and reinst
alled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manag
er. Can anyone help?
Thanks in advance
JaneJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The
problem is very strange. I suppose I am locked by the server. Don't know wh
at to do now.
As I said, I am new to SQL Server, I am trying to explore it. But there isn'
t a senior member in our team, so your help turns to be very important for m
e. I am looking forward to any ideas.
Cheers
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas?
Jane
-- Dinesh T.K wrote: --
Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.[vbcol=seagreen]
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
there[vbcol=seagreen]
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.[vbcol=seagreen]
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
there[vbcol=seagreen]
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
This may be because the file doesnt exist, is not an MMC console, or
was created by a later version of MMC. This may also be because
you do not have sufficient access rights to the file.
I have rebooted the server, and restarted my machine, uninstalled and reinst
alled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manag
er. Can anyone help?
Thanks in advance
JaneJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC.
> This may be because the file doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The
problem is very strange. I suppose I am locked by the server. Don't know wh
at to do now.
As I said, I am new to SQL Server, I am trying to explore it. But there isn'
t a senior member in our team, so your help turns to be very important for m
e. I am looking forward to any ideas.
Cheers
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas?
Jane
-- Dinesh T.K wrote: --
Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.[vbcol=seagreen]
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
there[vbcol=seagreen]
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
2000.[vbcol=seagreen]
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
there[vbcol=seagreen]
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
>
>
Monday, March 19, 2012
Missing What To Start SQLServer Agent in EM
Installed Office service pack and it 'messed' up the Enterprise Manager. Af
ter reinstalling the client tools and the sp3a service pack all worked but s
cheduled jobs. It turns out that the SQL Server Agent is not running. It d
oesn't automatically start
up but can be started from DOS whereby my jobs in turn can execute with no p
roblem.
Would like to know what the proper registry setting for SQLServerAgent under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent should
be for SQL Server 8.0.859 with service pack 3a as suspect that the problem m
ay be there.
Otherwise open to suggestions so that do not have to backup, uninstall, and
reinstall 10 database.....
Thanxs,
dmatta59The first thing to do here is go into the Control Panel -> Admin Tools ->
Services applet & see if the SQLAgent$[instance] service is configured t
o
auto-start. Your post doesn't indicated that you've done that, so make sure
the service's "Startup Type" property is set to "Automatic". If it still
doesn't start automatically, check the Windows Event Log to see what's
wrong.
Regards,
Greg Linwood
SQL Server MVP
"dmatta59" <anonymous@.discussions.microsoft.com> wrote in message
news:6F7A83AF-FE7A-46EF-8F44-50C94788109C@.microsoft.com...
> Installed Office service pack and it 'messed' up the Enterprise Manager.
After reinstalling the client tools and the sp3a service pack all worked but
scheduled jobs. It turns out that the SQL Server Agent is not running. It
doesn't automatically start up but can be started from DOS whereby my jobs
in turn can execute with no problem.
> Would like to know what the proper registry setting for SQLServerAgent
under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent
should be for SQL Server 8.0.859 with service pack 3a as suspect that the
problem may be there.
> Otherwise open to suggestions so that do not have to backup, uninstall,
and reinstall 10 database.....
> Thanxs,
> dmatta59|||The SqlServerAgent is set to automatic. There used to be an error 8344 Supe
rSocket Error but after the registers were cleaned and errors removed the e
rror no longer appears. When viewing the registry for SQLServerAgent there
was some mention in one of
the previous posts about a "dependancies" which is not present so would app
reciate what the registry would look like for MSSQLSERVER and SQLSERVERAGENT
.
Again it works fine if started from a dos command line but most inconvienent
not to have it start automatically or start from within the EM.
Any suggestions?
dmatta59|||Have resolved the problem. Used scm.exe to install the SQLServerAgent servi
ce using the instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
**Please note that the in this case the sqlagent -c -v was working from the
dos prompt and the jobs could run properly. The only problem was that the S
QLServerAgent was not automatically starting or couldn't be started within E
M.
Thank you,
dmatta59
ter reinstalling the client tools and the sp3a service pack all worked but s
cheduled jobs. It turns out that the SQL Server Agent is not running. It d
oesn't automatically start
up but can be started from DOS whereby my jobs in turn can execute with no p
roblem.
Would like to know what the proper registry setting for SQLServerAgent under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent should
be for SQL Server 8.0.859 with service pack 3a as suspect that the problem m
ay be there.
Otherwise open to suggestions so that do not have to backup, uninstall, and
reinstall 10 database.....
Thanxs,
dmatta59The first thing to do here is go into the Control Panel -> Admin Tools ->
Services applet & see if the SQLAgent$[instance] service is configured t
o
auto-start. Your post doesn't indicated that you've done that, so make sure
the service's "Startup Type" property is set to "Automatic". If it still
doesn't start automatically, check the Windows Event Log to see what's
wrong.
Regards,
Greg Linwood
SQL Server MVP
"dmatta59" <anonymous@.discussions.microsoft.com> wrote in message
news:6F7A83AF-FE7A-46EF-8F44-50C94788109C@.microsoft.com...
> Installed Office service pack and it 'messed' up the Enterprise Manager.
After reinstalling the client tools and the sp3a service pack all worked but
scheduled jobs. It turns out that the SQL Server Agent is not running. It
doesn't automatically start up but can be started from DOS whereby my jobs
in turn can execute with no problem.
> Would like to know what the proper registry setting for SQLServerAgent
under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent
should be for SQL Server 8.0.859 with service pack 3a as suspect that the
problem may be there.
> Otherwise open to suggestions so that do not have to backup, uninstall,
and reinstall 10 database.....
> Thanxs,
> dmatta59|||The SqlServerAgent is set to automatic. There used to be an error 8344 Supe
rSocket Error but after the registers were cleaned and errors removed the e
rror no longer appears. When viewing the registry for SQLServerAgent there
was some mention in one of
the previous posts about a "dependancies" which is not present so would app
reciate what the registry would look like for MSSQLSERVER and SQLSERVERAGENT
.
Again it works fine if started from a dos command line but most inconvienent
not to have it start automatically or start from within the EM.
Any suggestions?
dmatta59|||Have resolved the problem. Used scm.exe to install the SQLServerAgent servi
ce using the instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
**Please note that the in this case the sqlagent -c -v was working from the
dos prompt and the jobs could run properly. The only problem was that the S
QLServerAgent was not automatically starting or couldn't be started within E
M.
Thank you,
dmatta59
Monday, March 12, 2012
Missing tools in SSMS 2005
I am using SSMS since a few weeks, and I found it is missing a few
tools/utilities from the old Query Analyzer. One of the things which hit
me is the lack of the Debug (I know I can do it in VS 2005, but I can't
understand why I can't debug in SMSS), another is the lack of support
for Sql Server 2000 diagrams, and then there are annoying things as
forcing us to use a different shortcut to bookmark and so on.
The worst of all, anyway, is that we still can't apply a customized
format to the sql documents. In the development team I am working in
we're using a formatting code convention quite different from that
recommended by the Books Online, so every time I use the Query Designer,
I have then manually to 'beautify' the resulting T-SQL code. Even in VS
2005 there seems not to be a way to format all of a SQL document, as it
is possible to do with c# i.e..
Get me right, so far my experience with SMSS has been positive, only
these and other little defaillances are marking the difference between
an useful tool and a tool to recommend.
ale
http://www.riolo.org
Hi
Check out the SQL Server Magazine article on debugging:
http://www.windowsitpro.com/Article/...754/47754.html
For diagrams look in Books online on how to set them up and add one
http://msdn2.microsoft.com/en-us/library/ms189279.aspx
John
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Go to the Product Feedback Center and put in a request to add the features
that are missing
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Michael Hotek wrote:
> Go to the Product Feedback Center and put in a request to add the features
> that are missing
I already did it for one of the most annoying of the lack, a
customizable sql document formatter either in SSMS either in VS2005:
http://lab.msdn.microsoft.com/produc...e-43fe9c69ad8f
ale
http://www.riolo.org
|||Alessandro Riolo (alessandro.riolo@.sen.it) writes:
> The worst of all, anyway, is that we still can't apply a customized
> format to the sql documents. In the development team I am working in
> we're using a formatting code convention quite different from that
> recommended by the Books Online, so every time I use the Query Designer,
I can't say that the most serious problem with the Query Designer is
that you cannot customize how it formats the code. A much more serious
problem is that it may rewrite queries to have a different meaning.
That tool is dangerous!
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||John Bell wrote:
> For diagrams look in Books online on how to set them up and add one
> http://msdn2.microsoft.com/en-us/library/ms189279.aspx
Quoting the BOL:
"SQL Server 2005 database diagrams and SQL Server 2000 database diagrams
are created and rendered differently. Because of these differences, SQL
Server Management Studio cannot work with SQL Server 2000 diagrams. Use
SQL Server 2000 Enterprise Manager"
ale
http://www.riolo.org
tools/utilities from the old Query Analyzer. One of the things which hit
me is the lack of the Debug (I know I can do it in VS 2005, but I can't
understand why I can't debug in SMSS), another is the lack of support
for Sql Server 2000 diagrams, and then there are annoying things as
forcing us to use a different shortcut to bookmark and so on.
The worst of all, anyway, is that we still can't apply a customized
format to the sql documents. In the development team I am working in
we're using a formatting code convention quite different from that
recommended by the Books Online, so every time I use the Query Designer,
I have then manually to 'beautify' the resulting T-SQL code. Even in VS
2005 there seems not to be a way to format all of a SQL document, as it
is possible to do with c# i.e..
Get me right, so far my experience with SMSS has been positive, only
these and other little defaillances are marking the difference between
an useful tool and a tool to recommend.
ale
http://www.riolo.org
Hi
Check out the SQL Server Magazine article on debugging:
http://www.windowsitpro.com/Article/...754/47754.html
For diagrams look in Books online on how to set them up and add one
http://msdn2.microsoft.com/en-us/library/ms189279.aspx
John
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Go to the Product Feedback Center and put in a request to add the features
that are missing
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Michael Hotek wrote:
> Go to the Product Feedback Center and put in a request to add the features
> that are missing
I already did it for one of the most annoying of the lack, a
customizable sql document formatter either in SSMS either in VS2005:
http://lab.msdn.microsoft.com/produc...e-43fe9c69ad8f
ale
http://www.riolo.org
|||Alessandro Riolo (alessandro.riolo@.sen.it) writes:
> The worst of all, anyway, is that we still can't apply a customized
> format to the sql documents. In the development team I am working in
> we're using a formatting code convention quite different from that
> recommended by the Books Online, so every time I use the Query Designer,
I can't say that the most serious problem with the Query Designer is
that you cannot customize how it formats the code. A much more serious
problem is that it may rewrite queries to have a different meaning.
That tool is dangerous!
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||John Bell wrote:
> For diagrams look in Books online on how to set them up and add one
> http://msdn2.microsoft.com/en-us/library/ms189279.aspx
Quoting the BOL:
"SQL Server 2005 database diagrams and SQL Server 2000 database diagrams
are created and rendered differently. Because of these differences, SQL
Server Management Studio cannot work with SQL Server 2000 diagrams. Use
SQL Server 2000 Enterprise Manager"
ale
http://www.riolo.org
Missing Tools after Setup
In the MSDE BOOKs there is a list of utilities and there directorys that i
should have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-bcp2
-console
-isql2
-sqlagent
-sqldiag
-sqlmaint
-sqlservr
-vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp2
-dtsrun
-dtswiz
-isql2
-isqlw
-itwiz
-odbccmpt
-osql
-rebuildm
-sqlftwiz
x:\Program Files\Microsoft SQL Server\80\Com
-distrib3
-logread3
-replmerg3
-snapshot3
x:\Program Files\Common Files\Microsoft Shared\Service Manager
-scm
x:\Program Files\Common Files\Microsoft Shared\?
-regxmlss
That is the list that i should have, here is the list that i do have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-cmdwrap.exe
-sqlagent.exe
-sqlmaint.exe
-sqlservr.exe
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp.exe
-cnfgsvr.exe
-dcomscm.exe
-DTSRUN.exe
-OSQL.exe
-scm.exe
-sqladhlp.exe
-sqlmangr.exe
-SVRNETCN.exe
x:\Program Files\Microsoft SQL Server\80\Com
-DISTRIB.exe
-replmerg.exe
-snapshot.exe
x:\Program Files\Common Files\Microsoft Shared\Service Manager
NO Service Manager Directory Exists
x:\Program Files\Common Files\Microsoft Shared\?
It says that this all should have been installed on the install by default
here is how installed
i moved my command prompt to the directory containing the setup folder
(C:\MSDERela)
then i ran
setup SAPWD="??"
this installed fine
what did i do wrong?
ALso i am very new to databases
the only thing that i have ever used is access which is pretty cut and dry.
I have had a lot of trouble finding simple tutorials for a beginner if any
one knows of one please let me know.
In the mean time a couple of quick questions:
1) does a database file have to be in the directory: C:\Program
Files\Microsoft SQL Server\MSSQL\Data
in order for it to work?
2) other than osql how can i access my data? The Books say that thre is a
SQL Server Query analyzer but could not find it (see beginning of post)
thanks Again for the help
WStoreyII
Hi,
I'm not sure which MSDE book you are referring to but the tools you mention
are those that are installed with SQL Server, not with the MSDE. The MSDE
ships with limited tools. The intention is that your application will do the
work. We have some tools you could try at our site. Others are at:
http://www.microsoft.com/sql/msde/pa.../default.aspx.
The data files do not have to be in a specific folder but you will find life
much easier if you have them all in a particular folder.
If you are going to be doing development for the MSDE, I'd strongly suggest
you purchase a copy of the SQL Server Developer Edition. I gather it's
currently only around $49 USD and provides a wealth of things you'll find
useful during development.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WStoreyII" <WStoreyII@.discussions.microsoft.com> wrote in message
news:9109A07D-4093-4473-AB0A-CFDFD9611C06@.microsoft.com...
> In the MSDE BOOKs there is a list of utilities and there directorys that i
> should have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -bcp2
> -console
> -isql2
> -sqlagent
> -sqldiag
> -sqlmaint
> -sqlservr
> -vswitch
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp2
> -dtsrun
> -dtswiz
> -isql2
> -isqlw
> -itwiz
> -odbccmpt
> -osql
> -rebuildm
> -sqlftwiz
> x:\Program Files\Microsoft SQL Server\80\Com
> -distrib3
> -logread3
> -replmerg3
> -snapshot3
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> -scm
> x:\Program Files\Common Files\Microsoft Shared\?
> -regxmlss
> That is the list that i should have, here is the list that i do have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -cmdwrap.exe
> -sqlagent.exe
> -sqlmaint.exe
> -sqlservr.exe
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp.exe
> -cnfgsvr.exe
> -dcomscm.exe
> -DTSRUN.exe
> -OSQL.exe
> -scm.exe
> -sqladhlp.exe
> -sqlmangr.exe
> -SVRNETCN.exe
> x:\Program Files\Microsoft SQL Server\80\Com
> -DISTRIB.exe
> -replmerg.exe
> -snapshot.exe
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> NO Service Manager Directory Exists
> x:\Program Files\Common Files\Microsoft Shared\?
> It says that this all should have been installed on the install by default
> here is how installed
> i moved my command prompt to the directory containing the setup folder
> (C:\MSDERela)
> then i ran
> setup SAPWD="??"
> this installed fine
> what did i do wrong?
> ALso i am very new to databases
> the only thing that i have ever used is access which is pretty cut and
> dry.
> I have had a lot of trouble finding simple tutorials for a beginner if any
> one knows of one please let me know.
> In the mean time a couple of quick questions:
> 1) does a database file have to be in the directory: C:\Program
> Files\Microsoft SQL Server\MSSQL\Data
> in order for it to work?
> 2) other than osql how can i access my data? The Books say that thre is a
> SQL Server Query analyzer but could not find it (see beginning of post)
> thanks Again for the help
> WStoreyII
>
|||Greg's correct. MSDE was not intended to ship
with the full compliment of (management) tools
as SQL Server is.
If you're want to get up and running as quick as
possible then Microsoft Access (2000 and above)
is an excellent interface to MSDE for your own
internal development purposes. Micrsoft press has
a decent book on Access Data Projects also.
If you're wanting to use MSDE to develop a
distributable application, then you'll need to
be coding everything yourself.
Good luck.
should have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-bcp2
-console
-isql2
-sqlagent
-sqldiag
-sqlmaint
-sqlservr
-vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp2
-dtsrun
-dtswiz
-isql2
-isqlw
-itwiz
-odbccmpt
-osql
-rebuildm
-sqlftwiz
x:\Program Files\Microsoft SQL Server\80\Com
-distrib3
-logread3
-replmerg3
-snapshot3
x:\Program Files\Common Files\Microsoft Shared\Service Manager
-scm
x:\Program Files\Common Files\Microsoft Shared\?
-regxmlss
That is the list that i should have, here is the list that i do have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-cmdwrap.exe
-sqlagent.exe
-sqlmaint.exe
-sqlservr.exe
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp.exe
-cnfgsvr.exe
-dcomscm.exe
-DTSRUN.exe
-OSQL.exe
-scm.exe
-sqladhlp.exe
-sqlmangr.exe
-SVRNETCN.exe
x:\Program Files\Microsoft SQL Server\80\Com
-DISTRIB.exe
-replmerg.exe
-snapshot.exe
x:\Program Files\Common Files\Microsoft Shared\Service Manager
NO Service Manager Directory Exists
x:\Program Files\Common Files\Microsoft Shared\?
It says that this all should have been installed on the install by default
here is how installed
i moved my command prompt to the directory containing the setup folder
(C:\MSDERela)
then i ran
setup SAPWD="??"
this installed fine
what did i do wrong?
ALso i am very new to databases
the only thing that i have ever used is access which is pretty cut and dry.
I have had a lot of trouble finding simple tutorials for a beginner if any
one knows of one please let me know.
In the mean time a couple of quick questions:
1) does a database file have to be in the directory: C:\Program
Files\Microsoft SQL Server\MSSQL\Data
in order for it to work?
2) other than osql how can i access my data? The Books say that thre is a
SQL Server Query analyzer but could not find it (see beginning of post)
thanks Again for the help
WStoreyII
Hi,
I'm not sure which MSDE book you are referring to but the tools you mention
are those that are installed with SQL Server, not with the MSDE. The MSDE
ships with limited tools. The intention is that your application will do the
work. We have some tools you could try at our site. Others are at:
http://www.microsoft.com/sql/msde/pa.../default.aspx.
The data files do not have to be in a specific folder but you will find life
much easier if you have them all in a particular folder.
If you are going to be doing development for the MSDE, I'd strongly suggest
you purchase a copy of the SQL Server Developer Edition. I gather it's
currently only around $49 USD and provides a wealth of things you'll find
useful during development.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WStoreyII" <WStoreyII@.discussions.microsoft.com> wrote in message
news:9109A07D-4093-4473-AB0A-CFDFD9611C06@.microsoft.com...
> In the MSDE BOOKs there is a list of utilities and there directorys that i
> should have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -bcp2
> -console
> -isql2
> -sqlagent
> -sqldiag
> -sqlmaint
> -sqlservr
> -vswitch
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp2
> -dtsrun
> -dtswiz
> -isql2
> -isqlw
> -itwiz
> -odbccmpt
> -osql
> -rebuildm
> -sqlftwiz
> x:\Program Files\Microsoft SQL Server\80\Com
> -distrib3
> -logread3
> -replmerg3
> -snapshot3
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> -scm
> x:\Program Files\Common Files\Microsoft Shared\?
> -regxmlss
> That is the list that i should have, here is the list that i do have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -cmdwrap.exe
> -sqlagent.exe
> -sqlmaint.exe
> -sqlservr.exe
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp.exe
> -cnfgsvr.exe
> -dcomscm.exe
> -DTSRUN.exe
> -OSQL.exe
> -scm.exe
> -sqladhlp.exe
> -sqlmangr.exe
> -SVRNETCN.exe
> x:\Program Files\Microsoft SQL Server\80\Com
> -DISTRIB.exe
> -replmerg.exe
> -snapshot.exe
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> NO Service Manager Directory Exists
> x:\Program Files\Common Files\Microsoft Shared\?
> It says that this all should have been installed on the install by default
> here is how installed
> i moved my command prompt to the directory containing the setup folder
> (C:\MSDERela)
> then i ran
> setup SAPWD="??"
> this installed fine
> what did i do wrong?
> ALso i am very new to databases
> the only thing that i have ever used is access which is pretty cut and
> dry.
> I have had a lot of trouble finding simple tutorials for a beginner if any
> one knows of one please let me know.
> In the mean time a couple of quick questions:
> 1) does a database file have to be in the directory: C:\Program
> Files\Microsoft SQL Server\MSSQL\Data
> in order for it to work?
> 2) other than osql how can i access my data? The Books say that thre is a
> SQL Server Query analyzer but could not find it (see beginning of post)
> thanks Again for the help
> WStoreyII
>
|||Greg's correct. MSDE was not intended to ship
with the full compliment of (management) tools
as SQL Server is.
If you're want to get up and running as quick as
possible then Microsoft Access (2000 and above)
is an excellent interface to MSDE for your own
internal development purposes. Micrsoft press has
a decent book on Access Data Projects also.
If you're wanting to use MSDE to develop a
distributable application, then you'll need to
be coding everything yourself.
Good luck.
Subscribe to:
Posts (Atom)