Multi Table Query

Does anyone know how to create a query using tables from different sql server database's? looking for the simplest solution.

I have two databases in sql server. Both are in the same "server registration"
How do i reference a table in another database?

Do i do something like this?

SELECT Database1.Table1.Fields, Database2.Table1.Fields
FROM Database1.table1.PKField INNER JOIN Database2.table1.FKField;You may try this

SELECT Database1.dbo.Table1.Fields,
Database2.dbo.Table1.Fields FROM
Database1.dbo.table1.PKField INNER JOIN
Database2.dbo.table1.FKField|||you might also want to look at the OPENQUERY funtion. buddu's suggestion will work but you can generate a buch of unwanted I/O if the table on the remote server is big.|||You only need to do the full naming convension in the FROM clause

SELECT x.column1,
x.column2,
y.column1,
y.column3
FROM database1.dbo.tableX x
JOIN database2.dbo.tabley y
ON x.pk = y.pk|||can anyone help me please...
what query/syntax could i use for retrieving fields from various tables in Access for my one FORM.?
Ive tried using every possible codes but then it didn't work out.
SHould i declare diffrent recordsets for accesing this?

Multi Page Report

Hi All,
I have two tables in a SQL 2000 database. One table contains a few text
fields and the other contains any overflow data from the original table.
I am required to print a one page report with the data from the first table
and then if there are any data in the overflow table, to automatically print
a second page containing the data from the second table.
Page 2 of the report doesn't look anything like page 1. It's layout is
different and it only contains the data from the second table.
These text fields (in the overflow) may be a max of 10K.
I'm new to RS and this requirement has been beating me up.
Any ideas?
Thanks.Two options. You can use either multiple datasets and put a page break
between them or you can use a sub report. Again with a page break between
them.
Bruce L-C
"brawtaman" <brawtaman@.discussions.microsoft.com> wrote in message
news:20F24200-5B1D-449F-BA9D-E9AD48C2B5B4@.microsoft.com...
> Hi All,
> I have two tables in a SQL 2000 database. One table contains a few text
> fields and the other contains any overflow data from the original table.
> I am required to print a one page report with the data from the first
> table
> and then if there are any data in the overflow table, to automatically
> print
> a second page containing the data from the second table.
> Page 2 of the report doesn't look anything like page 1. It's layout is
> different and it only contains the data from the second table.
> These text fields (in the overflow) may be a max of 10K.
> I'm new to RS and this requirement has been beating me up.
> Any ideas?
> Thanks.|||Thanks.
We actually started looking at the Sub-Report option.
Thanks for your help.
"Bruce Loehle-Conger" wrote:
> Two options. You can use either multiple datasets and put a page break
> between them or you can use a sub report. Again with a page break between
> them.
> Bruce L-C
> "brawtaman" <brawtaman@.discussions.microsoft.com> wrote in message
> news:20F24200-5B1D-449F-BA9D-E9AD48C2B5B4@.microsoft.com...
> > Hi All,
> >
> > I have two tables in a SQL 2000 database. One table contains a few text
> > fields and the other contains any overflow data from the original table.
> >
> > I am required to print a one page report with the data from the first
> > table
> > and then if there are any data in the overflow table, to automatically
> > print
> > a second page containing the data from the second table.
> >
> > Page 2 of the report doesn't look anything like page 1. It's layout is
> > different and it only contains the data from the second table.
> >
> > These text fields (in the overflow) may be a max of 10K.
> >
> > I'm new to RS and this requirement has been beating me up.
> >
> > Any ideas?
> >
> > Thanks.
>
>

Multi Indexes - One Column

I ran accross something I had not seen before on a MSSQL 2000 db today. All
of the tables had a PK and an index for the PK. In addition there was also
created another Clustered Index on the same PK column. As I have never seen
this before I dropped all existing indexes and put a single Clustered Index
in place on the PK columns. Currently I am wondering if this double index is
something that may have caused some performance issues? All is working great
with the single clustered index.
Thanks, KimHi Kim
The Northwind database has some similar duplicate indexes. Usually, it is
not a good thing. Sometimes it doesn't hurt anything, but if you do a lot of
updates, all those indexes need to be updated along with the data, so it can
actually hurt performance. (Inserts and deletes could have similar
performance issues.)
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kman" <kman@.toocoolwebs.com> wrote in message
news:OPtQroA1DHA.2156@.TK2MSFTNGP12.phx.gbl...
> I ran accross something I had not seen before on a MSSQL 2000 db today.
All
> of the tables had a PK and an index for the PK. In addition there was also
> created another Clustered Index on the same PK column. As I have never
seen
> this before I dropped all existing indexes and put a single Clustered
Index
> in place on the PK columns. Currently I am wondering if this double index
is
> something that may have caused some performance issues? All is working
great
> with the single clustered index.
> Thanks, Kim
>||||
| I ran accross something I had not seen before on a MSSQL 2000 db today.
All
| of the tables had a PK and an index for the PK. In addition there was also
| created another Clustered Index on the same PK column. As I have never
seen
| this before I dropped all existing indexes and put a single Clustered
Index
| in place on the PK columns. Currently I am wondering if this double index
is
| something that may have caused some performance issues? All is working
great
| with the single clustered index.
--
Generally you should avoid duplication of indexes to avoid performance
degradation during updates.
--
Eric Cárdenas
SQL Server support|||Thank you Kalen and Eric
Regards,
Kim (Kman)|||If you join by the PK a lot in your queries it would be faster for the
queries to use a non-clustered index for the joining instead of the
clustered index as simply more entries could be stored in the pages of the
NCI. As the others have pointed out this would slow down your
updates/inserts but if you do join to this table a lot and on that column,
it might behoove you to keep a seemingly-redundant index.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Kman" <kman@.toocoolwebs.com> wrote in message
news:OPtQroA1DHA.2156@.TK2MSFTNGP12.phx.gbl...
> I ran accross something I had not seen before on a MSSQL 2000 db today.
All
> of the tables had a PK and an index for the PK. In addition there was also
> created another Clustered Index on the same PK column. As I have never
seen
> this before I dropped all existing indexes and put a single Clustered
Index
> in place on the PK columns. Currently I am wondering if this double index
is
> something that may have caused some performance issues? All is working
great
> with the single clustered index.
> Thanks, Kim
>|||"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:eg%23KeXE1DHA.2180@.TK2MSFTNGP12.phx.gbl...
> If you join by the PK a lot in your queries it would be faster for the
> queries to use a non-clustered index for the joining instead of the
> clustered index as simply more entries could be stored in the pages of the
> NCI. As the others have pointed out this would slow down your
> updates/inserts but if you do join to this table a lot and on that column,
> it might behoove you to keep a seemingly-redundant index.
>
Interesting - so for a table that does a lot of joins, you're saying that
having a NCI on the PK would actually produce faster results?
How much faster (or is that a how long is a piece of string type question) ?|||Best way to test is use the command "set statistics IO on"
Run the query with only the clustered index, look at the logical IO (which
is not the number of pages hit but the number of times a hit occurred to a
page)
Place a non-clustered index on the PK column, re-run the query and look at
the new logical IO. If you are only needing the PK in your query it would be
faster to hit the NCI data pages as they are more compact. If your query
looks for multiple columns from the PK table, it may be more sensible for
SQL to only hit the clustered index and ignore your NCI...so, it all depends
on how your queries are.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Dan Boylett" <parc_erom@.crossdata.co.uk> wrote in message
news:ufeOGGF1DHA.484@.TK2MSFTNGP10.phx.gbl...
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:eg%23KeXE1DHA.2180@.TK2MSFTNGP12.phx.gbl...
> > If you join by the PK a lot in your queries it would be faster for the
> > queries to use a non-clustered index for the joining instead of the
> > clustered index as simply more entries could be stored in the pages of
the
> > NCI. As the others have pointed out this would slow down your
> > updates/inserts but if you do join to this table a lot and on that
column,
> > it might behoove you to keep a seemingly-redundant index.
> >
> Interesting - so for a table that does a lot of joins, you're saying that
> having a NCI on the PK would actually produce faster results?
> How much faster (or is that a how long is a piece of string type question)
?
>
>|||Hi Ray
This would only be true if the join was a SEMI-join, checking for existence
in of matching rows in the inner table. If you were doing a true inner join,
and you needed data from the matching rows, a clustered index would be a
better choice.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:eg#KeXE1DHA.2180@.TK2MSFTNGP12.phx.gbl...
> If you join by the PK a lot in your queries it would be faster for the
> queries to use a non-clustered index for the joining instead of the
> clustered index as simply more entries could be stored in the pages of the
> NCI. As the others have pointed out this would slow down your
> updates/inserts but if you do join to this table a lot and on that column,
> it might behoove you to keep a seemingly-redundant index.
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Kman" <kman@.toocoolwebs.com> wrote in message
> news:OPtQroA1DHA.2156@.TK2MSFTNGP12.phx.gbl...
> > I ran accross something I had not seen before on a MSSQL 2000 db today.
> All
> > of the tables had a PK and an index for the PK. In addition there was
also
> > created another Clustered Index on the same PK column. As I have never
> seen
> > this before I dropped all existing indexes and put a single Clustered
> Index
> > in place on the PK columns. Currently I am wondering if this double
index
> is
> > something that may have caused some performance issues? All is working
> great
> > with the single clustered index.
> >
> > Thanks, Kim
> >
> >
>|||Kalen, I agree with you, not too many cases where you would really use that
scenario of duplicate indexes, with a clustered index already on the PK, it
would make more sense to have a NCI on a column that you might pull from the
table, which of course would include the clustered key already that you
could join on.
Thanks!
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:evf2SfJ1DHA.1916@.TK2MSFTNGP10.phx.gbl...
> Hi Ray
> This would only be true if the join was a SEMI-join, checking for
existence
> in of matching rows in the inner table. If you were doing a true inner
join,
> and you needed data from the matching rows, a clustered index would be a
> better choice.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:eg#KeXE1DHA.2180@.TK2MSFTNGP12.phx.gbl...
> > If you join by the PK a lot in your queries it would be faster for the
> > queries to use a non-clustered index for the joining instead of the
> > clustered index as simply more entries could be stored in the pages of
the
> > NCI. As the others have pointed out this would slow down your
> > updates/inserts but if you do join to this table a lot and on that
column,
> > it might behoove you to keep a seemingly-redundant index.
> >
> > HTH
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Kman" <kman@.toocoolwebs.com> wrote in message
> > news:OPtQroA1DHA.2156@.TK2MSFTNGP12.phx.gbl...
> > > I ran accross something I had not seen before on a MSSQL 2000 db
today.
> > All
> > > of the tables had a PK and an index for the PK. In addition there was
> also
> > > created another Clustered Index on the same PK column. As I have never
> > seen
> > > this before I dropped all existing indexes and put a single Clustered
> > Index
> > > in place on the PK columns. Currently I am wondering if this double
> index
> > is
> > > something that may have caused some performance issues? All is working
> > great
> > > with the single clustered index.
> > >
> > > Thanks, Kim
> > >
> > >
> >
> >
>sql

