The query below complains of "Invalid column name 'ISSQLROLE'." when run on
installation that uses the Turkish character set.
SELECT * FROM sysusers WHERE NAME = 'BOB' AND ISSQLROLE = 0
I'm confused; why would the column be missing/renamed? Reinstalling SQL Ser
ver to use Latin character set works as always. Any words will be very much
appreciated. (I don't have much experience with character sets outside of t
he one that I use here in California.)
Thanks in advance,
James Hunter RossHi James,
Try the column name in lower case. Turkish has both dotted and non-dotted I'
s, and sometimes it is difficult to tell them apart if you're not used to th
e alphabet. In this case it seems to me that the uppercase I in ISSQLROLE in
interpreted by SQL Server as a non-dotted I, where it should be a dotted i.
--
Jacco Schalkwijk
SQL Server MVP
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message news:ujLG32q
CEHA.688@.tk2msftngp13.phx.gbl...
The query below complains of "Invalid column name 'ISSQLROLE'." when run on
installation that uses the Turkish character set.
SELECT * FROM sysusers WHERE NAME = 'BOB' AND ISSQLROLE = 0
I'm confused; why would the column be missing/renamed? Reinstalling SQL Ser
ver to use Latin character set works as always. Any words will be very much
appreciated. (I don't have much experience with character sets outside of t
he one that I use here in California.)
Thanks in advance,
James Hunter Ross|||I change only the "I" in "ISSQLROLE" in our query to "iSSQLROLE" and it work
s! What the...
I'm freaking out. I can't even think. Then, "I" is not actually upper case "
i", we are doomed. We have never been particularly disciplined when writing
queries to match the case of the query to the case of the column/table names
.
I don't suppose there is any easy way to dance around this, is there?
James|||Hi James,
Indeed in the Turkish collation "I" is not upper case "i", it is upper case
"i". Upper case "i" is "I".
I don't think that there is a way around it except a big search and replace
to change all the I's into i's.
The other option involves rebuilding the master database with a
Latin1_General collation (while keeping your own database at Turkish), but
your customer(s) might not be very happy with that, and if you have string
comparisons with columns in temporary tables they will fail most likely.
Jacco Schalkwijk
SQL Server MVP
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:uk1xlPrCEHA.3280@.TK2MSFTNGP09.phx.gbl...
I change only the "I" in "ISSQLROLE" in our query to "iSSQLROLE" and it
works! What the...
I'm freaking out. I can't even think. Then, "I" is not actually upper case
"i", we are doomed. We have never been particularly disciplined when writing
queries to match the case of the query to the case of the column/table
names.
I don't suppose there is any easy way to dance around this, is there?
James
Showing posts with label installation. Show all posts
Showing posts with label installation. Show all posts
Wednesday, March 28, 2012
No instance of SQL Server under MSDE installation
Hi all,
after successfully completing the installation of a
downloaded copy of MSDE for VS.Net things are
not working at all.
I was having trouble with my VS.Net installation so I
uninstalled VS.Net and MSDE.
I have installed MSDE several times today and each
time I can not see the instance name of the installation.
I have removed any existing directories, cleared the
obvious things from the registry, changed the instance
name and even chosen different target and data
directories to try and solve the problem. The service
seems to have started correctly, but I do not get
a green play icon in the system tray at the bottom of
the screen. When i open the server manager I
can not see the server running at all.
I do not know what to do next. Does anyone have any
ideas as to what what be causing this problem?
Many thanks for your assistance in helping me to
solve this problem.
Regards,
Jason.
Please ignore this post. I was just to impatient to wait
for all the services, etc to start.
All appears to be OK now.
Thanks.
On Thu, 29 Apr 2004 18:40:13 +0100, JJ <jason@.nospam.divemaster.org>
wrote:
>Hi all,
>after successfully completing the installation of a
>downloaded copy of MSDE for VS.Net things are
>not working at all.
>I was having trouble with my VS.Net installation so I
>uninstalled VS.Net and MSDE.
>I have installed MSDE several times today and each
>time I can not see the instance name of the installation.
>I have removed any existing directories, cleared the
>obvious things from the registry, changed the instance
>name and even chosen different target and data
>directories to try and solve the problem. The service
>seems to have started correctly, but I do not get
>a green play icon in the system tray at the bottom of
>the screen. When i open the server manager I
>can not see the server running at all.
>I do not know what to do next. Does anyone have any
>ideas as to what what be causing this problem?
>Many thanks for your assistance in helping me to
>solve this problem.
>Regards,
>Jason.
after successfully completing the installation of a
downloaded copy of MSDE for VS.Net things are
not working at all.
I was having trouble with my VS.Net installation so I
uninstalled VS.Net and MSDE.
I have installed MSDE several times today and each
time I can not see the instance name of the installation.
I have removed any existing directories, cleared the
obvious things from the registry, changed the instance
name and even chosen different target and data
directories to try and solve the problem. The service
seems to have started correctly, but I do not get
a green play icon in the system tray at the bottom of
the screen. When i open the server manager I
can not see the server running at all.
I do not know what to do next. Does anyone have any
ideas as to what what be causing this problem?
Many thanks for your assistance in helping me to
solve this problem.
Regards,
Jason.
Please ignore this post. I was just to impatient to wait
for all the services, etc to start.
All appears to be OK now.
Thanks.
On Thu, 29 Apr 2004 18:40:13 +0100, JJ <jason@.nospam.divemaster.org>
wrote:
>Hi all,
>after successfully completing the installation of a
>downloaded copy of MSDE for VS.Net things are
>not working at all.
>I was having trouble with my VS.Net installation so I
>uninstalled VS.Net and MSDE.
>I have installed MSDE several times today and each
>time I can not see the instance name of the installation.
>I have removed any existing directories, cleared the
>obvious things from the registry, changed the instance
>name and even chosen different target and data
>directories to try and solve the problem. The service
>seems to have started correctly, but I do not get
>a green play icon in the system tray at the bottom of
>the screen. When i open the server manager I
>can not see the server running at all.
>I do not know what to do next. Does anyone have any
>ideas as to what what be causing this problem?
>Many thanks for your assistance in helping me to
>solve this problem.
>Regards,
>Jason.
Labels:
adownloaded,
arenot,
completing,
copy,
database,
installation,
instance,
microsoft,
msde,
mysql,
net,
oracle,
server,
sql,
successfully,
trouble,
working
Subscribe to:
Posts (Atom)