Download SQL Server client tools

Hi.
Despite the indignance of some people, here is the link to download the SQL
Server Client Tools for use with MSDE.
http://download.microsoft.com/downl...SP4-x86-ENU.EXE
I have downloaded MSDE and the Client Tools myself so I know this to be the
case. I came across this page when searching for the client tools for a new
laptop on which I have already installed MSDE.
I do wish that people would not confuse "I don't know how to do something" w
ith "it cannot be done." There's very little in this universe that cannot b
e done
Anyway, in answer to your question, you were half right. The download is on
ly part of SP4 (thankfully) and therefore only weighs about 67MB, and not th
e 240MB total SP size.
I hope this helps. Have fun!
Captain Murphy
All hail the Barbot-Bot!!!
Courtesy of EggHeadCafe.com
Earn money answering messageboard posts at
http://www.eggheadcafe.com/forummerit.aspxI believe most people are looking for ways which are in
compliance with licensing agreements. You need a valid,
legal SQL Server CAL to install the client tools. If someone
does not have this, the methods you are suggesting are not
legal.
The gist of it is explained in the following link:

>Incidentally, if you can't install from the SP4 download, download the SQL
Server 2000 Evaluation and simply install just the Client Tools.
>[url]http://www.microsoft.com/downloads/thankyou.aspx?familyId=D20BA6E1-F44C-4781-A6BB
-F60E02DC1335&displayLang=en" target="_blank">http://sqlserver2000.databases.aspf...&displayLang=en
>It's a bigger download, but has the desired effect.
>Enjoy!
>Captain Murphy
>All hail the Barbot-Bot!!!
>Courtesy of EggHeadCafe.com
>Earn money answering messageboard posts at
>http://www.eggheadcafe.com/forummerit.aspx

Download SQL Server client tools

