Cant sort a text field!

Hi
ive got a table and contains a surname text field. Why cant i do a select statement ORDER BY surname. I get an error saying i cant sort a text field! how do i go around it!

thanksYou do ANSI SQL ALTER Table and change text to Varchar 40 because text cannot be used for things like name that can be covered with Varchar 40 or 50 at most. Then do ORDER BY. Hope this helps.|||

Your surname filed is a text datatype field which cannot be sorted.

You need change this field to varchar(50) or nvarchar(50) data type to allow you sort on it.

Limno

Can't Login to Sql Server 2005

HELP! I was working on a SSIS package trying to execute a SQL Transfer
Object task when it errored out saying it didn't have permission to
access the database. So I tried to manually scipt the Create Database
option and it gave me the same message. Then I was kicked out
completely and it won't let me back into the server not matter what
login I use. I'm using Windows Authentication mode only. So I'm at a
total loss. Any ideas? Thanks
EdHi
Have you checked the server itself? Can you connect with Management Studio?
John
"ed.brunet@.gmail.com" wrote:
> HELP! I was working on a SSIS package trying to execute a SQL Transfer
> Object task when it errored out saying it didn't have permission to
> access the database. So I tried to manually scipt the Create Database
> option and it gave me the same message. Then I was kicked out
> completely and it won't let me back into the server not matter what
> login I use. I'm using Windows Authentication mode only. So I'm at a
> total loss. Any ideas? Thanks
> Ed
>

Can't Login to Sql Server 2005

HELP! I was working on a SSIS package trying to execute a SQL Transfer
Object task when it errored out saying it didn't have permission to
access the database. So I tried to manually scipt the Create Database
option and it gave me the same message. Then I was kicked out
completely and it won't let me back into the server not matter what
login I use. I'm using Windows Authentication mode only. So I'm at a
total loss. Any ideas? Thanks
EdHi
Have you checked the server itself? Can you connect with Management Studio?
John
"ed.brunet@.gmail.com" wrote:

> HELP! I was working on a SSIS package trying to execute a SQL Transfer
> Object task when it errored out saying it didn't have permission to
> access the database. So I tried to manually scipt the Create Database
> option and it gave me the same message. Then I was kicked out
> completely and it won't let me back into the server not matter what
> login I use. I'm using Windows Authentication mode only. So I'm at a
> total loss. Any ideas? Thanks
> Ed
>

cant install SQL Web Data Administrator

Hi

I am using Web Developer 2005 Express. I am trying to install the SQL Web Data Administrator (setup.msi), but it gives an error message saying that I need to install Framework 1.1, BUT I already have version 2, so no-go for me there.

Also I have been trying to install the Cassini version with zero luck. When I run the build.bat file I get the csc and gacutil errors. However, when I set up the Environmental variable PATH within My Computer\Properties\Advanced\Environmental Variables\user Variables as per the instructions on the Cassini discussion forum, no change, I do not get 200 bucks or pass GO .

Please tell me I am being stupid

Dose your system fit all the requirements?

System Requirements

Supported Operating Systems:Windows 2000