Detecting (local) sql-server

Can someone please point me to some code (preferably C#, but C++ or C or VB
will work) that will detect if the (local) instance of SQL Server is
running on a machine or not? Many thanks!

-- Rob"Rob Gibson" <xnews@.rgibREMOVEson.net> wrote in message
news:Xns95FADFA7C4F67defffft1078@.216.196.97.142...
> Can someone please point me to some code (preferably C#, but C++ or C or
> VB
> will work) that will detect if the (local) instance of SQL Server is
> running on a machine or not? Many thanks!
> -- Rob

MSSQL is just another service, so you should look for code which shows how
to retrieve service states from C# - it looks as if there's a sample with
Visual Studio:

http://msdn.microsoft.com/library/d...scontroller.asp

If you have multiple instances, then see questions 12 and 13 here for how to
find the instance names:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in news:420dc8db$1_1@.news.bluewin.ch:

> MSSQL is just another service, so you should look for code which shows
> how to retrieve service states from C# - it looks as if there's a
> sample with Visual Studio:
> http://msdn.microsoft.com/library/d...ry/en-us/cssamp
> le/html/vcsamprocesscontroller.asp
> If you have multiple instances, then see questions 12 and 13 here for
> how to find the instance names:
> http://support.microsoft.com/defaul...257716&Product=
> sql2k
> Simon

Thank you, Simon! That's *EXACTLY* what I was looking for!

-- Rob

Detect (local) SQL Server

Can someone please point me to some code (preferably C#, but C++ or C or VB
will work) that will detect if the (local) instance of SQL Server is
running on a machine or not? Many thanks!
-- RobHi Rob
Try using the the ServiceController class to check to see if the MSSQLServer
service is running (ServiceControllerStatus.Running).
Cheers
J.
"Rob Gibson" <xnews@.rgibREMOVEson.net> wrote in message
news:Xns95FAE91589AFBdefffft1078@.216.196.97.142...
> Can someone please point me to some code (preferably C#, but C++ or C or
VB
> will work) that will detect if the (local) instance of SQL Server is
> running on a machine or not? Many thanks!
> -- Rob

designer wanted

Hi!
I'm looking for (preferably free) a tool that is useful in graphical
representation of DB (something like Oracle Designer). Could you give me
some hints where to find one?
Thanx
Yaro
Visio is pretty good for any type of UML design as well as E-R Diagramming.
It can even generate classes for you as well as the SQL needed to create the
objects.
Its' relatively inexpensive as far as designers go.
Rick Sawtell
"Jarosaw Tajcher" <ziomuch@.wp.pl> wrote in message
news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> Hi!
> I'm looking for (preferably free) a tool that is useful in graphical
> representation of DB (something like Oracle Designer). Could you give me
> some hints where to find one?
> Thanx
> Yaro
>
|||The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Acc
ess).
Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
Tea C.
"Rick Sawtell" wrote:

> Visio is pretty good for any type of UML design as well as E-R Diagramming.
> It can even generate classes for you as well as the SQL needed to create the
> objects.
> Its' relatively inexpensive as far as designers go.
>
> Rick Sawtell
>
> "Jaros3aw Tajcher" <ziomuch@.wp.pl> wrote in message
> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
>
>
|||There is no inexpensive tool for data modelling. While the SQL Server,
Access and Visio, may work they all have drawbacks.
One key feature is the ability to create a database or at least tables
in a database directly from a diagram and to have changes in the
diagram relect in the tables and relationships.
Anothe key feature of a tool is the ability to store elements of the
model ina repository for future re-use. Any experience developer would
love to carry around a file of tables used on other projects as a
short cut to designing the current project.
Lastly, you should look for the data and OODB (UML) modeling symbols
for Visio that may now exist, some for no fee, if your goal is OODBs.
Lou Arnold
On Sat, 24 Jul 2004 19:06:02 -0700, "=?Utf-8?B?VGVhQw==?="
<smece1972@.yahoo.com.nospam> wrote:

>The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Ac
cess).[vbcol=seagreen]
>Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
>--
>Tea C.
>
>"Rick Sawtell" wrote:

designer wanted

Hi!
I'm looking for (preferably free) a tool that is useful in graphical
representation of DB (something like Oracle Designer). Could you give me
some hints where to find one?
Thanx
YaroVisio is pretty good for any type of UML design as well as E-R Diagramming.
It can even generate classes for you as well as the SQL needed to create the
objects.
Its' relatively inexpensive as far as designers go.
Rick Sawtell
"Jarosaw Tajcher" <ziomuch@.wp.pl> wrote in message
news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> Hi!
> I'm looking for (preferably free) a tool that is useful in graphical
> representation of DB (something like Oracle Designer). Could you give me
> some hints where to find one?
> Thanx
> Yaro
>|||The SQL Server (assuming you have already paid for it) comes with a diagramm
ing tool. Also, MS Access (in case you aready have a copy of it) has a "rel
ationship" tool which might be useful for your project (you can import prett
y much any data into MS Acc
ess).
Not exactly, what you asked for, but you might already have the tool you are
looking for...in your hands...
Tea C.
"Rick Sawtell" wrote:

