Distributed Partioned Views between different SS versions

Can you have a updatable Distributed Partioned Views between SQL
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.
Nevermind, I have tested and confirmed this works.

Distributed Partioned Views between different SS versions

Can you have a updatable Distributed Partioned Views between SQL
Server 2000 and SQL Server 2005 ? The reason I ask is the down time to
upgrade all 2000 sql servers to 2005 at the same time is prohibitive in
our environment.Nevermind, I have tested and confirmed this works.

Distribute Data Securely in SSExpress

I would like to distribute some data in SqlServer Express which only my application can read from.

My question is - is it possible to secure a database so that only a specified user would have read/write permissions. Even the sa acount should not have the permission to read or write to the database although it would retain the right to drop the database.

One option I believe is to encrypt the data but I would prefer not to incur the performance penalty associated with this.

Any insights would be appreciated.

Thanks

This topic has been previously discussed in the following thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=52094&SiteID=1

Thanks
Laurentiu

Distinguish SQLServer and MSDE instances

How can I tell which of the SQLServers listed on the network are
specifically MSDE.
I want to make sure that I have licenses for all the full versions of
SQLServer that are running.
Thanks.
Alan
Issue one of the commands on the servers you want to find that out:
Select @.@.Version
--OR
EXEC master..xp_msver
HTH, Jens Suessmeyer
|||Another command would be to SELECT SERVERPROPERTY('Edition');
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Jens & Alan,
Thanks very much.
Regards,
Alan
"Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
news:Ol87ezb6FHA.3276@.TK2MSFTNGP10.phx.gbl...
> How can I tell which of the SQLServers listed on the network are
> specifically MSDE.
> I want to make sure that I have licenses for all the full versions of
> SQLServer that are running.
> Thanks.
> Alan
>
>

Displaying customer data

Hi all,
I need to design a solution that will display customer data from Sql
Server tables in an Internet Explorer tab of a third party app, e.g. the
third party app has a tab that can display web pages.
The third party app display one customer record at a time. I need to
display Payment Transaction records for the current customer(linked by
CustomerNo field) in the Internet Explorer tab. There are six types of
Payment Transaction records. I need to display all Payment transaction
records for the current customer, the subtotal for each transaction type and
the total ampont for all transactions.
What are the best tools for implementing this solution? Shoule I use
DbNetGrid, Reporting Services, Crystal Reports or any other tool? Please
also point me to any examples on the web or any tutorial.
Thanks in advance.Hi,
Take a look at this page
http://office.microsoft.com/en-gb/a...1153831033.aspx
"helpful sql" <nospam@.stopspam.com> wrote in message
news:uVMSYfaXGHA.3972@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to design a solution that will display customer data from Sql
> Server tables in an Internet Explorer tab of a third party app, e.g. the
> third party app has a tab that can display web pages.
> The third party app display one customer record at a time. I need to
> display Payment Transaction records for the current customer(linked by
> CustomerNo field) in the Internet Explorer tab. There are six types of
> Payment Transaction records. I need to display all Payment transaction
> records for the current customer, the subtotal for each transaction type
> and the total ampont for all transactions.
> What are the best tools for implementing this solution? Shoule I use
> DbNetGrid, Reporting Services, Crystal Reports or any other tool? Please
> also point me to any examples on the web or any tutorial.
> Thanks in advance.
>

Displaying customer data

Hi all,
I need to design a solution that will display customer data from Sql
Server tables in an Internet Explorer tab of a third party app, e.g. the
third party app has a tab that can display web pages.
The third party app display one customer record at a time. I need to
display Payment Transaction records for the current customer(linked by
CustomerNo field) in the Internet Explorer tab. There are six types of
Payment Transaction records. I need to display all Payment transaction
records for the current customer, the subtotal for each transaction type and
the total ampont for all transactions.
What are the best tools for implementing this solution? Shoule I use
DbNetGrid, Reporting Services, Crystal Reports or any other tool? Please
also point me to any examples on the web or any tutorial.
Thanks in advance.Hi,
Take a look at this page
http://office.microsoft.com/en-gb/a...1153831033.aspx
"helpful sql" <nospam@.stopspam.com> wrote in message
news:uVMSYfaXGHA.3972@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to design a solution that will display customer data from Sql
> Server tables in an Internet Explorer tab of a third party app, e.g. the
> third party app has a tab that can display web pages.
> The third party app display one customer record at a time. I need to
> display Payment Transaction records for the current customer(linked by
> CustomerNo field) in the Internet Explorer tab. There are six types of
> Payment Transaction records. I need to display all Payment transaction
> records for the current customer, the subtotal for each transaction type
> and the total ampont for all transactions.
> What are the best tools for implementing this solution? Shoule I use
> DbNetGrid, Reporting Services, Crystal Reports or any other tool? Please
> also point me to any examples on the web or any tutorial.
> Thanks in advance.
>

display japanese problem using sqlserver 2000

hi,

I have installed sqlserver 2000 under windows2000 on my PC. I found that the result set cannot display japanese correctly..it just show out '??'. I have already set the locale on my windows2000 to japanese, but it still doesn't work.. pls help...thx.

best regards,Your collation should be unicode with binary sort order. If it is not make it so..|||Originally posted by tecman
Your collation should be unicode with binary sort order. If it is not make it so..

thanks... but how can I do that?
besides, can I set the table to store multi-language columns which means some columns are in japanese, and some is other languages?|||You can change the collation of a column by using the ALTER TABLE statement:

CREATE TABLE MyTable
(PrimaryKey int PRIMARY KEY,
CharCol varchar(10) COLLATE French_CI_AS NOT NULL
)
GO
ALTER TABLE MyTable ALTER COLUMN CharCol
varchar(10)COLLATE Latin1_General_CI_AS NOT NULL
GO

You cannot alter the collation of a column that is currently referenced by:

A computed column.

An index.

Distribution statistics, either generated automatically or by the CREATE STATISTICS statement.

A CHECK constraint.

A FOREIGN KEY constraint.
You can also use the COLLATE clause on an ALTER DATABASE to change the default collation of the database:

ALTER DATABASE MyDatabase COLLATE French_CI_AS

Altering the default collation of a database does not change the collations of the columns in any existing user-defined tables. These can be changed with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement changes:

--BOL