How can I put this forum on a news reader like Outlook Express?

Dear Anyone,

I'm used to having my newsgroups on my outlook express. But I cant seem to find a this particular forum on the regular group listings. Is there a way I can get these sql2k5 forums on my outlook express?
Thanks,
Joseph

RSS feeds is the only way you could get instant updates in this forum.

You could aggregate RSS feeds into your Outlook using NewsGator or Attensa, the standard edition of NewsGator is free, you can get it at this site:
https://www.newsgator.com/ngs/Ad_Outlook.aspx
and Attensa is free:
http://www.attensa.com/
Hope this helps,

-chris

How can I persist user credentials?

Hi,
I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular
user. Each report has its own data source. The way our security is set up,
I have to use the following configuration in the data source property sheet
for each report: Data Source=ServerName;Integrated Security=SSPI;Initial
Catalog=databaseName. Credentials stored securely in the report server. Use
as Windows credentials when connecting to the data source. I don't want the
user to have to enter their windows user name and password for each of the 8
reports. Does anyone know of a way to enter the credentials for the first
report and have them persist for the rest of the reports?
Thanks,
Jeff
--
Thanks,
JeffOn May 17, 6:07 pm, Jeff Stroope
<JeffStro...@.discussions.microsoft.com> wrote:
> Hi,
> I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular
> user. Each report has its own data source. The way our security is set up,
> I have to use the following configuration in the data source property sheet
> for each report: Data Source=ServerName;Integrated Security=SSPI;Initial
> Catalog=databaseName. Credentials stored securely in the report server. Use
> as Windows credentials when connecting to the data source. I don't want the
> user to have to enter their windows user name and password for each of the 8
> reports. Does anyone know of a way to enter the credentials for the first
> report and have them persist for the rest of the reports?
> Thanks,
> Jeff
> --
> Thanks,
> Jeff
This article might be helpful:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_3d7q.asp?frame=true
Also, you should look into the Reporting Services configuration files
(usually located at: C:\Program Files\Microsoft SQL Server\MSSQL.
2\Reporting Services\ReportServer): web.config and
rsreportserver.config. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique, I'll give it a look.
--
Thanks,
Jeff
"EMartinez" wrote:
> On May 17, 6:07 pm, Jeff Stroope
> <JeffStro...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular
> > user. Each report has its own data source. The way our security is set up,
> > I have to use the following configuration in the data source property sheet
> > for each report: Data Source=ServerName;Integrated Security=SSPI;Initial
> > Catalog=databaseName. Credentials stored securely in the report server. Use
> > as Windows credentials when connecting to the data source. I don't want the
> > user to have to enter their windows user name and password for each of the 8
> > reports. Does anyone know of a way to enter the credentials for the first
> > report and have them persist for the rest of the reports?
> >
> > Thanks,
> >
> > Jeff
> > --
> > Thanks,
> >
> > Jeff
> This article might be helpful:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_3d7q.asp?frame=true
> Also, you should look into the Reporting Services configuration files
> (usually located at: C:\Program Files\Microsoft SQL Server\MSSQL.
> 2\Reporting Services\ReportServer): web.config and
> rsreportserver.config. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

how can i Mask a column in a sql server database

Hi i have a table in my database and i want to mask or encrypt a particular column in it? How can i do it.

Any help will be appreciated.

Regards

Karen

If you wanted to do it on the SQL Server Database just simply follow these steps:

How to: Encrypt a Column of Data
http://msdn2.microsoft.com/en-us/library/ms179331.aspx

How can i group data returned by a datareader by a particular field

How can i group the data returned by statement below by "Dept" field. I have already tried to group it like shown below but that doesn't seem to work for me. Any help.

cmd_select =

New SqlCommand("SELECT Incident_id,Dept From Report_Incident Group By Dept,Incident_id", myconnection_string)

Try using ORDER BY instead of GROUP BY in the SQL. That should work.

|||Ok thanks ORDER BY should work but the problem is that i want to display the returned data visually in a pie chart. Eg if i have three departments(Dept) in Administratio, Engineering and Production, then my chart should only show those three not to show the dept for each and every record. So basically i want to group the piechart slices by dept.|||

Ok i got it. The code below now does my work.

cmd_select =New SqlCommand("SELECT COUNT(incident_id)AS total ,Dept,incident_date From Report_Incident

WHERE incident_date >=@.date1 AND incident_date<=@.date2 GROUP BY dept,incident_date ORDER BY total", myconnection_string)