Creating user groups with Forms Authentication

Hello,
Is there a way to implement groups with forms authentication? Currently I am
only able to create users and being able to generate groups would greatly
help.
ThanksSearch the below URL for 'forms authentication groups'. I found quite a few
results:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs
--
Adrian M.
MCP
"Sceptical" <skep@.nowhere.com> wrote in message
news:HrH6e.17208$215.16616@.tornado.rdc-kc.rr.com...
> Hello,
> Is there a way to implement groups with forms authentication? Currently I
> am only able to create users and being able to generate groups would
> greatly help.
> Thanks
>sql

Creating new File groups on an existing db

Out production database is around 10G and it is all in one file group
(Primary).
I would like to create new file groups and split the database into multiple
file groups for better manageablity.
I have identified the tables that can be moved into new file groups.
What is the best approach to spilt an existing production database into
multiple file groups?
Thanks,
S.KumarSuresh
If your table whose are going to be place on separate filegroup have
clustered indexes then you can easily re-create the clustered index with
specify file group .For details please refer to BOL.
"Suresh Kumar" <skumat@.pcdiDOTcom> wrote in message
news:#A3i3KWbDHA.2548@.TK2MSFTNGP09.phx.gbl...
> Out production database is around 10G and it is all in one file group
> (Primary).
> I would like to create new file groups and split the database into
multiple
> file groups for better manageablity.
> I have identified the tables that can be moved into new file groups.
> What is the best approach to spilt an existing production database into
> multiple file groups?
> Thanks,
> S.Kumar
>|||You should start changing the filegroups for the specified tables, if there
aren´t many tables you could work with EM, edit table, property of the
tables/ indexes.
Jens Süßmeyer.|||Multiple files in a single filegroup allows SQL to do parallel IO on a
single query...
Using multiple filegroups allow you to.
1. Backup/Restore subsets of tables with different recovery needs.
2. Balance IO if you beleive you can do better than striping
3. Limit the space allocation which is used by a subset of tables...
The 1st is the best reason for filegroups...It does not improve
manageability, but causes you to have to watch for disk space utilization on
EACH filegroup...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corp (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Suresh Kumar" <skumat@.pcdiDOTcom> wrote in message
news:OxBFFmWbDHA.3360@.tk2msftngp13.phx.gbl...
> My aim is to split the database into multiple files.
> I could have multiple files referring to the same File Group (Primary) or
> multiple files going to multiple File groups.
> Which way is better and what are the pros and cons?
> Thanks,
> S.Kumar
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eki5qUWbDHA.1580@.tk2msftngp13.phx.gbl...
> > Suresh
> > If your table whose are going to be place on separate filegroup have
> > clustered indexes then you can easily re-create the clustered index with
> > specify file group .For details please refer to BOL.
> >
> >
> >
> > "Suresh Kumar" <skumat@.pcdiDOTcom> wrote in message
> > news:#A3i3KWbDHA.2548@.TK2MSFTNGP09.phx.gbl...
> > > Out production database is around 10G and it is all in one file group
> > > (Primary).
> > > I would like to create new file groups and split the database into
> > multiple
> > > file groups for better manageablity.
> > >
> > > I have identified the tables that can be moved into new file groups.
> > > What is the best approach to spilt an existing production database
into
> > > multiple file groups?
> > >
> > > Thanks,
> > > S.Kumar
> > >
> > >
> >
> >
>|||Wayne,
Did you use to work for Unisys ?
I use to know one Wayne Snyder when I worked for them in Charlotte 10 yrs
ago.
If you are the one, please send me a note to my personal email address.
Thanks,
Suresh Kumar
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message
news:OyKlrSXbDHA.2672@.tk2msftngp13.phx.gbl...
> Multiple files in a single filegroup allows SQL to do parallel IO on a
> single query...
> Using multiple filegroups allow you to.
> 1. Backup/Restore subsets of tables with different recovery needs.
> 2. Balance IO if you beleive you can do better than striping
> 3. Limit the space allocation which is used by a subset of tables...
> The 1st is the best reason for filegroups...It does not improve
> manageability, but causes you to have to watch for disk space utilization
on
> EACH filegroup...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Computer Education Services Corp (CESC), Charlotte, NC
> (Please respond only to the newsgroups.)
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Suresh Kumar" <skumat@.pcdiDOTcom> wrote in message
> news:OxBFFmWbDHA.3360@.tk2msftngp13.phx.gbl...
> > My aim is to split the database into multiple files.
> > I could have multiple files referring to the same File Group (Primary)
or
> > multiple files going to multiple File groups.
> >
> > Which way is better and what are the pros and cons?
> > Thanks,
> > S.Kumar
> >
> >
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:eki5qUWbDHA.1580@.tk2msftngp13.phx.gbl...
> > > Suresh
> > > If your table whose are going to be place on separate filegroup have
> > > clustered indexes then you can easily re-create the clustered index
with
> > > specify file group .For details please refer to BOL.
> > >
> > >
> > >
> > > "Suresh Kumar" <skumat@.pcdiDOTcom> wrote in message
> > > news:#A3i3KWbDHA.2548@.TK2MSFTNGP09.phx.gbl...
> > > > Out production database is around 10G and it is all in one file
group
> > > > (Primary).
> > > > I would like to create new file groups and split the database into
> > > multiple
> > > > file groups for better manageablity.
> > > >
> > > > I have identified the tables that can be moved into new file groups.
> > > > What is the best approach to spilt an existing production database
> into
> > > > multiple file groups?
> > > >
> > > > Thanks,
> > > > S.Kumar
> > > >
> > > >
> > >
> > >
> >
> >
>

Creating Group Eliminates Records

Forgive the novice nature of this question.

I have a report that I want to create four groups for. Prior to grouping, I've created a Sum for an amount field. I get a Total of $1000.00 (for simplicity sake I'm making up a number).

