SQL Server Books Online January 2004 Update

Jul 20, 2005

Hi,

I have been trying to download the latest update to SQL Server BOL for
quite some time without any success. I have tried downloading around
3-4 times. Every time (size of msi file would be around 25 KB) I try to
extract the msi file, I get an error message to the effect that 'it is
not a valid windows installer package'. Has anyone come across this
problem?

Have been trying to download from this URL -

http://www.microsoft.com/downloads/...A6F79CB1-A420-4
45F-8A4B-BD77A7DA194B&displaylang=en

Thanks,

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


ADVERTISEMENT

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 View Related

Books/Online Resources For SQL Server 2005?

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

Installing Sql Server 2005 Books Online

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

SQL Server 2005 Books Online (May 2007)

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

SQL Server 2005 Books Online - How To Install?

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

Books Online

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

Online Books / Tutorials

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

Books Online Downloads For Ver 6.5/6.0/4

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

Books Online Download Link Please

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

Books OnLine (chm Files) Problem

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

New Books Online Search Functionality On MSDN...

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

Trouble Going Thru The Deployment Tutorial In Books Online

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

Recovery :: Server Cluster Resource Fails To Come Online And Pending Online State

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

SQL Server 2008 :: Add New Calendar Columns (January To December) To Existing Query?

Apr 8, 2015

I have a requirement to add new calendar columns from Jan to Dec in an existing SSRS report based on certain conditions.

The report uses a simple query at the moment.

SELECT [PROJECT ID]
,[PROJECT]
,[STATUS]
,[ACTUAL START]
,[ESTIMATED END]
FROM Projects

The requirement to add the new calendar columns is based on the following conditions:

1. If the Status value is “2” then for each Month in the current year, shade in green for the particular current month

For example, if for a particular Project for month/year of April 2015

Year/Month(Actual Start date) is < = April 2015

and Year/Month(Estimate End date) > = April 2015, then April should be shaded green.

2. The logic needs to be repeated from each month in the current year.

3. Some Estimate and Actual dates run from previous year, or into next year, so year also needs to be taken into consideration.

find the DDL and sample data below.

CREATE TABLE [dbo].[Projects](
[PROJECT ID] [nvarchar](255) NULL,
[PROJECT] [nvarchar](255) NULL,
[STATUS] [nvarchar](255) NULL,
[ACTUAL START] [datetime] NULL,
[ESTIMATED END] [datetime] NULL
) ON [PRIMARY]

insert into Projects

values('1','TFD','2','2015-01-31 00:00:00.000','2015-12-31 00:00:00.000')
insert into Projects
values('2','JUH','1','2015-02-01 00:00:00.000','2015-02-27 00:00:00.000')
insert into Projects
values('3','REFFD','2','2015-01-31 00:00:00.000','2015-11-30 00:00:00.000')

[code].....

how to rewrite the existing query to add new calendar columns in the report and then in the SSRS output shade green based on the above condition.

View 3 Replies View Related

SQL Server 2005 Named Instance Through An ISA Server 2004

Jun 25, 2007

Hi, I'm trying to publish an SQL Server Instance through an ISA Server but I'm not being able. I tried to create the rules to allow the SQL protocols and to tunnel the calls from internet into my SQL server. I set the instance to connect through a fix port so it wouldn't worry about not being the default instance and configured that port in the ISA server so the remote calls were channeled into it. I'm allowing only TCP connections.
 I must be pretty wrong on something because it doesn't work.
Can someone offer me a white paper or some step by step instructions to do this?
 Thanks a lot.

View 7 Replies View Related

Online Index Rebuild And Update Statistics

Dec 12, 2006

Hi ..

Please advice whether i have to do update statistics along with Index rebuild (online /off line)

Thanks in advance

View 3 Replies View Related

Off Topic: Paul OOF Until January

Dec 13, 2006

It's been pretty quiet here recently - hopefully people either aren't experiencing corruptions or they're finding what they need in the previous threads.

Just a quick note to say that I'll be totally offline from tomorrow until January - going diving in Indonesia (http://www.wakatobi.com).

Happy holidays and may your pagers be silent throughout

Cheers

Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

View 4 Replies View Related

Tech-Ed 2004 - San Diego

Apr 20, 2004

Something happened, they are sending me to this conf on May 23-28. This is the first conference since 1999 that I would be attending. Personally I consider this to be the best conference, and I can attend it every day. But it would be interesting to see some of you. Anybody else going?

View 2 Replies View Related

Date Convert Error 2004-05-13 24:00:00.000

May 27, 2004

Hi,
I importing data from db2 into sql
using openquery
In some case I have problem with date

example
DB2 date = '2004-05-13 24:00:00.000000'

I tried to convert it manually

sql server
select cast('2004-05-13 24:00:00.000'as datetime)

Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

do I have to substruct - 1 millisecond ?

View 1 Replies View Related

Biztalk 2004, One Stored Procedure For 2 Tables

Dec 15, 2006

Hi,

I have an orchestration that recieves a pricelist flat file and it must insert into 2 tables - article, articlePrice(for each LotSize) into sql server using a sql adapter. I also want it to check if a record exists for that lotSize and update it if it does. The records are indentified with a uniqueidentifier. So I have 3 if statements:
1 - if (<the article does not exist(checks SupplierArticleNumber)>)
<insert a record into article table>
<insert a record into articlePrice table>

2 - else if(<the article exists but not for that lotSize>)
<insert a new record in articlePrice table>)

3 - else
update the corresponding ArticlePrice row.


My problem is in writing the sp, first it checks if the article exists, if it does then it creates a row in the article table and then one into the articlePrice table. My question is how do I get a hold on the "articleGUID"(pk - uniqueidentifier) that was created on the first table on insertion in order to create the row in the second table(fk)?

And is this possible with one stored procedure? If not does anyone know in Biztalk what other way to do this?

I am new to both Biztalk and sql, so I don't really know what I am doing? I would really appreciate any suggestions!

pp

View 2 Replies View Related

Can We Make Conversion Of Character Data As Like January/ February Like Into Codes By Use Of SSIS ?

Mar 7, 2008



Hello Friends......I have to do the folowing transformation in SSIS:

I have a table in which I have colums of Month and details of sells in that month.

Now I want to make a packege which converts the data of Month column into code columns or numeric values insted of characters .

So how can I do this by using SSIS ?

View 4 Replies View Related

Books - For SQL Server 7.0 DTS

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

Books On Sql Server Development

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

Books For Sql Server 2005

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

Good SQL Server Books

Sep 26, 2006

Can anyone make some good book recommendations for SQLServer2000 other than the Microsoft BOL?
Thanks

View 11 Replies View Related

Best SQL Server 2005 Books

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

SQL Server 2000 Reference Books

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

Finding Books For SQL SERVER Replication

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

Sql Server 2000 Administration Books

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

Sql Server Free Download Books

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

Books For Sql Server Development Beginners

Dec 22, 2007

Hi,

Can anyone suggest me good books for learning sql server development ie stored procedures etc..

View 1 Replies View Related

Good Books On SQL Server 2005

Feb 22, 2008

Can you guys pls suggest Good books on SQL Server 2005 ??

Thx

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved