Make a query to different database?

Hello:
I want make a query to different database, but that query
must be a transation, the problem is that I have common
data in one database and other database that utils the
common database, but I dont add some information in the
one data base without check first the common database, to
check existing data on creation and enforce relatioshipd
for replication and so on.
Best Regards.
Owen.Owen
I don't actually see a question here?
If you are getting at how do you tell the difference when
you have the same tables in different databases, you need
to give it a table name that includes the database. You
need to do this anyway if you are accessing multiple
databases even if they are on the same server. (You should
also include table owner.)
Select * from mydatabase.dbo.mytable
Hope this helps
John

Make a Common Color Palette

What would be the best approach for having all the reports share a color palette.

What i want to achieve is that when we want to change for example the color of our column header i somewhere change a value and all reports are modified. That somewhere might be a config file, a sql table, a registerentry, ....

I know i could change all rdl files but that's nog a approach i want to develop.

Kinds Regards

Sorry, never checked the <expression> possibility.

I mean, i know the option but never thought that even color had this option. Great.

|||

Btw, you may find the following article useful: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/MoreSSRSCharts.asp

It also contains an example about using custom color palettes.

-- Robert

Majority Node Set SQL cluster Or ?

S it possible to set up SQL cluster like MNS, without having common share
drives ? or without vendor specific solution.
Target is to have high-availability, but have no SAN or share SCSI drives
available.
I can set up mirroring, at the moment these is the only solution that I
thing is possible. Both servers are in same location.
MNS only removes the need for a shared Quorum Disk, you still need disks for
your SQL data to be shared disks
"Mr.B" <MrB@.discussions.microsoft.com> wrote in message
news:39BE540E-15FA-4CB9-811D-2B1279B0CA61@.microsoft.com...
> S it possible to set up SQL cluster like MNS, without having common share
> drives ? or without vendor specific solution.
> Target is to have high-availability, but have no SAN or share SCSI drives
> available.
> I can set up mirroring, at the moment these is the only solution that I
> thing is possible. Both servers are in same location.
>
|||Thank you. I will set up miroring.
"Edwin vMierlo [MVP]" wrote:

> MNS only removes the need for a shared Quorum Disk, you still need disks for
> your SQL data to be shared disks
>
> "Mr.B" <MrB@.discussions.microsoft.com> wrote in message
> news:39BE540E-15FA-4CB9-811D-2B1279B0CA61@.microsoft.com...
>
>