Getting Started With The Express SQL 7
Dec 22, 2007How do you get started? I downloaded the SQL 7 software and the sample databases, and
did the start program to run the SQL Server Configuration Manager (Local), but what do you do now?
Thanks
ADVERTISEMENT
I Have Only Started Working With SQL Express
Nov 27, 2007And now i'm looking for what in SQL Server 2000 used to be:
Management->
SQL Server Agent->
jobs Can anyone help me find where i can add a job in SQL Express please?
Thanks
Getting Started With SQL Server Express......
Mar 19, 2008Well, its a bit embarrasing to have to ask such ignorant questions, but......
I've been using Oracle for a long time. And VERY occasionally I dabbled just a bit into SQL Server 2000.......
I now would like to create a database driven web application, so I downloaded the Express set. And the books online, in the hope they'd be well organized and provide simple straightforward information on how to do things.... If its there, I'm not finding it.
First question: Is there SOMEWHERE online tutorial/information on specifically how to do things? Something for a user familiar with relational databases and design and such, but needing to understand specifically how THIS database product works?
For example, I managed to get the management studio express open. And in "Registered Servers" there's something called Database Engine, within which there's serversqlexpress.
Can I create an instance (or whatever it is in the MS world) OTHER than sqlexpress, and do I need to? I ask because it appears sqlexpress is on my "C" drive, and I don't want it there... There appear to be system databases within sqlexpress, and I presume they'll grow... SO, do I need to get all this off to another disk? And, if so, how? Feel free to point me to the right documentation - I tried the SQL Server 2005 Tutorials, but after going through the "lesson" on SQL Server Management Studio I realized it was geared toward "how to open a window" rather than how to actually do anything... I found another topic in here that pointed to the "Getting Started White Paper", but that doesn't appear to be valid any more. It also pointed to the "Management Studio Express Primer" but that link just throws a 404 error...
And what on earth does the SQL Server Configuration Manager do? I've gotta be missing something that's obvious to the informed observer...
Getting Started With SQL Server Express 2005
Nov 4, 2005I am looking for a resource that will speak to the process of how to create a SQL Express database within VS 2005 - create relationships within the Database Diagrams (right now it complains that it does not have a valid dbo user and that I do not have permission impersonate the dbo user - if i tel it to grant me access it gives me the same message) - what security issues need to be considered as far as the SQL Express stuff is concerned. I am also wanting to know what pieces I need to have on my Internet and Intranet web servers so that when I delpoy my .net 2.0 app that the servers will be able to deal with the SQL Express database that gets copied out there? Should SQL Express on the web server be set to windows auth or mixed mode auth? If I choose windows auth does that mean that the ISP (internet server) has to have an NT account created for my web app so that I can connect to the SQL mdf?
I guess I am just kinda struggling with the process from creation of the database to making sure that when I deploy the application that it will be available.
Any help would be appreciated!Thanks,Derek
Troubles Getting Started With SQL 2005 Express
Dec 5, 2005So, I downloaded and installed SQL Server 2005 Express, and I just can't figure out how to get it to do anything.
I'm accustomed to SQL Server 2000, and I don't see anything familiar.
Where's Query Analyzer? Where's Enterprise Manager? All I see is this "Configuration Manager" stuff, which doesn't seem particularly useful.
How am I supposed to use this software? I feel like they could have tried a little harder on this one.
How To Get Started On Microsoft SQL Server Management Studio Express
Sep 13, 2006Hi,
Was trying to open AdventureWorks when i got this error: "There is no editor available "C: Program Flies.....AdventureWorksDW_Log.LDF'
Make sure the application for the file type(.LDF) is installed.
How can this error be corrected? I also have some error on mdf not installed.May i know how should be the initally steps to be done inorder for me to view this database.
And if i do have a database from microsoft access, what are the steps that i need to do inorder to get it export to Microsoft SQL Server Management Studio Express. Please advise as i really new to it. Thanks!
Started With Express, But Installed Developer And Don't See Developer Instance...
Jun 19, 2006I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Thanks,
Geoff
Well... Help Getting Started
Nov 25, 2003Dear All,
This is my first time posting in this forum, so forgive me if my post is out of place. If so, let me know.
I am trying to get started setting up a development server on Windows 2000. These are the componants I have installed so far:
- IIS 5
- MSDE Database Server
- .NET Framework 1.1
- MDAC (Microsoft Data Access Componants)
- ASP.NET Web Matrix
I have also downloaded a quickstart example, TimeTracker, to learn from.
Here is my problem: When I try to install TimeTracker, it does not detect a database connection. Also, when I try to connect to a database in Web Matrix, it says I need to have client tools installed. What are these and how to I get them?
Is there anyone that can give me a hand with this? Is it a matter of running the MSDE service? If so, how do you do this?
My apologies for not being more knowledgable, but thanks for helping me get started.
Sincerely,
Chris
Getting Started
Feb 2, 2003I have just started programming using sql server. how do i get stated?
the basics are needed thanks for ur advice
Can't Get Started
Jan 2, 2008I just installed SQL server 2005 with SP2 on Vista business.
When I open Management Studio, and try to Register a new server, I get this message:
Cannot connect to MyServer.
Additional information:
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could nor open a connection to SQL Server) (Microsoft SQL Server, Error: 1231)
When I open SQL Server 2005 Surface Area configuration and click on Add New Administrator, there are no Available privileges. Not sure if this is relevant.
Don't know what to do, any help will be appreciated.
Getting Started
May 27, 2006I have just installed SQL Server at home. Had a bit of experience at work, but at home I have to get started from scratch.
Enterprise manager says 'Connection could not be established'. In this error it talkes about 'registration properties'. I am (by default ?) a member of SQL Server group, but I have no sub items, like databases. And how do I get to where I can edit stored procedures ?
As you can see I'm quite a novice, but with a little nudge I can would a lot out myself. But not all. If you can help me now, I'll be back soon.
Thank you so much.
Regards
Robert
Getting Started, Need Some Help
Nov 27, 2006i have roughly 10-15 access databases that i am trying to run through sql server express, i installed this thing thinking it would would "just work minus a little configuration", what a misconception.
so do tell, what do i need to do. i have sql server express running, it is configured to allow remote connections. i know the path's of these access databases. how do i attach them. i saw something about the command line interface but im not interested in that because of the number of databases i will need to manage, not to mention trying to add an additional one 6 months down the road and i will be lost all over again. i thought about downloading SQL Server Management Studio thinking it would be a "gui side" to the CLI version. while it was downloading, it said i need XX program, i go to that page, it says i need XX and XX first, it is turning into a pyramid scheme to install a billion programs.
so point blank, i want to share some access databases to my local lan, i have sql server express installed and running. what do i need to finish this out. the simplest and smallest footprint solution is needed.
all this because the program im using cant do remote databases. ugh.
Getting Started
Apr 15, 2007Hi,
I am trying to make a small vb.net program in visual studio 2005 edition. I would like to have a SQL database with it.
I have the Microsoft Visual Studio and SQL Server 2005 installed on my PC. I am running XP but will be moving it all to a new pc running Vista next week.
How to I get the SQL database started ?
I am not using the express edition.
How To Get Started?
Feb 23, 2007This is a repost of my post on the VB Express board.
I would like your opinions.
I am a network guy. I learned basic years ago. I can do some html edits as needed to change sites.
Today I would like to start the long process of learning VB with .net applications. I thought I could start with Office developer xp to learn VB. I have that package.
I also would like to be able to build SQL quaries and integrations or automate and manipulate data exports and imports later down the road.
Example: Export various order and customer information from a shopping cart and import it in to Quickbooks or MS Accounting.
First off I need to be able to build web sites and I know I want to grow into VB and SQL.
What should I do?
Learn HTML from web monkey?
Start with Office xp developer Tutorials?
Start with VB Express?
Buy a book?
Can someone tell me where to start and when to move to the next language?
What is the best resource to get to it, without the bla bla bla and a commnd/syntax refference?
How do I mix Html, CSS and .Net (VB)...in the learning process?
I would like to get the fast track for the long haul.
Thanks so much.
How To Get Started?
Dec 27, 2006I am looking to learn about reporting with SQL Server for my company
Currently we have an applicaiton running on SQL Server 2000 and have SQL Server 2000 Reporting Services installed. However, I have VB Express and Web Development Express 2005.
How do I get started here? What versions "work" with what? Do I need to either upgrade the DB to SQL 2005 or find VB.net 2003, or can I use what I have to get started?
Getting Started 101
Aug 15, 2007hello,
i own about a dozen interactive forums (see example at http://ConcealedCarryForum.com for one of them) that i host on a windows 2000 server dedicated server out of my home on a commercial cable backbone. the forums are ASP using Access DBs. we have outgrown the capabilities of Access and are getting complaints from DB lag during peak usage, and i must upgrade my DB to ensure the QOS end users get from my forums. i have no intention of switching over to php/MySQL/linux formats.
i tried unsuccessfully to get MySQL to play nicely in a windows environment, and recently learned that MSSQL offers free versions, the compact and the express. trouble is, i know absolutely nothing about DB management. Access is idiot proof so i have used it as long as i could. now i find myself in a scramble to learn how to create, employ, and use a more powerful DB.
for my intended usage (running about a dozen DBs on a dedicated server), will compact or express be the appropriate version to start learning? for my intended usage, is there any benefit to downloading/installing/learning the additional tools that are also available? if so, which tools? where do i learn how to create new DBs, and what tools do i need to do this? most tech papers ive seen on MSSQL assume a prior working knowledge of MSSQL DB management and im coming into this completely ignorant but willing to dedicate myself to learning.
answers, advice, etc. very much appreciated.
Getting Started With DMX
Sep 19, 2006Hello,
I'm studying some articles about DMX and i have a question. DMX statements is only for prediction?
Can i create a model and run a classification/clustering/decision tree algorithm through DMX instead of prediction?Because all the examples i found are talking about prediction.
Are there any other sources i can study, so i can have a better understanding of what DMX does?
Thank you in advance!
Getting Started
Oct 15, 2007I am using this program for the first time but as it has no direct interface on its own, I would like to ask if anyone could help me get a database up and running.Nothing fancy but simple and functional for my staff to use for basic csv searches and so forth. skywalkerza@highveldmail.co.za
Trying To Get Started
Sep 19, 2006Hi folks... this is part complaint, part request for help. I have an Access db that I'd rather were an sql db. Partly to learn sql and partly because all of the asp.net examples use sql and don't seem to work with access.
I installed VS2005 which includes sqlexpress, but there's no front end to it.. there's no way to "talk to" this sql2005. Can't seem to create tables, etc.
So, I installed SQL 2005 Development server... still no front end. Just some config tools that I presume I may care about some day but don't mean anything to me just yet.
I'm on XP Pro so can't install SQL 2005 Enterprise, but I discover a CTP called Management Studio Express. Well, we all know how robust CTPs are, nevertheless I install it and boy is it friendly.
At this point I feel as though I've missed The Big Thing that had I not missed I would be a lot further along.
Maybe the best way to express my question is to ask for what the heck I should have done in order to be learning sql at this point instead of having run out of time again.
Thanks for any insight.
Best,
Eric
PS... hmm, seems like this is mostly complaint... sorry.
Job When It Was Started.
Nov 16, 2007
Hi all
I have a job for run DTS packages,
My Job got failed due some reason,I corrected the problem a started Job again.Here problem is I for got to note the start time.Now I want find out from how long it is running or it what time it started.
Thanks in advance
How To Get Started
Sep 6, 2007Hi -
I need to start from the beginning with SQL Server 7 2005 Express. I want to get financial data and perform analysis in conjunction with Excel. I have downloaded the file from Microsoft and would like a resource for getting going. What is the best way to go?
Your help appreciated.
Doug
Getting Started - What Do I Need?
Aug 7, 2006While I have been programming .Net for four years and T-SQL for about 12, I am a newbie to the whole SQL CLR thing. I have VS.NET 2003 on my machine, and I installed the client tools for SQL 2005 which also installs VS 2005 for SQL. Yet when I open VS 2005, it only has Data Analysis projects, but no Database projects. If I go into VS 2003 and try to import some of the assemblies I have found by googling 'SQL CLR' - VS 2003 won't let me add them.
Exactly what do I need to install so that I can get started? Do I need an instance of SQL server running on my machine? (I currently do not have a server running, only the client tools are installed)
TIA,
--Yonah
Help Getting Started With @@Identity
May 24, 2006OK, so, from what people tell me I should be using @@Idnetity. What Im trying to do is insert data into a table, than revrieve the id from the new row in that table, than use that id in another sql insert statment later down the road. Currnetly the way im doing it is with a sql insert, than executte the scalar, than execute a reader, which is causeing me much grief.
This is my sql statment here:
Dim sqlInsert As New SqlCommand("INSERT INTO Author (Lastname, FirstName, FullName) VALUES (@LName, @FName, @FullName)", sqlConn)
From what I understand, using @@Identity, I can retrive data from my insert statment without using a sperate select statment. Can you guys point me in the right direction, ive looked alot in the forms and such, most I found is either assuming you know what todo, or is security related.
Advice On Getting Started
Sep 27, 2005Hello all. I have some questions that are probably pretty stupid but Ill ask anyway :)
It is important that I start down a path of understanding mssql 2000. I wanted some advice from experts as to what the best way to start would be. Is there a great book out there? Can I run a version locally that I can play with? Also, when using the database, are the commands the same for mssql and mysql? I ask because I searched for tutorials and a lot more mysql tutorials popped up.
Obviously I dont expect to become an expert in a few weeks but if I could start down the path I would be happy. Maybe learn how to do simple maintenance and management functions.
Any advice would be greatly appreciated.
Help Getting Started With MS SQL 2005
Mar 6, 2008I have never used MS SQL database. I usually create my database with phpMyadmin. But my clinet doesn't have this tool. And they don't have MySQL instead they have MS SQL.
Could I create the data base with phpMyadmin and output that? Then import the data into MS SQL? There is no GUI tool on the server to create tables and data entry.
Getting Started With Cursors
Apr 4, 2008I have this simple example from which to start learning to use cursors:
USE ar
GO
DECLARE @mortgage INT
DECLARE @getMortgage CURSOR
SET @getMortgage = CURSOR FOR
SELECT Converted_Mortgage_Number
FROM format_mortgage_history
OPEN @getMortgage
FETCH NEXT
FROM @getMortgage INTO @mortgage
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT @mortgage
FETCH NEXT
FROM @getMortgage INTO @mortgage
END
CLOSE @getMortgage
DEALLOCATE @getMortgage
GO
Although it runs, I dont see the Converted_Mortage_Number printed. What have I done wrong please?
Getting Started: MS SQL 2005
Feb 16, 2007Hello everyone,
I have got MS SQL express editon 2005, installed on my laptop and want to download MS SQL 2005 With management studio
I have been searching on microsoft's website, Where can i download it ?
thanks
Ehi
Server Re-started
Apr 19, 2007We got a cluster server with Win2K3 sp1 with SQL 2K sp4, the server just re-start without failover, can see the following on the application log:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 01000; native error = 2746; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
It cause both instances on the server get restarted itself, did a search on the net and not much luck with it. Got some people saying its because of the clsuter admin can't query SQL and it just fail itself. And its using Name pipe rather then TCP/IP, so by putting an alias there will get the problem solved. But I would like to be sure. Does anyone have that issue before? And found a solution?
Thanks
Documentation To Get Started
Jul 20, 2005What is the best online documentation either on the Web or installedwithSQL Server that I could use to get started? I want to jump in andstartcreating tables, etc for applications.Also, what is the most recommended text for converting my DBAexperience from other database to SQL Server.ThanksBill.
View 3 Replies View RelatedThe Agent Could Not Be Started.
May 2, 2007I created a snapshot publication (the engine is SQL2005 and the compatibility is 2000).
I got this message:
"The agent could not be started.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
SQLServerAgent Error: Request to run job REPLSM-6 (from User DOMcustuser) refused because the job has been suspended.
Changed database context to SM. (Microsoft SQL Server, Error: 22022)"
And when i'm trying to reinitialize the publication, I get this:
"Replication Monitor could not start the Snapshot Agent to generate a new snapshot. You must start the Snapshot Agent manually before the subscription(s) can be reinitialized..."
What can I do? Why it doesn't work?
thnx
The SQL Server Can Not Be Started,help Me
Dec 12, 2006I need some help please. My MSDE database won't start after a reboot. This is a SurfControl MSDE database. It wasn't too healthy yesterday when the log on the SurfControl MSDE database filled so I truncated it and shrunk the file. Everything was cool until I rebooted the server today:-(
Trying to start the service it says "the system cannot find the file specified" - ok to that and it says "An error 2 (the system cannot find the file specified" occured while performing this service operation on the mssqlserver service "
sqlserver.exe -c -f gets this result
2005-11-26 20:00:03.28 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)
2005-11-26 20:00:03.30 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-11-26 20:00:03.32 server All rights reserved.
2005-11-26 20:00:03.32 server Server Process ID is 3636.
2005-11-26 20:00:03.32 server Logging SQL Server messages in file 'D:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'.
2005-11-26 20:00:03.35 server Warning: -f command line flag used...minimal server configured.
2005-11-26 20:00:03.35 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2005-11-26 20:00:03.46 server SQL Server configured for thread mode processing.
2005-11-26 20:00:03.46 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-11-26 20:00:03.60 server MS DTC initialization skipped because of start up option.
2005-11-26 20:00:03.60 server ksconsole: Could not initialize console operation.
2005-11-26 20:00:03.61 server Error: 17822, Severity: 16, State: 1
2005-11-26 20:00:03.61 server Could not load Net-Library 'SSNETLIB'..
2005-11-26 20:00:03.61 spid4 Warning ******************
2005-11-26 20:00:03.61 server Error: 17059, Severity: 18, State: 0
2005-11-26 20:00:03.61 server Operating system error 0: The operation completed successfully...
2005-11-26 20:00:03.61 spid4 SQL Server started in single user mode. Updates allowed to system catalogs.
2005-11-26 20:00:03.63 server Unable to load any NETLIBs. Server shutting down.2005-11-26 20:00:03.63 spid4 Starting up database 'master'.
Any ideas? I reall need to get it working. I don't think there are any backups
Getting Started Walkthroughs
Jan 5, 2006Hi all,
I was wondering if anyone knew of any good walkthroughs to help me get started with SQL 2005, SSIS in particular.
I have checked through the newsgroups and Blogs but they all go way to far above myhead.
I found a Teched 05 one which was good, but cant seem to find any more
Does anyone know of a place for begineers to go ?
Or even any books I could get.
Im not trying to do anything complicted, all I want to do is create a table and then import a text file to it.
Also it is possible to download ready made packages so I can play around with them and see how they work ?
Sorry for asking so many questions, any help with any of them would be greatly appreciated :)
Thanks
Getting Started With SQL Compact
Jul 27, 2007I've downloaded and installed SQL Compact Edition. When I go to Access to set up a project (or to use the upsizing wizard) the software doesn't see the Server on my computer. No doubt I'm missing some very simple step. Although the compact server is installed, there's no program file to run, so I don't see how to get into the server software in order to set up a database or project that I can link to from Access.
I've also downloaded and installed Microsoft.net. As with server, the files are in place but there's no program file to execute.