Hi.
Despite the indignance of some people, here is the link to download the SQL Server Client Tools for use with MSDE.
http://download.microsoft.com/downlo...P4-x86-ENU.EXE
I have downloaded MSDE and the Client Tools myself so I know this to be the case. I came across this page when searching for the client tools for a new laptop on which I have already installed MSDE.
I do wish that people would not confuse "I don't know how to do something" with "it cannot be done." There's very little in this universe that cannot be done
Anyway, in answer to your question, you were half right. The download is only part of SP4 (thankfully) and therefore only weighs about 67MB, and not the 240MB total SP size.
I hope this helps. Have fun!
Captain Murphy
All hail the Barbot-Bot!!!
Courtesy of EggHeadCafe.com
Earn money answering messageboard posts at
http://www.eggheadcafe.com/forummerit.aspx
I believe most people are looking for ways which are in
compliance with licensing agreements. You need a valid,
legal SQL Server CAL to install the client tools. If someone
does not have this, the methods you are suggesting are not
legal.
The gist of it is explained in the following link:
http://sqlserver2000.databases.aspfa...rver/msde.html
The appropriate uses of MSDE is no longer posted on
Microsoft's site since the release of 2005, but the related
Q and A stated:
Q. Can I use SQL Server tools and services in conjunction
with MSDE?
A. You can only use SQL Server tools and services in
conjunction with MSDE if you acquired MSDE through SQL
Server 2000 (Developer Edition, Standard Edition, or
Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server
2000. Visit the How to Buy page for information on obtaining
a valid SQL Server license.
Note: The tools and services included with SQL Server
Developer Edition may not be used to manage production
server environments.
-Sue
On Mon, 02 Oct 2006 13:30:12 -0700, Captain Murphy wrote:

>Incidentally, if you can't install from the SP4 download, download the SQL Server 2000 Evaluation and simply install just the Client Tools.
>http://www.microsoft.com/downloads/t...displayLang=en
>It's a bigger download, but has the desired effect.
>Enjoy!
>Captain Murphy
>All hail the Barbot-Bot!!!
>Courtesy of EggHeadCafe.com
>Earn money answering messageboard posts at
>http://www.eggheadcafe.com/forummerit.aspx

download SQL Server Accelerator for BI

hi
i need the partition aggregation utility for sql server 2000
i found the link at microsoft but the download seems to be moved
http://www.microsoft.com/sql/prodinf...i/default.mspx
any ideas where i can find that tool?
thanks
andreas
Hi
Did you check out the link on
http://support.microsoft.com/default...b;en-us;897350
John
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> hi
> i need the partition aggregation utility for sql server 2000
> i found the link at microsoft but the download seems to be moved
> http://www.microsoft.com/sql/prodinf...i/default.mspx
> any ideas where i can find that tool?
> thanks
> andreas
>
|||yubdidu - yahoo
great, thanks a lot
andreas
"John Bell" schrieb:

> Hi
> Did you check out the link on
> http://support.microsoft.com/default...b;en-us;897350
> John
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
>
>

download SQL Server Accelerator for BI

hi
i need the partition aggregation utility for sql server 2000
i found the link at microsoft but the download seems to be moved
http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/default.mspx
any ideas where i can find that tool?
thanks
andreasHi
Did you check out the link on
http://support.microsoft.com/default.aspx?scid=kb;en-us;897350
John
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> hi
> i need the partition aggregation utility for sql server 2000
> i found the link at microsoft but the download seems to be moved
> http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/default.mspx
> any ideas where i can find that tool?
> thanks
> andreas
>|||yubdidu - yahoo
great, thanks a lot
andreas
"John Bell" schrieb:
> Hi
> Did you check out the link on
> http://support.microsoft.com/default.aspx?scid=kb;en-us;897350
> John
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> > hi
> >
> > i need the partition aggregation utility for sql server 2000
> > i found the link at microsoft but the download seems to be moved
> >
> > http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/default.mspx
> >
> > any ideas where i can find that tool?
> >
> > thanks
> > andreas
> >
>
>

download SQL Server Accelerator for BI

hi
i need the partition aggregation utility for sql server 2000
i found the link at microsoft but the download seems to be moved
http://www.microsoft.com/sql/prodin...bi/default.mspx
any ideas where i can find that tool?
thanks
andreasHi
Did you check out the link on
http://support.microsoft.com/defaul...kb;en-us;897350
John
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
> hi
> i need the partition aggregation utility for sql server 2000
> i found the link at microsoft but the download seems to be moved
> http://www.microsoft.com/sql/prodin...bi/default.mspx
> any ideas where i can find that tool?
> thanks
> andreas
>|||yubdidu - yahoo
great, thanks a lot
andreas
"John Bell" schrieb:

> Hi
> Did you check out the link on
> http://support.microsoft.com/defaul...kb;en-us;897350
> John
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:513A050C-6A59-4515-BDF1-F82A438053F1@.microsoft.com...
>
>sql

Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?

Hi,
I can't seem to find the download link for SQL Server 2000 Reporting
Services from my SQL 2000. Where is it? I feel like an idiot.
--
SpinI don't recall anything other than the Evaluation Edition ever being
downloadable from http://www.microsoft.com but you can find all the SQL
Server 2000 Reporting Services downloads at
http://www.microsoft.com/sql/technologies/reporting/downloads.mspx,
including the Evaluation Edition.
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478crcFeau66U1@.individual.net...
> Hi,
> I can't seem to find the download link for SQL Server 2000 Reporting
> Services from my SQL 2000. Where is it? I feel like an idiot.
> --
> Spin
>

Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?

Hi,
I can't seem to find the download link for SQL Server 2000 Reporting
Services from my SQL 2000. Where is it? I feel like an idiot.
Spin
I don't recall anything other than the Evaluation Edition ever being
downloadable from http://www.microsoft.com but you can find all the SQL
Server 2000 Reporting Services downloads at
http://www.microsoft.com/sql/technol...ownloads.mspx,
including the Evaluation Edition.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478crcFeau66U1@.individual.net...
> Hi,
> I can't seem to find the download link for SQL Server 2000 Reporting
> Services from my SQL 2000. Where is it? I feel like an idiot.
> --
> Spin
>

Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?

Hi,
I can't seem to find the download link for SQL Server 2000 Reporting
Services from my SQL 2000. Where is it? I feel like an idiot.
SpinI don't recall anything other than the Evaluation Edition ever being
downloadable from http://www.microsoft.com but you can find all the SQL
Server 2000 Reporting Services downloads at
http://www.microsoft.com/sql/techno...downloads.mspx,
including the Evaluation Edition.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478crcFeau66U1@.individual.net...
> Hi,
> I can't seem to find the download link for SQL Server 2000 Reporting
> Services from my SQL 2000. Where is it? I feel like an idiot.
> --
> Spin
>sql

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=62b348bb-0458-4203-bb03-8be49e16e6cd&displaylang=en.
Developer edition is available for MSDN subscribers.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARR
Express edition can be downloaded from
http://www.microsoft.com/downloads/d...isplaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/...displaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

Download Link of SQL Express 2005 not working

When I click Download, it show NOT FOUND

What happened ?

Hi,

Download it from http://msdn.microsoft.com/vstudio/express/sql/download/ this link is working properly.

Hemantgiri S. Goswami

Down and dirty database infrastructure

Does any have a link, or know of an MS book(s) that details the
underlying database structure, tables, processes? Something that
explains in detail how/why this stuff is configured and works, like
DDL, TDS, varchar, int, index, tables, normalization, DML, Primary
Key/Foreign key.Beeker (sqlserver2005dba@.gmail.com) writes:
> Does any have a link, or know of an MS book(s) that details the
> underlying database structure, tables, processes? Something that
> explains in detail how/why this stuff is configured and works, like
> DDL, TDS, varchar, int, index, tables, normalization, DML, Primary
> Key/Foreign key.

Sounds like you are looking for "Inside SQL Server 2000" by Kalen
Delaney.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks much.

The review, on Barnes and Nobel (
http://search.barnesandnoble.com/bo...isbn=0735609985
), on her treatment of internals and other vaulable info are very
critical.

Then the Amazon comments praise her.
(
http://www.amazon.com/gp/product/07...406348?n=283155
).

Comment?|||"Beeker" <sqlserver2005dba@.gmail.com> wrote in message
news:1143721430.783394.148200@.t31g2000cwb.googlegr oups.com...
> Thanks much.
> The review, on Barnes and Nobel (
http://search.barnesandnoble.com/bo...isbn=0735609985
> ), on her treatment of internals and other vaulable info are very
> critical.
> Then the Amazon comments praise her.
> (
http://www.amazon.com/gp/product/07...406348?n=283155
> ).
> Comment?

She knows her stuff. Extremely knowledgeable. Get the book.

You want a book on XML, there are definitely better ones.|||Thanks Strider.

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patches
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/d...displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!
Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/d...displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!
|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when trying
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:

> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>
>
|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...[vbcol=seagreen]
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
|||Aha! I see what you mean now. I usually skip that very first section, becuase
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:

> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
>
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patches
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when trying
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:
> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> > I've been trying to download the cumulative hotfix in article 904660
> > (patches
> > to build 8.00.2162). However, the link on the page is not fiding the file
> > to
> > download:
> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> >
> > Does anyone know where I can download the 904660 cumulative patch? Thanks!
>
>|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
>> Hotfix 2162 has been removed.
>> A cumulative hotfix package is available for SQL Server 2000 Service Pack
>> 4
>> build 2162
>> http://support.microsoft.com/kb/904660/en-us
>> CSS (formerly PSS) is working on the replacement hotfix.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
>> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>> > I've been trying to download the cumulative hotfix in article 904660
>> > (patches
>> > to build 8.00.2162). However, the link on the page is not fiding the
>> > file
>> > to
>> > download:
>> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
>> >
>> > Does anyone know where I can download the 904660 cumulative patch?
>> > Thanks!
>>|||Aha! I see what you mean now. I usually skip that very first section, becuase
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:
> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
> > Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> > trying to use. It leads to a page with the following message: "The
> > download
> > you requested is unavailable. If you continue to see this message when
> > trying
> > to access this download, go to the "Search for a Download" area on the
> > Download Center home page." I can't find it anywhere else. I guess I
> > simply
> > need to stop pursuing it.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> Hotfix 2162 has been removed.
> >>
> >> A cumulative hotfix package is available for SQL Server 2000 Service Pack
> >> 4
> >> build 2162
> >> http://support.microsoft.com/kb/904660/en-us
> >>
> >> CSS (formerly PSS) is working on the replacement hotfix.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior Database Administrator
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> >> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> >> > I've been trying to download the cumulative hotfix in article 904660
> >> > (patches
> >> > to build 8.00.2162). However, the link on the page is not fiding the
> >> > file
> >> > to
> >> > download:
> >> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> >> >
> >> > Does anyone know where I can download the 904660 cumulative patch?
> >> > Thanks!
> >>
> >>
> >>
>
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patche
s
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/...&displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/...&displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when tryin
g
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:

> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack
4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>
>|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...[vbcol=seagreen]
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
>|||Aha! I see what you mean now. I usually skip that very first section, becuas
e
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:

> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
>
>

don't select * but...

Read it at this link http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspxthat selection from dropdown is equal to Select * . I agree but how do you not select AS400 library from dropdown? Also i have not see any other place to supply a query other than Execute Sql task .

kushpaw

kushpaw wrote:

Read it at this link http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspxthat selection from dropdown is equal to Select * .

Actually, the point of that blog post was that they are NOT the same.

kushpaw wrote:

I agree but how do you not select AS400 library from dropdown? Also i have not see any other place to supply a query other than Execute Sql task .

kushpaw

In the OLE DB Source you have to choose whether to simply pick a table or supply a query.

-Jamie

|||

Jamie, i was looking for some way if query could be done in a db2 connection and avoid dropdown. Even for sql connection where would you write the query, in a script because i didnot see any such option in propery page or edit option dialog. If you could suggest any link?

many thnx,

kushpaw

|||

kushpaw wrote:

Jamie, i was looking for some way if query could be done in a db2 connection and avoid dropdown. Even for sql connection where would you write the query, in a script because i didnot see any such option in propery page or edit option dialog. If you could suggest any link?

many thnx,

kushpaw

Have you even bothered to look?

Select "SQL Command" from the 'Data Access Mode' dropdown in the OLE DB Source.

-Jamie

Domain Collapse. Sql permission question.

Internally sql server uses SID of NT users to link them
with sql logins. I don't know if NT will preserve SIDs
when users are migrated to another domain. If it does then
users can login with Domain2\user1 and still have same
permissions in sql server based on their SID stored in
sysxlogins table, though their username will be displayed
as Domain1\user1. You can update sysxlogins table and
change users display name.
If users are assigned new SID by NT then I am afraid you
have to add them again and assign permisstions.
hth.

>--Original Message--
>We are in the process of collapsing a domain. How do i
change the database permissions to reflect the new domain
names. Example Domain1\user1 is migrated to Domain2. user1
is now Domain2\user1. In SQL, the user is still displayed
as Domain1\User. Any idea. Thanks in advance.
>.
>When they are migrated to nt the sid stays the same. so the permission shoul
d be ok from your info. Thanks for the help.