Download: SQL Server Management Studio Express

I have an instance of SQL Server 2005 running on a server. I know that Management Studio is available to me on the server through Programs.

What do I need on my client computer used for development to access the instance on the server? Is it as simple as a shortcut to the server Management Studio exe? Do I access it through Internet Explorer? Or what do I have to install on the client to be able to manager the server DB's?

Apparently this must be very easy because I've looked all over and can't find the answer. Thank you in advance.

Use the SQL Server installation CD, and choose the "Install Client Tools" options. At least you'll need to install client connectivity, and if you want the query editor, and other development tools, then you'll need the Management Studio.

I don't think it's just as simple as creating a shortcut link to the management studio EXE file on your server, you're best off installing it properly.|||

installed client components, as per description, client connectivity but there is no management studio only 2 tools: 'Surface Area Configuration' and '...Configueation Manager' - it doesn't realy help!

I'd like to have the management studio on client ... how can I get it?

|||Have a look at the following thread on MSDN's Channel 9. Others were having a similar issue.
http://channel9.msdn.com/ShowPost.aspx?PostID=142941

It appears that you may need to launch it separately from the Tools directory on your installation media.|||the reason: IE6SP1 was absent! after installation I could choose management studio from DVD/TOOLS. Thanks!|||Are the management tools available for Download?|||For the Express edition, you can download it here:
http://msdn.microsoft.com/vstudio/express/sql/download/

If you're using the Standard/Enterprise/Developer edition, it should be on your installation media (DVD > TOOLS directory)

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

Double left joins with conditions

I have a setup in an Access database with linked tables to Oracle (its a remote application database that is synced when a connection is available). I have to perform inserts, updates, and deletes based upon records that have changed since the last update. In the examples of inserting records into oracle, I find records in access that do not exist in oracle and meet the date condition. Where I run into problems are in tables like [events]: I need to only be updating, inserting, and deleting events for a specific county but the only place county is designated is in the location table that events are tied to through lctn_id. I just can't figure out how to involve the location table join with the events table join and the necessary conditions.

locations (and locations_ora)
lctn_id, cnty_nbr, lctn_nm..., rec_dt

events (and events_ora)
evnt_id, lctn_id, evnt_txt, ..., rec_dt

Example of format used for another table:
INSERT INTO locations_ora SELECT DISTINCTROW a.* FROM locations a LEFT JOIN locations o ON a.lctn_id=o.lctn_id WHERE (o.lctn_id IS NULL) AND a.rec_dt>#8/17/2000 1:11:11 AM# AND a.cnty_nbr=5

How I would like to get events working:
INSERT INTO events_ora SELECT DISTINCTROW a.* FROM events AS a LEFT JOIN events_ora AS o ON a.evnt_id=o.evnt_id WHERE (o.evnt_id IS NULL) AND a.rec_dt>#8/17/2000 1:11:11 AM# AND {some way to only get events tied locations in a specific county}
-- or even --
INSERT INTO events_ora SELECT DISTINCTROW a.* FROM (SELECT a.* FROM events a LEFT JOIN locations l ON b.lctn_id=l.lctn_id WHERE l.cnty_nbr=5 ) LEFT JOIN events_ora o ON a.evnt_id=o.evnt_id WHERE (o.evnt_id IS NULL) AND a.rec_dt>#1/17/1979 1:11:11 AM#
(I thought this one would work but Access blows up on the SELECT after the FROM.)

Can anyone point me in the right direction?INSERT
INTO events_ora
SELECT a.*
FROM (
events a
inner
JOIN locations l
ON (
l.lctn_id = a.lctn_id
and l.cnty_nbr = 5
)
)
LEFT
JOIN events_ora o
ON o.evnt_id = a.evnt_id
WHERE a.rec_dt>#1/17/1979|||The traffic signals of North Carolina thank you immensely!

Seeing how this is done correctly and in the reading I've done on your site (since I figured you would be the likely responder to my thread) has definitely increased my understanding of how to work with SQL. You will now be added to the Whiteboard of Fame in conference room C-011.|||thanks :)

that's the nicest kudos i've received in a while

Dont think Discretization function is necessary on the Analysis Service server in SQL Server 200

Hi, all here,

I am just wondering about the Discretization function available on analysis service server (which can not actually discretize data into user-defined expressions) . Isnt it redundant ? I mean since users can discretize their data more meaningfully based on their own expressions in database engine of SQL Server 2005.

Thanks a lot.

It is helpful in many circumstances. If you want a column discretized into statistically meaningful buckets, but there's no particular business reason for the breakdown, it is very useful. If there are particular business reasons for where the bucket divisions should occur, then you are correct, you should manually discretize apriori.

Eliminating a necessary preprocessing step for algorithms that don't support continuous values makes data mining easier for a wider range of people.