Change the default database

This is a SQL Server 2000 database with several databases
with Windows groups and users.
If a user is in a Windows group how can the user change
his or her default database without changing the Window
group default database?
Thank You,
Mark
I haven't tried it, but I'm not sure you can use EXEC sp_defaultdb
'domain\username', 'dbname' unless the user is explicitly listed as a login
in SQL Server.
http://www.aspfaq.com/
(Reverse address to reply.)
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:01d801c4acaa$76d19140$a501280a@.phx.gbl...
> This is a SQL Server 2000 database with several databases
> with Windows groups and users.
> If a user is in a Windows group how can the user change
> his or her default database without changing the Window
> group default database?
> Thank You,
> Mark
|||Each user will have to run sp_defaultdb 'ntdomain\ntloginname' ,
'defaultdatabse' from a QA window.
- Bhanu.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:01d801c4acaa$76d19140$a501280a@.phx.gbl...
> This is a SQL Server 2000 database with several databases
> with Windows groups and users.
> If a user is in a Windows group how can the user change
> his or her default database without changing the Window
> group default database?
> Thank You,
> Mark

Change the default database

This is a SQL Server 2000 database with several databases
with Windows groups and users.
If a user is in a Windows group how can the user change
his or her default database without changing the Window
group default database?
Thank You,
MarkI haven't tried it, but I'm not sure you can use EXEC sp_defaultdb
'domain\username', 'dbname' unless the user is explicitly listed as a login
in SQL Server.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:01d801c4acaa$76d19140$a501280a@.phx.gbl...
> This is a SQL Server 2000 database with several databases
> with Windows groups and users.
> If a user is in a Windows group how can the user change
> his or her default database without changing the Window
> group default database?
> Thank You,
> Mark|||Each user will have to run sp_defaultdb 'ntdomain\ntloginname' ,
'defaultdatabse' from a QA window.
- Bhanu.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:01d801c4acaa$76d19140$a501280a@.phx.gbl...
> This is a SQL Server 2000 database with several databases
> with Windows groups and users.
> If a user is in a Windows group how can the user change
> his or her default database without changing the Window
> group default database?
> Thank You,
> Mark

Change report groups at RunTime

Hi,
Ho can we change the order of groups in Crystal report at runtime through VB code

Thanks in Advance
Manoj.

To make it more clear..
Eg.
Group X
Group Y
Group Z
Group M
...
...

But some time I want the groups like
Group X
Group M
Group Z
Group Y
...
...If you're passing a recordset to Crystal, you could just set the 'ORDER BY' in your query