Multi company Application

I'm developing an application that needs to handle several companies data one at a time.

I have a database called ROOT with the common tables like companies, users, etc. and all the stored procedures that I need.

Then I have a unique database per company containing all their info.

How can I apply the stored procedures that I have on database ROOT to the tables on each company's databases ?

The TSQL USE command do not accept variables.

Thanks for your help,
MOsheOoh. I'd use one database and then put a company ID on everything. Other than that, I think you would have to use dynamic SQL for everything and use full object names database.owner.object. That would get to be a real pain. It'll also wreak havoc with permissisons since the execute permissions for the stored procedure won't allow you to access those objects unless the user has permissisons on the underlying objects themselves. Unless you're bound to multiple databases, I'd change that.|||Select * From [DataBaseName].[dbo].[TableName]sql

Mulitple Update in mYSQL

I need to write a query to update two mysql tables simultaneously ie:
i have two tables:
Table1 and Table2.
and each of the these tables have a realting field... So i tried writing a update query this way.

Update TABLE1,TABLE2 SET TABLE1.field1 = 'aaaa' , TABLE2.field1='bbb' Where TABLE1.field2 = 12 and TABLE1.field1=TABLE2.field1

But this query showed me an error.. i can do this breaking into 2 queries, but i want it to be done in one single go... any idea on this??

Thanking you in advance..Originally posted by nikks525
I need to write a query to update two mysql tables simultaneously ie:
i have two tables:
Table1 and Table2.
and each of the these tables have a realting field... So i tried writing a update query this way.

Update TABLE1,TABLE2 SET TABLE1.field1 = 'aaaa' , TABLE2.field1='bbb' Where TABLE1.field2 = 12 and TABLE1.field1=TABLE2.field1

But this query showed me an error.. i can do this breaking into 2 queries, but i want it to be done in one single go... any idea on this??

Thanking you in advance..
I don't use MySQL but updating 2 tables in one statement is not allowed generally in SQL. One way to achieve something like it (in Oracle at least) is to create a view for the join query with an INSTEAD OF UPDATE trigger. So the user can update one view, and the trigger actually updates 2 tables. I don't know if MySQL supports INSTEAD OF triggers, though.

Why do you want to do it anyway? Is it just a covenience issue or do you have some other reason for not wanting to perform 2 updates?|||I just noticed this before replying to the same thread in the MySQL forum. Simple answer; to the best of my knowledge, you can't. It's not valid SQL. And to extend my learned chum andrewst's comments, MySQL doesn't support triggers or views so no go there I'm afraid.

I'm also intrigued as to why you need to do this?|||I just wanted to do a easy job with writing the update in a single query.. rather than 2 different queries..
yea i think it needs to be broken up into 2 different Queries ..

anyway thanks for your replies ..|||Originally posted by andrewst
I don't use MySQL but updating 2 tables in one statement is not allowed generally in SQL. One way to achieve something like it (in Oracle at least) is to create a view for the join query with an INSTEAD OF UPDATE trigger. So the user can update one view, and the trigger actually updates 2 tables. I don't know if MySQL supports INSTEAD OF triggers, though.

Why do you want to do it anyway? Is it just a covenience issue or do you have some other reason for not wanting to perform 2 updates?

CAN U PLEASE LET ME KNOW HOW TO CREATE VIEWS IN MYSQL TO UPDATE 2 TABLES IN MYSQL|||No need to shout :p

It's been a while since I checked up with developments over at MySQL AB but (see my post above) as far as I know, you can't. No triggers, no updateable views and transaction support only in certain table types.

Why can't you fire off two update statements?

(caveat: I'm quite happy to have my comments above proven wrong by someone more up-to-date on the latest MySQL releases)

Mulitple Joins and Nulls

I am trying to join two tables on multiple fields. But the nulls aren't considered a match so they aren't included in the results set.

Select A.Lot, A.Block, A.Plan, B.Key

from A join B on

A.Lot=B.Lot

A.Block=B.Block

A.Plan=B.Plan

In the data, there can be an instance where Block is null in both tables so it "matches" but not in SQL. How do I get the "matched" nulls to be returned as well?

You can't match on the nulls in the database.|||Try something like this:

Select A.Lot, A.Block, A.Plan, B.KeyFrom Ajoin Bon A.Lot = B.LotAnd A.Plan = B.PlanAnd( (A.BlockIsNull And B.BlockIsNull)Or (A.Block = B.Block))

|||Richard, that worked great. Thanks for the excellent advice.

mulitiple selects in a stored procedure

Hi,
I am trying to create a pagination within a stored procedure but I need
to select from several tables:
First I am inserting the fields into a temp table and this works fine:
INSERT INTO #TempItems (Name)
SELECT Name FROM tblName
I thought I could get data from other tables using UNION:
INSERT INTO #TempItems (Name,Address,Telephone,Street)
SELECT Name FROM tblName
UNION
SELECT Address FROM tblAddress
UNION
SELECT Telephone FROM tblTelephone
UNION
SELECT Street FROM tblStreet
*These are bogus fields I have used as examples.
But the error I get is that the number of insert fields is less then the
select? Could anyone help on how the best way to achieve this?
many thanks in advance
Peter
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!You can google the newsgroups (suggest .programming) for pagination
techniques. Your error is due to a misunderstanding of how union works.
Union merely combines separate result sets into one; you are attempting to
use it (incorrectly) as you would a join. Assuming that a union could be
used, you must specify 4 items within the select list of each select
statement that is part of the union, corresponding to the 4 columns to be
inserted. There are other flaws in your logic, but this should get you
started.
You should be inserting using something like the following
insert ...
select ...
from tblName inner join tblAddress on ...
inner join tblTelephone on ...
inner join tblStreet on ...
where ...
How those joins are made (and their type - inner, outer, cross, etc) I
cannot answer without knowing the relationships between the table.
"Peter Rooney" <peter@.whoba.co.uk> wrote in message
news:OoqGZO3rDHA.2456@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to create a pagination within a stored procedure but I need
> to select from several tables:
> First I am inserting the fields into a temp table and this works fine:
> INSERT INTO #TempItems (Name)
> SELECT Name FROM tblName
> I thought I could get data from other tables using UNION:
> INSERT INTO #TempItems (Name,Address,Telephone,Street)
> SELECT Name FROM tblName
> UNION
> SELECT Address FROM tblAddress
> UNION
> SELECT Telephone FROM tblTelephone
> UNION
> SELECT Street FROM tblStreet
> *These are bogus fields I have used as examples.
>
> But the error I get is that the number of insert fields is less then the
> select? Could anyone help on how the best way to achieve this?
> many thanks in advance
> Peter
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!sql

mssql7 to mssql200 transfer tables

I have a table in mssql7 that has 7000000 record and I want to take
100000 records out of it and place them into the new machine with
mssql2000. The new machine will also have the same table name, so I
want to append the 100000 records into that table.

Thanks,
Royal344
--
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.ms-sqlserverroyal344 (royal344.news.invalid@.web2news.net) writes:
> I have a table in mssql7 that has 7000000 record and I want to take
> 100000 records out of it and place them into the new machine with
> mssql2000. The new machine will also have the same table name, so I
> want to append the 100000 records into that table.

Do you want any 100000 rows?

You could use BCP and make use of the options for specifying first and
last row. I don't recall the exact name for these options right, but
you can look up the syntax for BCP in Books Online.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

mssql remote gui

Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
run some basic queries and browse tables for a remote MSSQL database.
I installed the freeware from TOAD, but it screwed up my computer, I
am really looking for something light weight, nothing fancy needed,
for some basic queries and browsing. If I connect to the server I use
the Enterprise Manager, but really didn't want to have to install a
copy of MSSQL on my local machine just to use the Enterprise Manager
if there was a good free GUI.
Thanks
Perhaps http://rac4sql.net/qalite_main.asp ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<trpost@.gmail.com> wrote in message news:1186192697.704881.325630@.i13g2000prf.googlegr oups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
|||In addition to QA lite, have you looked at Management Studio Express
Edition?
Aaron Bertrand
SQL Server MVP
<trpost@.gmail.com> wrote in message
news:1186192697.704881.325630@.i13g2000prf.googlegr oups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
|||Hello trpost@.gmail.com,

> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
When you start the setup of SQL Server youw ill be presented an option to
just install the Client tools & Connectivity. IT should give you just the
tools, not the whole server.
Jesse

mssql remote gui

Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
run some basic queries and browse tables for a remote MSSQL database.
I installed the freeware from TOAD, but it screwed up my computer, I
am really looking for something light weight, nothing fancy needed,
for some basic queries and browsing. If I connect to the server I use
the Enterprise Manager, but really didn't want to have to install a
copy of MSSQL on my local machine just to use the Enterprise Manager
if there was a good free GUI.
ThanksPerhaps http://rac4sql.net/qalite_main.asp ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<trpost@.gmail.com> wrote in message news:1186192697.704881.325630@.i13g2000prf.googlegroups.c
om...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||In addition to QA lite, have you looked at Management Studio Express
Edition?
Aaron Bertrand
SQL Server MVP
<trpost@.gmail.com> wrote in message
news:1186192697.704881.325630@.i13g2000prf.googlegroups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||Hello trpost@.gmail.com,

> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
When you start the setup of SQL Server youw ill be presented an option to
just install the Client tools & Connectivity. IT should give you just the
tools, not the whole server.
Jesse

mssql remote gui

Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
run some basic queries and browse tables for a remote MSSQL database.
I installed the freeware from TOAD, but it screwed up my computer, I
am really looking for something light weight, nothing fancy needed,
for some basic queries and browsing. If I connect to the server I use
the Enterprise Manager, but really didn't want to have to install a
copy of MSSQL on my local machine just to use the Enterprise Manager
if there was a good free GUI.
ThanksPerhaps http://rac4sql.net/qalite_main.asp ?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<trpost@.gmail.com> wrote in message news:1186192697.704881.325630@.i13g2000prf.googlegroups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||In addition to QA lite, have you looked at Management Studio Express
Edition?
--
Aaron Bertrand
SQL Server MVP
<trpost@.gmail.com> wrote in message
news:1186192697.704881.325630@.i13g2000prf.googlegroups.com...
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>|||Hello trpost@.gmail.com,
> Can anyone recommend a FREE Microsoft SQL Server GUI that I can use to
> run some basic queries and browse tables for a remote MSSQL database.
> I installed the freeware from TOAD, but it screwed up my computer, I
> am really looking for something light weight, nothing fancy needed,
> for some basic queries and browsing. If I connect to the server I use
> the Enterprise Manager, but really didn't want to have to install a
> copy of MSSQL on my local machine just to use the Enterprise Manager
> if there was a good free GUI.
> Thanks
>
When you start the setup of SQL Server youw ill be presented an option to
just install the Client tools & Connectivity. IT should give you just the
tools, not the whole server.
Jess