> visio is pretty good for any type of UML design as well as E-R Diagramming
.
> It can even generate classes for you as well as the SQL needed to create t
he
> objects.
> Its' relatively inexpensive as far as designers go.
>
> Rick Sawtell
>
> "Jaros3aw Tajcher" <ziomuch@.wp.pl> wrote in message
> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
>
>|||There is no inexpensive tool for data modelling. While the SQL Server,
Access and Visio, may work they all have drawbacks.
One key feature is the ability to create a database or at least tables
in a database directly from a diagram and to have changes in the
diagram relect in the tables and relationships.
Anothe key feature of a tool is the ability to store elements of the
model ina repository for future re-use. Any experience developer would
love to carry around a file of tables used on other projects as a
short cut to designing the current project.
Lastly, you should look for the data and OODB (UML) modeling symbols
for visio that may now exist, some for no fee, if your goal is OODBs.
Lou Arnold
On Sat, 24 Jul 2004 19:06:02 -0700, "examnotes"
<smece1972@.yahoo.com.nospam> wrote:

>The SQL Server (assuming you have already paid for it) comes with a diagramming too
l. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool
which might be useful for your project (you can import pretty much any data into MS
Ac
cess).[vbcol=seagreen]
>Not exactly, what you asked for, but you might already have the tool you ar
e looking for...in your hands...
>--
>Tea C.
>
>"Rick Sawtell" wrote:
>

designer wanted

Hi!
I'm looking for (preferably free) a tool that is useful in graphical
representation of DB (something like Oracle Designer). Could you give me
some hints where to find one?
Thanx
YaroVisio is pretty good for any type of UML design as well as E-R Diagramming.
It can even generate classes for you as well as the SQL needed to create the
objects.
Its' relatively inexpensive as far as designers go.
Rick Sawtell
"Jaros³aw Tajcher" <ziomuch@.wp.pl> wrote in message
news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> Hi!
> I'm looking for (preferably free) a tool that is useful in graphical
> representation of DB (something like Oracle Designer). Could you give me
> some hints where to find one?
> Thanx
> Yaro
>|||The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Access).
Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
--
Tea C.
"Rick Sawtell" wrote:
> Visio is pretty good for any type of UML design as well as E-R Diagramming.
> It can even generate classes for you as well as the SQL needed to create the
> objects.
> Its' relatively inexpensive as far as designers go.
>
> Rick Sawtell
>
> "Jaros³aw Tajcher" <ziomuch@.wp.pl> wrote in message
> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> > Hi!
> > I'm looking for (preferably free) a tool that is useful in graphical
> > representation of DB (something like Oracle Designer). Could you give me
> > some hints where to find one?
> > Thanx
> > Yaro
> >
> >
>
>|||There is no inexpensive tool for data modelling. While the SQL Server,
Access and Visio, may work they all have drawbacks.
One key feature is the ability to create a database or at least tables
in a database directly from a diagram and to have changes in the
diagram relect in the tables and relationships.
Anothe key feature of a tool is the ability to store elements of the
model ina repository for future re-use. Any experience developer would
love to carry around a file of tables used on other projects as a
short cut to designing the current project.
Lastly, you should look for the data and OODB (UML) modeling symbols
for Visio that may now exist, some for no fee, if your goal is OODBs.
Lou Arnold
On Sat, 24 Jul 2004 19:06:02 -0700, "=?Utf-8?B?VGVhQw==?="
<smece1972@.yahoo.com.nospam> wrote:
>The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Access).
>Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
>--
>Tea C.
>
>"Rick Sawtell" wrote:
>> Visio is pretty good for any type of UML design as well as E-R Diagramming.
>> It can even generate classes for you as well as the SQL needed to create the
>> objects.
>> Its' relatively inexpensive as far as designers go.
>>
>> Rick Sawtell
>>
>> "Jaros³aw Tajcher" <ziomuch@.wp.pl> wrote in message
>> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
>> > Hi!
>> > I'm looking for (preferably free) a tool that is useful in graphical
>> > representation of DB (something like Oracle Designer). Could you give me
>> > some hints where to find one?
>> > Thanx
>> > Yaro
>> >
>> >
>>