sql server tutorial
mp
Tried to run the create database sample (connects to sql server)
the docs says visual studio required...i only have express
is there no way to go through the samples with express?
here is the last few lines of an error log...does this indicate that express
is not going to run the sample?
2009-11-24 18:32:46.95 Server SQL Server is now ready for client
connections. This is an informational message; no user action is required.
2009-11-24 18:32:47.36 spid7s Informational: No full-text supported
languages found.
2009-11-24 18:32:47.38 spid7s Starting up database 'msdb'.
2009-11-24 18:32:49.14 spid10s Clearing tempdb database.
2009-11-24 18:32:52.41 spid10s Starting up database 'tempdb'.
2009-11-24 18:32:53.32 spid13s The Service Broker protocol transport is
disabled or not configured.
2009-11-24 18:32:53.32 spid13s The Database Mirroring protocol transport
is disabled or not configured.
2009-11-24 18:32:53.35 spid13s Service Broker manager has started.
2009-11-24 18:32:53.37 spid7s Recovery is complete. This is an
informational message only. No user action is required.
2009-11-24 22:54:53.57 Server SQL Server is terminating because of a
system shutdown. This is an informational message only. No user action is
required.
2009-11-24 22:54:59.28 spid7s Server resumed execution after being idle
13884 seconds: user activity awakened the server. This is an informational
message only. No user action is required.
2009-11-24 22:55:00.57 spid7s Error: 17054, Severity: 16, State: 1.
2009-11-24 22:55:00.57 spid7s The current event was not reported to the
Windows Events log. Operating system error = (null). You may need to clear
the Windows Events log if it is full.
2009-11-24 22:55:10.52 spid13s Service Broker manager has shut down.
2009-11-24 22:55:12.71 spid7s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
TheSQLGuru
functionality and a VERY low price.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"mp" <nos...@Thanks.com> wrote in message
news:uuQ%23B6kbK...@TK2MSFTNGP06.phx.gbl...
mp
I'm guessing that is just sqlserver and not include visual studio?
I have very low usage and knowlege of sql and am just trying to get basic
understanding to make few small database utilities for my own use at work.
(where i believe they have sql server but have no idea how they are using
it...for what purposes etc)
since this is all on my own time and dime i have Very small budget for
purchasing mainstream tools
I'd think the sql express that comes with the c#express editions would have
ample capability to make simple db
(if i could get it to work)
:-)
thanks for the suggestion
mark
"TheSQLGuru" <kgb...@earthlink.net> wrote in message
news:e4ydnbN9PYANB5PW...@earthlink.com...
Erland Sommarskog
> I dled the c# samples from msdn
> Tried to run the create database sample (connects to sql server)
> the docs says visual studio required...i only have express
> is there no way to go through the samples with express?
>
> here is the last few lines of an error log...does this indicate that
> express is not going to run the sample?
The error log does not say anything in particular.
Since I don't know then samples you are talking about, it's difficult
to help more. You can compile C# programs from the command line, if
you download the .Net Framwork SDK.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
TheSQLGuru
price.
$40.91, free shipping. That low enough for you? :)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"mp" <nos...@Thanks.com> wrote in message
news:ug5Y$DubKH...@TK2MSFTNGP04.phx.gbl...
mp
to get sqlexpress working
(have spent about the last 4 hours (on my slow dialup connection) following
links trying to create a simple database sample).
40 is not a problem but if i can't even get an express version working i
probably have no hope of getting a pro version up
and if the sql server requires visual studio pro version to operate (as the
samples imply) the 600 for that is currently out of reach.
thanks for the info
i'll keep searching to see if there's a way to make sqlexpress function from
c#express create database commands'
thanks
mark
"TheSQLGuru" <kgb...@earthlink.net> wrote in message
news:YrSdnQBvkNfEk5LW...@earthlink.com...
Andrew J. Kelly
Developer is exactly like Enterprise edition but with a different license
and cost. It is self contained and does not require Visual Studio as it has
its own tool called SSMS. It does require the .net framework but so does
most things these days and that is free. In my opinion Developer edition is
easier to use than express in the first place.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"mp" <nos...@Thanks.com> wrote in message
news:eGxLtGvb...@TK2MSFTNGP06.phx.gbl...
Erland Sommarskog
> It's referred to as just the Developer edition not pro by the way.
> Developer is exactly like Enterprise edition but with a different
> license and cost. It is self contained and does not require Visual
> Studio as it has its own tool called SSMS. It does require the .net
> framework but so does most things these days and that is free.
mp
at this point, after spending days trying to learn how to get sqlserver
running I'm wondering if it's too far over kill for my needs (one
computer...no remote...simple database to track projects...)
Just trying to make a quickie database window to enter jobs/contacts/to do
lists etc...for personal use
is sql server just too big and complicated for such simple task
I could stay with vb6 and sqllite but am also trying to learn dotnet so
thats how i got started trying to use sql server.
seems like it may just be beyond me?
Thanks
mark
"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9CD0EE183...@127.0.0.1...
Erland Sommarskog
> thanks Andrew and Erland,
> at this point, after spending days trying to learn how to get sqlserver
> running I'm wondering if it's too far over kill for my needs (one
> computer...no remote...simple database to track projects...)
> Just trying to make a quickie database window to enter jobs/contacts/to do
> lists etc...for personal use
> is sql server just too big and complicated for such simple task
> I could stay with vb6 and sqllite but am also trying to learn dotnet so
> thats how i got started trying to use sql server.
> seems like it may just be beyond me?
I guess our problem is that we have very little understanding of what
you have problem with. Your initial post mentioned some problems about
samples, but you did not give much details. Yeah, you mentioned MSDN,
but we don't know the samples by heart.
It also seemed from your post that the samples requires Visual Studio,
but you don't have Visual Studio. That's not really a problem with SQL
Server, is it? (And Visual Studio is far more complicated than SQL Server
in my opinion.)
How far did you come? Were you able to compile and link the sample programs?
In such case, what happened when you tried to run them?
So much is clear, if you don't tell us what is going wrong for you,
we cannot help you.
mp
> mp (nos...@Thanks.com) writes:
>> thanks Andrew and Erland,
>> seems like it may just be beyond me?
>
> I guess our problem is that we have very little understanding of what
> you have problem with. Your initial post mentioned some problems about
> samples, but you did not give much details. Yeah, you mentioned MSDN,
> but we don't know the samples by heart.
>
> It also seemed from your post that the samples requires Visual Studio,
> but you don't have Visual Studio. That's not really a problem with SQL
> Server, is it? (And Visual Studio is far more complicated than SQL Server
> in my opinion.)
>
> How far did you come? Were you able to compile and link the sample
> programs?
> In such case, what happened when you tried to run them?
>
> So much is clear, if you don't tell us what is going wrong for you,
> we cannot help you.
Thanks Erland,
and apologies for being so unclear, i am so unknowing about this i didn't
even know what to ask!
I've learned alot over the days of reading so many links etc
I didn't reailze all the setup steps that were involved in getting server to
run
I've gotten to the point of being able to sqlcmd -L in command prompt and
see a server instance finally
one tutorial on setting up server said i needed to set something in
management studio(which i didn't have)
so i downloaded and installed that but nothing appeared after restart
now today on more research i find that mgmt studio wont work with express so
i need mgmt studio express
now i'm downloading that and will continue the long trek
after doing what i can to get it set up will revisit the samples and see if
they run
thanks for your help and patience and apologies for being such a box of
rocks
:-)
will post back in future if I need more help
thanks to all for helping me get this far
mark
Erland Sommarskog
> so i downloaded and installed that but nothing appeared after restart
What did not appear?
> now today on more research i find that mgmt studio wont work with express
That is incorrect. You can use non-Express Mgmt Studio with Express
Edition. What does not work is the non-Express and Express versions
of Mgmt Studio side by side.
mp
> mp (nos...@Thanks.com) writes:
>> so i downloaded and installed that but nothing appeared after restart
>
> What did not appear?
>
>> now today on more research i find that mgmt studio wont work with express
>
> That is incorrect. You can use non-Express Mgmt Studio with Express
> Edition. What does not work is the non-Express and Express versions
> of Mgmt Studio side by side.
>
ok i stand corrected, was just repeating what some ms site said (i think)
i installed the orig studio, it appeared to run a setup wizard and asked for
a restart
after restart there were no cleanup or finished installing dialogs, no
desktopicons for studio, no listing in start ; all programs for studio, no
sub menu under sql server menu, no obvious entries in program files, so i
assumed it figured out it was on the wrong version and self aborted the
install?
maybe an incomplete download for the install? but i would think if that were
the case it never would have run in the first place.
where would i look for the exe if it had installed? assuming it creates a
exe
Erland Sommarskog
> after restart there were no cleanup or finished installing dialogs, no
> desktopicons for studio, no listing in start ; all programs for studio, no
> sub menu under sql server menu, no obvious entries in program files, so i
> assumed it figured out it was on the wrong version and self aborted the
> install?
> maybe an incomplete download for the install? but i would think if that
> were the case it never would have run in the first place. where would i
> look for the exe if it had installed? assuming it creates a exe
tools should normally not require a restart. But if you have some components
open that needs to be replace, you will have to endure one.
Seriously, if you want help, you need to give us more information of what
you installed, and what you ran. Did you even tell us which version of
SQL Server you tried to install?
If you have SQL 2005, SQL Server Management Studio is in
"C:\Program Files (x86)\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"
on my machine. SSMS 2008 is:
"C:\Program Files (x86)\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
mp
> mp (nos...@Thanks.com) writes:
>> after restart there were no cleanup or finished installing dialogs, no
>> desktopicons for studio, no listing in start ; all programs for studio,
>> no
>> sub menu under sql server menu, no obvious entries in program files, so i
>> assumed it figured out it was on the wrong version and self aborted the
>> install?
>> maybe an incomplete download for the install? but i would think if that
>> were the case it never would have run in the first place. where would i
>> look for the exe if it had installed? assuming it creates a exe
>
> I have very little of what you actually did. An install of the SQL Server
> tools should normally not require a restart. But if you have some
> components
> open that needs to be replace, you will have to endure one.
>
> Seriously, if you want help, you need to give us more information of what
> you installed, and what you ran. Did you even tell us which version of
> SQL Server you tried to install?
sorry, i thought i'd mentioned somewhere up thread that i was dealing with
the express versions
I've gotten the books online and have gotten a lot of good background info
from everyone here, thank you all
will spend some time reading now, at this point it looks like this is all
well over my head and probably
much more powerful than what I need for a simple desktop database file.
Thank you all for your time.
mark
Erland Sommarskog
>> Seriously, if you want help, you need to give us more information of what
>> you installed, and what you ran. Did you even tell us which version of
>> SQL Server you tried to install?
>
> sorry, i thought i'd mentioned somewhere up thread that i was dealing with
> the express versions
Express is an edition. But is it SQL 2005 or SQL 2008?
And you said that you tried install the non-Express version of
SQL Server Mangement Studio? Then you must at least have gotten that
from another edition.
mp
> mp (nos...@Thanks.com) writes:
>>> Seriously, if you want help, you need to give us more information of
>>> what
>>> you installed, and what you ran. Did you even tell us which version of
>>> SQL Server you tried to install?
>>
>> sorry, i thought i'd mentioned somewhere up thread that i was dealing
>> with
>> the express versions
>
> Express is an edition. But is it SQL 2005 or SQL 2008?
Like I said, this may all be moot as it seems it's beyond my ability to
understand and learn, and for now I just need to do extensive reading of all
the sites Ive saved over the past week of searching. but since you ask,
here's what I remember of what I tried to install
I'm guessing the sql server version is 2008 due to seeing folder in
Start|All Programs | Microsoft Sql Server 2008
I don't understand why it doesn't say Microsoft Sql Server 2008 Express but
it doesn't.
In program files there is a sql server folder under which is a folder
"MSSQL10.SQLEXPRESS"
So again I don't know if that means 2008 but assume maybe so.
I was thinking it was 2005 as most of the sites i've seen referenced that
version and I didn't realize there was a newer.
I don't recall installing sql server myself - I think it came along for the
ride when I installed c# express?
I've just been trying to "wake it up" or figure out how to access it
> And you said that you tried install the non-Express version of
> SQL Server Mangement Studio? Then you must at least have gotten that
> from another edition.
I got Server Mangement Studio by searching for that term and finding a
download on some ms site.
I found the reference to management studio in an article I'd found which
appeared to address my original error on trying the sample i originally
mentioned (Could not open a connection to SQL Server)
That simple error started the last week of searching and reading and posting
:-)
I never knew it was leading down such a long winding road!
I dont' have the exact url but when I saved the page to desktop the file
name became:
SQL SERVER � FIX ERROR (provider Named Pipes Provider, error 40 � Could
not open a connection to SQL Server) (Microsoft SQL Server, Error ) �
Journey to SQL Authority with Pinal Dave.mht
on that page he said I had to enable remote connections named pipes tcp
windows firewall exceptions etc etc
I did all that then he said i needed Server Mangement Studio to do some
setting
so i searched for that and found on some ms site, I didn't save the url of
the page where I found the download but the file name is:
SQLManagementStudio_x86_ENU.exe
It doesn't mention a version as you can see so I didn't know for sure.
I ran that installation, followed the prompts(which called for a restart)
and that's when I found nothing was installed, that I could find. Then
after more searching and reading I found where that version didnt' work with
express so I found the express version. (someone mentioned that it does
work, but I can't find the program if it did install itself)
At this point I haven't installed the express version of Server Mangement
Studio since this whole process of learning how much i didn't know has
consumed more time than I'd expected, and I'm back to looking at older
samples of using sqlite with vb6 which may be easier than learning this new
sql server system.
anyhow thanks again for all the insight you've shared, I've learned a lot
and it seems that sql server is just more than needed for a simple embedded
database file for a single user desktop application. I figure if I'm not
even smart enough to be able to install it and get it to run, what hope do I
have of learning to use it!?!
:-)
Thanks anyway
mark
mp
"mp" <nos...@Thanks.com> wrote in message
>
> "Erland Sommarskog" <esq...@sommarskog.se> wrote in message
> news:Xns9CD2AA1D0...@127.0.0.1...
>> mp (nos...@Thanks.com) writes:
>>>> Seriously, if you want help, you need to give us more information of
>>>> what
>>>> you installed, and what you ran. Did you even tell us which version of
>>>> SQL Server you tried to install?
> I don't recall installing sql server myself - I think it came along for
> the ride when I installed c# express?
Now i think that's wrong, I may have installed it from the website...
www.microsoft.com/express/sql/download/default.aspx
I've done so many things trying to figure this out I've forgotten all the
steps i've been through....
snip
Erland Sommarskog
> I'm guessing the sql server version is 2008 due to seeing folder in
> Start|All Programs | Microsoft Sql Server 2008 I don't understand why it
> doesn't say Microsoft Sql Server 2008 Express but it doesn't. In program
> files there is a sql server folder under which is a folder
> "MSSQL10.SQLEXPRESS"
> So again I don't know if that means 2008 but assume maybe so.
Yes, that is SQL 2008. The internal version number is 10.
> so i searched for that and found on some ms site, I didn't save the url of
> the page where I found the download but the file name is:
> SQLManagementStudio_x86_ENU.exe
> It doesn't mention a version as you can see so I didn't know for sure.
That seems to be the Express version. The real SSMS is not available for
download from Microsoft.
mp
> mp (nos...@Thanks.com) writes:
>> I'm guessing the sql server version is 2008 due to seeing folder in
>> Start|All Programs | Microsoft Sql Server 2008 I don't understand why it
>> doesn't say Microsoft Sql Server 2008 Express but it doesn't. In program
>> files there is a sql server folder under which is a folder
>> "MSSQL10.SQLEXPRESS"
>> So again I don't know if that means 2008 but assume maybe so.
>
> Yes, that is SQL 2008. The internal version number is 10.
>
>> so i searched for that and found on some ms site, I didn't save the url
>> of
>> the page where I found the download but the file name is:
>> SQLManagementStudio_x86_ENU.exe
>> It doesn't mention a version as you can see so I didn't know for sure.
>
> That seems to be the Express version. The real SSMS is not available for
> download from Microsoft.
>
>
Right, it's supposed to be the express version., I dled it again and
installed again, and again "nothing happens"
meaning...no shortcuts created, no entries under start | all programs, no
submenu under sql Server menu under All Programs, no folders i can see
getting created under sql folders
At this point I'm giving up on sql server and going back to sql lite.
more than enough power for what i need and none of this headache.
I know it must just be me but i've never had this much trouble in past dling
and installing a prog.
oh well
Thanks for your input anyway
Mark