Showing posts with label ability. Show all posts
Showing posts with label ability. Show all posts

Thursday, March 22, 2012

Does RS work with Lotus Notes?

I realise that RS has the ability to use any SMTP mail server, however, I am
looking for someone that has practical experience of Reporting Services
delivering subscription based reports via Lotus Notes.
Does this work and are there any issues I should be aware of?
Thanks,
Dave.it work fine for me
U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> I realise that RS has the ability to use any SMTP mail server, however, I
am
> looking for someone that has practical experience of Reporting Services
> delivering subscription based reports via Lotus Notes.
> Does this work and are there any issues I should be aware of?
> Thanks,
> Dave.
>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 2004-07-05|||We have had an issue with attachments coming out as zero length in some
cases of delivering to Notes. We are working on a fix for this.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <kawa@.panda.bg.univ.gda.pl> wrote in message
news:%2350n0SUZEHA.2516@.TK2MSFTNGP10.phx.gbl...
> it work fine for me
> U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
> news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
>> I realise that RS has the ability to use any SMTP mail server, however, I
> am
>> looking for someone that has practical experience of Reporting Services
>> delivering subscription based reports via Lotus Notes.
>> Does this work and are there any issues I should be aware of?
>> Thanks,
>> Dave.
>>
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.716 / Virus Database: 472 - Release Date: 2004-07-05
>|||Please nofity me if exists other way to deliver subscriptions.
Thanks.
"Brian Welcker [MSFT]" wrote:
> We have had an issue with attachments coming out as zero length in some
> cases of delivering to Notes. We are working on a fix for this.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "kamel" <kawa@.panda.bg.univ.gda.pl> wrote in message
> news:%2350n0SUZEHA.2516@.TK2MSFTNGP10.phx.gbl...
> > it work fine for me
> >
> > U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
> > news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >> I realise that RS has the ability to use any SMTP mail server, however, I
> > am
> >> looking for someone that has practical experience of Reporting Services
> >> delivering subscription based reports via Lotus Notes.
> >>
> >> Does this work and are there any issues I should be aware of?
> >>
> >> Thanks,
> >>
> >> Dave.|||We are a lotus notes shop but we also maintain a SMTP server. RS can install
such that you can send a mail to a SMTP server without having to have Lotus
client (or Outlook etc). I use this and it works fine.
Bruce L-C
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:28B768DB-F709-406A-9E35-236025238EDA@.microsoft.com...
> Please nofity me if exists other way to deliver subscriptions.
> Thanks.
> "Brian Welcker [MSFT]" wrote:
> > We have had an issue with attachments coming out as zero length in some
> > cases of delivering to Notes. We are working on a fix for this.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "kamel" <kawa@.panda.bg.univ.gda.pl> wrote in message
> > news:%2350n0SUZEHA.2516@.TK2MSFTNGP10.phx.gbl...
> > > it work fine for me
> > >
> > > U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
> > > news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > >> I realise that RS has the ability to use any SMTP mail server,
however, I
> > > am
> > >> looking for someone that has practical experience of Reporting
Services
> > >> delivering subscription based reports via Lotus Notes.
> > >>
> > >> Does this work and are there any issues I should be aware of?
> > >>
> > >> Thanks,
> > >>
> > >> Dave.

Monday, March 19, 2012

does MSSQL have the ability to do "named row types?"

Hi all. We have a mix of informix and mssql server and I want to know
if something we do in informix has an analogous feature in MSSQL. We
can define a "row type" in informix, like so:

create row type name_1(fname char(20),lname char(20));

The when we create any table that includes a first and last name, we
do so using this row type like so:

create table sometable(name name_1, some column,...etc)

This allows us to set a standard for certain common fields and avoids
having different developers build the same type of field in more than
one way, different lengths, etc.

Is there a similar function in MSSQL server?sumGirl (emebohw@.netscape.net) writes:
> Hi all. We have a mix of informix and mssql server and I want to know
> if something we do in informix has an analogous feature in MSSQL. We
> can define a "row type" in informix, like so:
> create row type name_1(fname char(20),lname char(20));
> The when we create any table that includes a first and last name, we
> do so using this row type like so:
> create table sometable(name name_1, some column,...etc)
> This allows us to set a standard for certain common fields and avoids
> having different developers build the same type of field in more than
> one way, different lengths, etc.
> Is there a similar function in MSSQL server?

In SQL 2000, no.

In SQL 2005, which currently is in beta, you can define structured types
in CLR languages like Visual Basic or C#, but it's not really the same
thing as the Informafix feature. I assume that in the Informix case you
can still say:

SELECT fname FROM sometable WHERE ...

and thus refer to the individual columns directly. With a CLR type in
SQL2005 you would have to say:

SELECT name.fname FROM sometable WHERE ...

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp