Thursday, March 22, 2012
Does RS work with Lotus Notes?
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?"
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