Can I change Sort order configuration for a single column?

Hi,
I wanted to know, if there is a way to change the sort order (Collation) for a particular column. Assuming, sql server is configured for Case Insensitive, can I change the sort order to "Case sensitive" for a single column or object, retaining the entire sql server instance to Case insenstive
Thank
GYKTry COLLATE.
USE NORTHWIND
select * from orders
order by shipname COLLATE Latin1_General_CS_AS
There is a lot to read about in BO.
cheers,
Herbert Albert
"GYK" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:E309852D-B260-441A-BB31-676AA92D2346@.microsoft.com...
> Hi,
> I wanted to know, if there is a way to change the sort order (Collation)
for a particular column. Assuming, sql server is configured for Case
Insensitive, can I change the sort order to "Case sensitive" for a single
column or object, retaining the entire sql server instance to Case
insenstive ?
> Thanks
> GYK|||Yes, you can do that using ALTER TABLE ... ALTER COLUMN and specify the
desired collation. Or specify collation in the query, as per Herbert's
example.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:E309852D-B260-441A-BB31-676AA92D2346@.microsoft.com...
> Hi,
> I wanted to know, if there is a way to change the sort order (Collation)
for a particular column. Assuming, sql server is configured for Case
Insensitive, can I change the sort order to "Case sensitive" for a single
column or object, retaining the entire sql server instance to Case
insenstive ?
> Thanks
> GYK|||Great...
Thanks a lot to you guys
GYK|||HI,
I have one more question. Can a collation be set for a user session? That is I logon with a particular collation, and it becomes invalid, once I logout... :-)
Thanks agai
GY|||Unfortunately not. Consider sending a request for such a feature to
sqlwish@.microsoft.com.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:714D7DFF-E243-4B19-9545-F76BF40E475B@.microsoft.com...
> HI,
> I have one more question. Can a collation be set for a user session? That
is I logon with a particular collation, and it becomes invalid, once I
logout... :-)
> Thanks again
> GYK
>

Can aspnetdb.mdf be moved from development to production machine?

1.) Can an aspnetdb.mdf database be configured and setup on one server and then be moved to a production server or is there something machine specific that keeps this from being possible?
2.) Is putting this file in the app_data folder something that is used only for SQL 2005 or SQL express? I had to set up a connection string in my SQL 2000 installation to get the connection to work.

Thanks for any input!

Colelaus

aspnetdb.mdf is the default sql express database created, if you want to move it onto production, your production server has to install sql express and reference it in your connection string|||

I'm using aspnetdb.mdf as my security database but not SQL Express due to llimitations on the server. I guess my question is really is there anything that is generated in the database when setting up security that is machine specific that would keep the database from being moved from one machine to another?

If it is machine specific, it would require as you referenced, me to recreate on the production server and reset all the users again.

Colelaus

|||

Hi Colelaus,

If your production server provides SQL server other editions than the Express edition, you will need to have the .mdf database files attach to server manually, since other edtions of SQL server does not support attaching database files automatically at runtime.

Also, you will need to modify your connection string and make it look like "Data Source=ServerName\InstanceName;Initial Catelog=DatabaseName". It points to a database on server instead of a .mdf file.For other information, you will need to contact the hosting service.

The tool you may use : Aspnet_regsql.exe ( More details about the tool, pls visit http://msdn2.microsoft.com/en-us/library/ms229862(VS.80).aspx )

Thanks.

|||

Thanks. That is exactly the info I needed.

Colelaus

Can Analysis services for SQL 2005 server be configured on windows 2000 server?

Hi,

I'm unable to find any documentation that indicates whether or not SQL 2005's XMLA is supported on Windows 2000.

I imagine that because it is supported on XP, per the following document:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx
...that it can be run from Windows 2000 with IIS 5.0 by following the same directions for configuring it.

Can anyone confirm if this is an accurate assessment? Has anyone else had experiences (good or bad) of running SQL 2005 XMLA on Windows 2000 / IIS 5.0?

p.s. this is also alongside a default instance of sql 2000 with the 2005 as a named instance.

HI,

Yes SQL 2005's XMLA is supported on Windows 2000. but prior to that we need MDAC 2.8 SP1 and .Net framework 2.0 to work properly.

I am not sure about the IIS5.0 but for IIS6.0 it works.

Thanks

|||

Um, Windows 2000 server has IIS 5 and is why I'm asking the question.

Does anyone else have any experience setting this up on a Windows 2000 server and or why MS has information on their technet site that only references 2003 server or XP setup? As I understand it, IIS lives in a different process than the type of process it resides in for 2000, is this relative to the reason there's no documented support for it's configuration on this OS?