Install RS on SQL2000

I have SQL2000 Developer installed my XP box. Look like I can't put any
except the trial version of RS. Does RS run on SQL Std and Ent only? I
want to play with RS but don't want to install the trial version. Is there
a workaround? Thanks.Hi,
I have SS2000 Developer SP3 AND RS2000 SP2 on my XP SP2 machine with no
problem.
You need to double-check what is the problem with your installation.
Best Regards
Jordi Rambla
SQL Server MVP
Solid Quality Learning
Spain

Install reporting services (not DB) on 2003 Web Edition?

I am looking to deploy reporting services on two serves, one already running
SQL2000 plus an exisitng IIS Server.
The IIS server is running Windows 2003 Web Edition - is installing the
non-DB components of this edition of windows supported - cannot find the
into in the deployment guide!
Any thanks much appreciated.
Ian.Yes.
--
| From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
| Subject: Install reporting services (not DB) on 2003 Web Edition?
| Date: Thu, 28 Jul 2005 16:06:47 +0100
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 217.206.61.36
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am looking to deploy reporting services on two serves, one already
running
| SQL2000 plus an exisitng IIS Server.
|
| The IIS server is running Windows 2003 Web Edition - is installing the
| non-DB components of this edition of windows supported - cannot find the
| into in the deployment guide!
|
| Any thanks much appreciated.
|
| Ian.
|
|
||||http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
This article talks about deployment scenarios.
HTH,
""Brad Syputa - MS"" wrote:
> Yes.
> --
> | From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
> | Subject: Install reporting services (not DB) on 2003 Web Edition?
> | Date: Thu, 28 Jul 2005 16:06:47 +0100
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 217.206.61.36
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I am looking to deploy reporting services on two serves, one already
> running
> | SQL2000 plus an exisitng IIS Server.
> |
> | The IIS server is running Windows 2003 Web Edition - is installing the
> | non-DB components of this edition of windows supported - cannot find the
> | into in the deployment guide!
> |
> | Any thanks much appreciated.
> |
> | Ian.
> |
> |
> |
>

Inserting Record to db1.table from db2.table

Hello!
Can we do this in SQL2000?
Insert into <db1>.<tablename> (fld1,fld2...) Select fld1,fld2 from <db2>.<tablename>
Assuming that these two tables have the same fields but reside different database.
Thanks in advance
bernieinsert into db1.dbo.table select * from db2.dbo.table