I create the first grouping and subtotal that group. No problem
I repeat for the second and third grouping. No problem.

However, on the final grouping, it changes my Grand Total to $988.50. I assume this means that records are being eliminated? The final grouping is different than groups 1, 2, and 3 in that it is in a different table. Does this have anything to do with it.

Your help is greatly appreciated.What type of join do you use when joining this table?
Inner or Left Outer?|||I've been taught to just click the smart button on the join screen. So I accepted what Crystal mapped.

It's set to an inner join. I changed it and it worked! Thank you so much.

Is there anyway that you can tell me in layman's terms why I needed to do that? What is the difference between those types of joins?

Also, do the joins get saved with the report, or do I need to set them each time I refresh the report with new data?

Thank you again!|||:) Yes, of course the joins get saved with the report.

I don't think I can give you better explanations then those you have in the 'Help' file.
Read help on 'inner join' and 'left outer join'.

Actually, here is one example of how it works, let's say we have 2 tables.
The 1st one is accounts:

acc_num acc_name state
-----------
acc1 name1 MN
acc2 name2 NJ
acc3 name3 NY
acc4 name4 OH
acc5 name5 AK

and the 2nd one is payments:

acc_num pay_date amount
------------
acc1 6/1/07 $30.00
acc3 7/4/07 $100.00
acc5 7/15/07 $40.00

If you use inner type of join to link them (accounts.acc_num=payments.acc_num), the result will be next:

acc_num acc_name state pay_date amount
--------------------
acc1 name1 MN 6/1/07 $30.00
acc3 name3 NY 7/4/07 $100.00
acc5 name5 AK 7/15/07 $40.00

2 records from the 1st table (acc2, acc4) are not selected because there are no such field values in the 2nd table.

But if you use left outer join, you will get all of the records from the primary (left) table:

acc_num acc_name state pay_date amount
--------------------
acc1 name1 MN 6/1/07 $30.00
acc2 name2 NJ
acc3 name3 NY 7/4/07 $100.00
acc4 name4 OH
acc5 name5 AK 7/15/07 $40.00

...probably, your smart button didn't get what you were trying to do ;)
but to be serious, I wouldn't use it. :)|||Duh, the help file. That was, helpful.

In all seriousness, thank you so much for your help.