I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db’s, tables, load data, basic stuff like that?
View 3 RepliesHiii everyone,
Can anyone send me the link of SQL Server 2005 Video tutorial please..
I am waiting for it.....
Can someone tell me where I can find some SQL 2005 tutorials, e-learning or learnig tool for a kind of beginner. I want something where I can learn by doing. Some of the tutorials I have seen all pertain to .NET.
Thank you
Dee
Could someone point me to some good SQL 2005 Reporting Tutorials? Types of Reporting? Reporting without using .NET?
Dee
Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.
Regards,
Anson
I am relatively new to SQL Server and I have 2005. I am developing a database with an Access ADP frontend. The development is taking place on my laptop running a separate instance of SQL Server. I am trying to put the database on the production server and I am not sure how to proceed.
My laptop is not part of the network so I need to create a file and then import it on the SQL Server instance running on the production server. I thought I could do a backup and restore, but apparently that is not working.
Any help would be greatly appreciated.
Hi, I have a very newbie question.I have been only developing websites locally on my computer (during my learning curve) and never actually put anything up in a server on internet, but I just bought a server from discountasp.net and an extra SQL 2005 Database.Now I need to put my database on that server (copy the local one) I know I have a connection string and username and password. But I really do not have any ideas how to do this.I would appreciate if you tell me where to start and what I should do at this stage.Thank you and have a good day.
View 4 Replies View RelatedI want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.
While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.
I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.
Thanks for your help.
Steve
I installed SQL Server 2005 and want to practice the "Creating a Mobile Application with SQL Server Mobile" in SQL Server Mobile Editon Tutorials,but I can't find the file sqlmobile.sql listed in "C:" according to tutorial document.
View 3 Replies View RelatedI'm trying to learn how to use the bcp utility... but I keep getting an error message that says:
SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].SQLState = HYT00, NativeError = 0Error = [Microsoft][SQL Native Client]Login timeout expiredSQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]An error has occurred 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.
The command i'm running is:
bcp territore.dbo.import in territorydata.csv -T -c
territore is my database name... and dbo i think is the owner name.
and the table is called Import
I don't know how to check the default settings to see if remote connections are enabled. Any help would be appreciated.
Hi ,
Can i make a dimension from only one table in data source views?
And is possible add dimension without Wizard?
Thanks a lot
Fabrizio
I just created a stored procedure in SQL Server 2005 management studio. I went to my db and expanded the programmability folder then right clicked the stored procedures folder and created a stored procedure. I saved the procedure as sp_getDistance in the default folder SQL managment studio picked. Now when I went back to that stored procedure folder I did not see my stored procedure sp_getDistance, all that was there was the system stored procedure folder. Did I save the stored procedure in the wrong place, or what did I do wrong. I can't find the procedure anywhere, its just sitting in my My DocumentsSQL Server Management StudioProjectssp_getDistance.sql folder. Thanks,Kyle Spitzer
View 1 Replies View RelatedHi,
I'm a newbie on SSIS and am trying to grasp my way through this.
I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database.
What I want is to move the data to a staging table, then drop the main
table and rename the staging table to the main table, to minimize the
down-time of the data. I can't get the workflow to work, because the
staging table has to exist when I run the package. I thought I could
use an "Execute SQL" task to generate the table before I would run the
task, but that doesn't work. Am I going about this the wrong way? Is
there an optimal solution to this problem so my data can be accessible
as much as possible.
Regards,
Atli
HI,
I have problems with executing packages in the SQL Server 2005 and before I go into the details I would like to check, if my workflow is correct.
Can someone explain me the best way to move a package from BIDS to a SQL Server? I would like to store the packages in the SQL Server.
In addition if I login to Integration Services with SQL Server Management Studio I can see in the folder "stored packages" my package but I cannot view the folder "MSDB". Ususally I receive an error message from the named pipe provider, that I could not connect to the server (I am using Windows Authentication and my login is an administrator on the SLQ Server box)
Thanks in advvance
Nobs
Hi all,
Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.
Wee
Dear All,
Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.
...cause knowledge is power...
I inherited a computer from a co-worker who left. On it she installed SQL Server 2005. The help system is chock full of references to the various and sundry tutorials that come with the product, but I can't find so much as a syllable about how one actually accesses those tutorials.
When I select Start, Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Tutorials, SQL Server Tutorials, it simply launches one of the help screens. That screen, and the ones it contains links to, describe the tutorials topics in great detail, but nowhere is there any explanation of how you actually launch the tutorials.
What am missing here?
hi there
Can someone post some very good tutorials about MS SQL 2005 working with c#??
please
Thanks guys..
I have two tables "Inventory" and "Product". User creates a product then assignes inventory to that product.
The product table and the inventory table both have the same two fields, "GDS" and "prodID" and both share the same field and value of ProductID.
I'm trying to create a trigger for the Inventory table so when the Inventory table has an update or insert,
the values from Product.GDS and Product.prodID values go into the Inventory's record for Inventory.GDS and Inventory.prodID
I an having problems with the trigger as this is my first attempt in creating a trigger.
I have the trigger on the Inventory table and this is what I so far which does not seem to be working, any suggestions (thanks0:
Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [inv]
ON [dbo].[Inventory]
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON;
Update Inventory
Set GDS = i.GDS, prodID = i.prodId
From Inserted i
Inner Join Inventory inv ON i.ProductID = inv.ProductID
END
I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns?
I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up.
What are your ideas on this matter?
TIA,
barkingdog
Hi,
I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database.
For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine...
When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratch by resulting application. Considering this, is there any type of database that I can use and can be created/designed directly from within Visual Studio 2005?
My goal is that, if I distribute an application, I don't want my people to install anything else than simply install the resulting .exe file which should then be able to create by itself, when necessary, any database files it needs. Am I dreaming?
Thanks in advance,
Stéphane
Hi All...
Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...
Thanks to ALL
I feel stupid for asking this but I can't seem to find where to install the SSIS tutorials referenced in msdn.. specifically the "Deploying Packages Tutorial". In the SQL Server 2005 Developer Edition DVD that I have, I've chosen to install all of the samples etc. I have the AdventureWorks and AdventureWorksDW and a whole bunch of samples in "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesPackage Samples" but under the directory "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesTutorial" I only have sample data for "Creating a Simple ETL Package".
I know... feels like a dumb question but I have run the install wizard on both the dev edition dvd and the msdn library dvd several times and looked at all the options and can't find anything about tutorials under the SQL server installation or the workstation component installation. Please help. Thanks.
Hi,
I'm new to SQL Server Technology and am trying to learn how to create a Mobile Device application and to sync it with a desktop application that uses Access. I have found a lot of information but some of it doesn't seem to make sense.
I found this blog: http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx which is the announcement of Access Database Synchronizer (ADS) CTP. I downloaded it and installed it with all the prerequisites. This is the part i can't understand:
"The CTP setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Everywhere Edition database on the device."
I cannot seem to find the desktop component to try out! The Readme shows you how to pull and push data but i can't see where the desktop data sync wizard is located. Should there be something installed on my desktop that i can see?
Also, there doesn't seem to be much help or examples around on this component as yet. Can anyone point me in the right direction for examples, help, or tutorials on this.
This paragraph also confuses me:
"Note: As of today only SQL Server Mobile Edition is available for devices. SQL Server Everywhere Edition whould be available for devices at time of SQL Server Everywhere Edition RTW whihc is planned for November 2006".
Does this mean SQL Everywhere won't work on mobile devices until November?
Sorry for all the questions but i'm still trying to learn this stuff so i can write my application for Windows CE. Thanks in advance.
Where can I find tutorials on Service Broker with C#?
View 1 Replies View RelatedI was told that XML names must not start with the letters xml (or XML, or Xml, etc) But I was able to store such data in sql 2005. Any thoughts on this one?
TIA,
Barkingdog
Check out www.sql-server.co.uk.
This site offers a growing code library; tutorials & the full FAQ from Neil Pike SQL Server MVP in an easily readable search/review format.
Also a possible UK user group is being formed, initially information for this will be passed through this site - register there.
Hi - can anyone recommend tutorials/guides for beginners? The Microsoft documentation seems very poor to me especially in comparison to Oracle Express. I am really struggling to find a good intro/tutorial.
Many thanks
db
ok i need to know the difference between inner outer , left , right joins ....
anyone know any good tutorials ?
I'm developing a small WinForms windows application (in c#). The application will communicate with an SQL 2005 server on the same network. I'm not able to use windows integrated authentication since the client users will not be members of the same domain as the SQL server.
The thing is, I want the program to Identify itself as the same user in the database regardless of witch user that is logging in. In other words, a separate SQL-access account. The complete end user authentication will be against credentials stored inside my database. In this way I will not have to create separate database users for each user.
This would be easy solved if I stored the common sql-server account somewhere inside the application, however I realise that it's not a good idéa. (The saved password will not be safe)
So, my question is: Is there some "best practise" way of solving this problem?
Regards Andreas
I have downloaded and run all the .msi's for the sample databases. To install them I am suppose to use "SQL Server 2005 Setup, you need to click the Advanced button....". I don't seem to have a "SQL Server 2005 Setup" - did the docs revert back to SQL Server rather than SQL Express or what ???
R
Does anyone know where we can get more in-dept tutorials for the Data Mining Add-Ins for Excel? Currently, all we have are the videos from the microsoft web site as well as some white papers.
View 1 Replies View Related Hi,
I am using vs .net 2005, .net frameworks v3.0, vc++ 2005, clr, on vista
I am trying to write a c++ app to call a sql stored procedure.
the following code genrates an error trap and I don't know why:
String ^myConnectionString = "Initial Catalog=ncxSQL;Data
Source=ENVISION-MOD;Integrated Security=SSPI;";
SqlConnection ^myConnection;
myConnection->ConnectionString = myConnectionString;
Any words of wisdom?