No ISSQLROLE column in sysusers?

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

Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-steve
steve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net. ..
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>
|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
?.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a crit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net. ..
> be
> for
> (Profiler,
>

Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-stevesteve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net...
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
'.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a crit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net...
> be
> for
> (Profiler,
>

Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-stevesteve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net...
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
'.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a écrit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net...
>> Hi,
>> I am set (by the sa) as a dbo, "full everything" for my Database.
>> However when I start the Index Tuning Wizard it complains that I need to
> be
>> in the sysadmin group
>> Also, what is the difference between all these Indexing Wizards? I want
> for
>> the server to suggest to me the indexes , for better performance.
> (Profiler,
>> etc.- which the other wizards seem not to have. They operate on a table
>> level.)
>> TIA
>> -steve
>>
>