SQL Server Express Books Online
Dec 1, 2007
are a mess, reminiscent of the structurless "goto" programming of days past. One of you brainiacs need to erect a "real" getting started section, with procedural steps on how a first time user can successfully download, install, and use SQL Server Express. Not all of us are working in corporations where the guy in the next cubicle can answer questions for newbies.
I will try once again, nicely, to ask a question about installing SQL Server Express Edition SP2 onto a Windows Vista machine. That drama will take place in another post.
View 1 Replies
ADVERTISEMENT
Jul 16, 2007
Could some body suggest some good books and online resources for:
1. T-SQL Intermediate level/Advanced
2. SQL Server 2005
Thanks a bunch
Csharplearner
View 1 Replies
View Related
May 3, 2008
I am trying to install sql server 2005 books online but I am failing and I am getting this message
"This installation pakage could not be opened.Contact the application vendor to verify that this is a valid windows installer package"
am I doing anything wrong or has the version of books online changed? Do I have to install anything else before installing it? or does my operating system not support it?
Thanks
View 4 Replies
View Related
Nov 6, 2007
I downloaded and tried to install the file "SqlServer2K5_BOL_May2007.msi" and got a message:
"This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package."
Please advise.
View 3 Replies
View Related
Oct 23, 2007
Can some one give me detail instruction to installing the SQL Server 2005 Express Books Online.
I am new to SQL Server and want to install the MS training material.
View 3 Replies
View Related
Jul 20, 2005
Hi,I have been trying to download the latest update to SQL Server BOL forquite some time without any success. I have tried downloading around3-4 times. Every time (size of msi file would be around 25 KB) I try toextract the msi file, I get an error message to the effect that 'it isnot a valid windows installer package'. Has anyone come across thisproblem?Have been trying to download from this URL -http://www.microsoft.com/downloads/...A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=enThanks,Harish*********************************Long way to go before I sleep ..*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Aug 10, 2005
How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
View 13 Replies
View Related
Aug 2, 2002
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
View 1 Replies
View Related
Sep 14, 2006
Dear all
Where can I download Sql Server Books Online for any versions of 6.5 or 6.0 or 4.
thanks
View 1 Replies
View Related
Aug 30, 2006
please provide me the link of books online of sql server.
i've this with my sql server, but un installed. i need this book immiedietly please give me the link
View 3 Replies
View Related
Jul 20, 2005
Hi All,I searched this news group but couldn't find that problem whichis suprising... maybe I'm doing something stupid.I start one of the chm files (books on line help files).I read about a topic. There are links.I click on them. It tells me "Selection is not associated with anytopic. Please try again.". Its ahref link to jscript function:javascript:hhobj_1.Click() but I do not have it and cannot find it.So I have to go between all those chm files hoping to find the topicof my choice.Plus I want to search them all at once.There must be a (smart) and easy way to do this.Please, do you have any suggestions.ThankfullyJimmy Ol' Boy
View 1 Replies
View Related
Mar 30, 2007
Check out the new Books Online search functionality online. The link below provides a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly.
http://search.live.com/macros/sql_server_user_education/booksonline
Please direct your feedback to SQLServerUE@hotmail.com.
View 3 Replies
View Related
Apr 9, 2008
I am trying to go thru the deployment tutorial, but I'm running into some trouble. The two sample packages I need to work with are called DataTransfer.dtsx and LoadXMLData.dtsx found in the samples.
When I examine these packages, they are writing to tables called dbo.HighIncomeCustomers and dbo.OrderDatesByCountryRegion. These tables don't exist in my copy of AdventureWorks database.
Also, when I try to open the Connection Manager for the target tables, I get a message that says, "The specified provider is not suported. Please choose different provider in connection manager."
Is it possible I'm having these issues because I'm working with a different version of the sample packages?
View 4 Replies
View Related
Aug 29, 2006
I just downloaded the SQL Server Express w/ Advanced Services and did not see a specific Books On Line for this edition. I know there is a new SQL Server 2005 BOL - I downloaded this as well, and will use to complement the old SQL Server Express BOL.
I was looking for specific information about the differences between SQL Server Express and the Advanced Services edition. I think the Microsoft sites are pretty vague - why is the advanced services edition better for multiuser applications?
Jane
View 1 Replies
View Related
Nov 3, 2015
We have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.
SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.
[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server
Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books
Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFO [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1
View 5 Replies
View Related
Nov 3, 2000
Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
View 4 Replies
View Related
Apr 7, 2008
Hi,
Can anyone suggest good books on exclusively sql server development..Not for the beginners but at intermediate to advanced level.. Books which gives good understanding on Stored Procedures, Triggers, Cursors, Functions...
View 1 Replies
View Related
Jun 3, 2006
Hi all
i am beginner with sql server 2005
and i need good books for good beginning
i found many books but i dont know which book i chose ...
what is the books you advice me to read for stability begnning ??
thank you
View 4 Replies
View Related
Sep 26, 2006
Can anyone make some good book recommendations for SQLServer2000 other than the Microsoft BOL?
Thanks
View 11 Replies
View Related
Aug 17, 2006
Hi,
I am trying to determine a couple of books that will help me understand SQL Server 2005 from a few of perspectives:
Optimizing databases, specifically from SQL 2000 - I have a recommended book Pro SQL Server 2005 Database Design and Optimization
Developing SQL Server 2005 based applications using VIsual Studio 2005 and .NET 2.0 - I have been unable to narrow down to a specific book here. I learn best by example, so I was hoping for a book that basically goes through implementing a "real world" project from scratch to finish. I am going to be using the full-blown enterprise edition of SQL 2005, not the Express Edition; but a book that uses the Express Edition trumps any other book, I would be open to it. Any suggestions on such a book?
Understanding T-SQL and Stored Procedures from a SQL Server 2005 perspective -- Any suggestions? A book that spells out the differences from SQL 2000 would be an added advantage.
Thanks.
View 4 Replies
View Related
Nov 6, 2006
There are between 10 and 15 books in the set. I recall an index, developer's book, administrator's book, and two T-SQL reference books. I don't remember what the other books were. Does this sound familiar to anyone? I had these books at my disposal at my last place of employment and I'm trying to get the same books here. If this sounds familiar to anyone, can you point me in the right direction?
Thanks
View 3 Replies
View Related
Oct 19, 2004
Hi,
I am new in this dbforums. i working on SQL SERVER REPLICATION. I need some books related to only SQL SERVER REPLICATION. If any body konwn then reply me
View 1 Replies
View Related
May 11, 2004
Hi All,
Can anybody list out good books for Sql server 2000 Database Administration for a beginer level to the expert.
And also the good resource /sites/forums for learning ,administering and for certification. Which is the best way to busy and where???
I am an oracle //informix DBA
Thx in Advance
Kpai
View 2 Replies
View Related
Sep 8, 2006
dear friends please provide me some free downloadable books for sql server DBA's.
i tried i google. but not got any book to download.
View 1 Replies
View Related
Dec 22, 2007
Hi,
Can anyone suggest me good books for learning sql server development ie stored procedures etc..
View 1 Replies
View Related
Feb 22, 2008
Can you guys pls suggest Good books on SQL Server 2005 ??
Thx
View 7 Replies
View Related
Mar 18, 2007
Windows 2003 Server x64, SP1SQL Server 2005 x64, SP2Installed Books Online Feb 2007.
Error displayed when launching Books Online:
'Microsoft Document Explorer cannot be shown because the
specified help collection 'ms-help://MS.SQLCC.v9' is
invalid.'
Work-around detailed in KB here (http://support.microsoft.com/kb/913392/en-us) does not work.
Un-installing Feb 2007 BOL and installing original makes no difference.
Help!
View 3 Replies
View Related
Nov 24, 2004
My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Thanks in advance,
John
View 4 Replies
View Related
Jun 5, 2003
Hi,
I am an Oracle DBA with over 7 yrs of experience.I am new to sql server 2000 and am given the responsibility of sql server 2000 production databases in a few weeks.I already have the sql server 2000 DBA survival guide.
I would like to know if there are any good books out there for
a)backup and recovery
b)General DBA tasks
c)Performance tuning.
Thanks,
Copernicus
View 4 Replies
View Related
Jul 18, 2007
Hi, here is my problem
I am trying to conncet to an SQL Server that is on the net. The name of the server looks like : sqlServer.TheCompanyOwingIt.Com and it listens to port 2433
I am opening enterprise manager and trying to connect ,giving the name of the server and the credentials but no luck. I also tried opening hte client Network utility , created an alias for that server, specifying 2433 as the port but no luck again. Finally i tried to change the port of my sql server to be 2433 (instead of 1433), no luck again !!! Any ideas ? (there is no firewall running on the PC, but there is a router which might (?) cause the problem ? (i tried to port forward 2433 , but i am not sure if i did it correctly).
Any ideas, suggestions will be greatly appreciated
Thx in advance
Theodore
View 5 Replies
View Related
Apr 18, 2008
I am not new to the SQL Server world, but am somewhat new to the SQL Server 2005 world. I am just getting into the reporting tool. By just messing around for about an hour or so, I was able to get what I wanted somewhat. Basically, I'd like to get up to speed on the reporting side of things fairly quickly. So I am looking at some books, and was wondering if anyone had any suggestions on any.
Here is a few that caught my eye:
-MS SQL Server 2005 Reporting Services by Brian Larson
-MS SQL Server 2005 Reporting Services for Dummies
-Professional SQL Server 2005 Reporting Services by Paul Turley
-The Rational Guide to SQL Server Reporting Services
I am thinking the 1st two would probably be my best bet, but wanted to get you folks suggestions.
Let me know as soon as you can as I am planning on going to the book store tonight or this weekend.
Thanks in Advance!!!
Tony
View 2 Replies
View Related
Mar 7, 2006
Hi All, first post.
I have done a bit of searching around and cant find a clear answer to this question.
Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)
It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.
The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.
This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.
Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.
So the only thing that would change would be a new connection string in the application preferences?
Or am I living in a dream world, because nothing is ever that simple.
One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.
Thanks for any advise you can give.
Mark
View 2 Replies
View Related
Jun 5, 2006
HiI am trying to connect an application to a remote sql server database, however it does not appear to eb configured for remote connections. Does anyone know a connection string of a database I can connect to , soem sort of learnsers database sort of idea ?Thank you.
View 1 Replies
View Related
