Cant see the username in the Owner Combo box during job creation

Hi
use dbname
go
Select * from sysusers
"Double_B" <bharatbutani@.gmail.com> wrote in message
news:1150966319.684458.270690@.i40g2000cwc.googlegroups.com...
> Hi All
> Am trying to schedule a job , but when I try selecting the username for
> the Owner... I dont see the username in th list , I cant even type the
> name of the user in the combo box ...
> The username exists in the logins of my SQL Server...
>
> Could you please help !!!!!!!
>
> Thanks
>What version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Double_B" <bharatbutani@.gmail.com> wrote in message
news:1150966319.684458.270690@.i40g2000cwc.googlegroups.com...
> Hi All
> Am trying to schedule a job , but when I try selecting the username for
> the Owner... I dont see the username in th list , I cant even type the
> name of the user in the combo box ...
> The username exists in the logins of my SQL Server...
>
> Could you please help !!!!!!!
>
> Thanks
>|||Hi All
Am trying to schedule a job , but when I try selecting the username for
the Owner... I dont see the username in th list , I cant even type the
name of the user in the combo box ...
The username exists in the logins of my SQL Server...
Could you please help !!!!!!!
Thanks|||Hi
use dbname
go
Select * from sysusers
"Double_B" <bharatbutani@.gmail.com> wrote in message
news:1150966319.684458.270690@.i40g2000cwc.googlegroups.com...
> Hi All
> Am trying to schedule a job , but when I try selecting the username for
> the Owner... I dont see the username in th list , I cant even type the
> name of the user in the combo box ...
> The username exists in the logins of my SQL Server...
>
> Could you please help !!!!!!!
>
> Thanks
>|||What version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Double_B" <bharatbutani@.gmail.com> wrote in message
news:1150966319.684458.270690@.i40g2000cwc.googlegroups.com...
> Hi All
> Am trying to schedule a job , but when I try selecting the username for
> the Owner... I dont see the username in th list , I cant even type the
> name of the user in the combo box ...
> The username exists in the logins of my SQL Server...
>
> Could you please help !!!!!!!
>
> Thanks
>sql

Can't query attached database (solution?)

In article
<pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
Christian Miller <pariahware@.pariahware.com> wrote:

> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
> Yes, I can view it in the enterprise manager.
> Yes, I've even used the "use" command to make sure, on occassion.
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".
OK, apparently there is not a database table called "employee", but
there is one called "EMPLOYEE". I don't ever remember table name case
being an issue when performing a querying before. I normally uppercase
key words and lowercase table names. Is this a setting in my SQL Server
that I accidentally set?
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?
Case sensitivity for object names is based on the database collation (if my memory serves me).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-11C0F9.16271516062004@.news2-ge0.southeast.rr.com...
> In article
> <pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
> Christian Miller <pariahware@.pariahware.com> wrote:
>
> OK, apparently there is not a database table called "employee", but
> there is one called "EMPLOYEE". I don't ever remember table name case
> being an issue when performing a querying before. I normally uppercase
> key words and lowercase table names. Is this a setting in my SQL Server
> that I accidentally set?
>
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?
|||In article <u2N$QN#UEHA.2920@.TK2MSFTNGP10.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:

> Case sensitivity for object names is based on the database collation (if my
> memory serves me).
If that per database file or per server? How would I turn off database
collation if I wanted to? I really appreciate all the help on this.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?

Can't query attached database (solution?)

In article
<pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
Christian Miller <pariahware@.pariahware.com> wrote:

> In article <uwTZNx9UEHA.1048@.TK2MSFTNGP09.phx.gbl>,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote:
>
> Yes, I can view it in the enterprise manager.
>
> Yes, I've even used the "use" command to make sure, on occassion.
>
> The owner of the table is "dbo".
> When I look under the db's users, "dbo" is a name entry, "sa" is the
> login name and access is "permit".
OK, apparently there is not a database table called "employee", but
there is one called "EMPLOYEE". I don't ever remember table name case
being an issue when performing a querying before. I normally uppercase
key words and lowercase table names. Is this a setting in my SQL Server
that I accidentally set?
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?Case sensitivity for object names is based on the database collation (if my
memory serves me).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Miller" <pariahware@.pariahware.com> wrote in message
news:pariahware-11C0F9.16271516062004@.news2-ge0.southeast.rr.com...
> In article
> <pariahware-21E05C.16194316062004@.news2-ge0.southeast.rr.com>,
> Christian Miller <pariahware@.pariahware.com> wrote:
>
> OK, apparently there is not a database table called "employee", but
> there is one called "EMPLOYEE". I don't ever remember table name case
> being an issue when performing a querying before. I normally uppercase
> key words and lowercase table names. Is this a setting in my SQL Server
> that I accidentally set?
>
> Thanks,
> Christian
> pariahware@.pariahware.com
> Pariahware, Inc. Custom Software and Shareware
> http://www.pariahware.com
> --
> God loved you so much that He gave His only son Jesus.
> What have you done with God's gift?|||In article <u2N$QN#UEHA.2920@.TK2MSFTNGP10.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote:

> Case sensitivity for object names is based on the database collation (if m
y
> memory serves me).
If that per database file or per server? How would I turn off database
collation if I wanted to? I really appreciate all the help on this.
Thanks,
Christian
pariahware@.pariahware.com
Pariahware, Inc. Custom Software and Shareware
http://www.pariahware.com
--
God loved you so much that He gave His only son Jesus.
What have you done with God's gift?