Is it possible to make "proxy tables" win SQL-server 2000?

Hello
I am coming from Sybase and are learning SQL-Server now.
In Sybase there is a feature called "proxy table" which makes it possible to create a proxy table that really exists in another database. But it appears a ordinary local table to a user. Does a similar feature exists in SQL-server? Anyone knows?
Thanks
Per
Per,
No, but you can fully qualify the object in the other database to access
it. i.e.
select * from database2.dbo.objectname
You will need the appropriate permissions on the other object.
You may also wish to look at cross-database ownership chaining in the
updated Books online available from www.microsoft.com/sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Per wrote:
> Hello
> I am coming from Sybase and are learning SQL-Server now.
> In Sybase there is a feature called "proxy table" which makes it possible to create a proxy table that really exists in another database. But it appears a ordinary local table to a user. Does a similar feature exists in SQL-server? Anyone knows?
> Thanks
> Per
|||Hi
To add to Marks post...you can also create a view in the "current" database.
That would mean that the three part name is only require in the view
definition.
John
"Per" <anonymous@.discussions.microsoft.com> wrote in message
news:CD9FFDA6-BCE1-4D83-8960-1D612462424D@.microsoft.com...
> Hello
> I am coming from Sybase and are learning SQL-Server now.
> In Sybase there is a feature called "proxy table" which makes it possible
to create a proxy table that really exists in another database. But it
appears a ordinary local table to a user. Does a similar feature exists in
SQL-server? Anyone knows?
> Thanks
> Per

Is it possible to make "proxy tables" win SQL-server 2000?

Hello
I am coming from Sybase and are learning SQL-Server now.
In Sybase there is a feature called "proxy table" which makes it possible to
create a proxy table that really exists in another database. But it appears
a ordinary local table to a user. Does a similar feature exists in SQL-serv
er? Anyone knows?
Thanks
PerPer,
No, but you can fully qualify the object in the other database to access
it. i.e.
select * from database2.dbo.objectname
You will need the appropriate permissions on the other object.
You may also wish to look at cross-database ownership chaining in the
updated Books online available from www.microsoft.com/sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Per wrote:
> Hello
> I am coming from Sybase and are learning SQL-Server now.
> In Sybase there is a feature called "proxy table" which makes it possible
to create a proxy table that really exists in another database. But it appea
rs a ordinary local table to a user. Does a similar feature exists in SQL-se
rver? Anyone knows?
> Thanks
> Per|||Hi
To add to Marks post...you can also create a view in the "current" database.
That would mean that the three part name is only require in the view
definition.
John
"Per" <anonymous@.discussions.microsoft.com> wrote in message
news:CD9FFDA6-BCE1-4D83-8960-1D612462424D@.microsoft.com...
> Hello
> I am coming from Sybase and are learning SQL-Server now.
> In Sybase there is a feature called "proxy table" which makes it possible
to create a proxy table that really exists in another database. But it
appears a ordinary local table to a user. Does a similar feature exists in
SQL-server? Anyone knows?
> Thanks
> Per

Is it possible to build a cluster with two independent sets of hard drives on each server

Hi,
I have two identical servers. I want to put Win 2003 Enterprise and SQL
Server Enterprise on both of them.
The data will be written to and read from the database.
Is it possible to build a cluster with two independent sets of hard drives
on each server (Server1 with his own hard drives in Raid1, and Server2 with
its own hard drives in Raid1)? As I mentioned the data will be written into
the database continuously. I wanted to check that with you guys because I
have looked into some books about clustering and the only configuration
picures I saw were with a shared array of hard drives between cluster nodes.
Thank you for your help.
"Jason Robertson" <jason6869@.msn.com> wrote in message
news:Dqadney4k-V_6ubcRVn-sg@.comcast.com...
> Hi,
> I have two identical servers. I want to put Win 2003 Enterprise and SQL
> Server Enterprise on both of them.
> The data will be written to and read from the database.
> Is it possible to build a cluster with two independent sets of hard drives
No.

> on each server (Server1 with his own hard drives in Raid1, and Server2
with
> its own hard drives in Raid1)? As I mentioned the data will be written
into
> the database continuously. I wanted to check that with you guys because I
> have looked into some books about clustering and the only configuration
> picures I saw were with a shared array of hard drives between cluster
nodes.
> Thank you for your help.
>
>

Is Cr Rpt 4.6 compatible with Win XP?

Hi
I have a simple , but a very crucial question for us.
Is Crystal Report 4.6 compatible with Windows XP Operating System?
Thanks.
RobertI have reports that have been designed using crystal report 4.5, yet they are opening in Windows XP professional edition.