Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh

Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh

sql

Report Designer... I want one

How do I put the power of SQL RS into the hands of your average financial
analyst or manager who doesn't know XML and doesn't ever want to use Visual
Studio? Most of these people will still use crystal reports until they have
their own report designer tool.
I have read some predictions that 3rd party report designers would be
developed... but who is doing this? Can we expect a report designer with SQL
2005 or is there someone working on it now who may release something sooner?
MalikGoto www.cizer.com, they have a web based report designer called "quick query". It runs off of Reporting Services.
Regards
Chris
"Abdul Malik Said" wrote:
> How do I put the power of SQL RS into the hands of your average financial
> analyst or manager who doesn't know XML and doesn't ever want to use Visual
> Studio? Most of these people will still use crystal reports until they have
> their own report designer tool.
> I have read some predictions that 3rd party report designers would be
> developed... but who is doing this? Can we expect a report designer with SQL
> 2005 or is there someone working on it now who may release something sooner?
> Malik
>
>|||Thanks Chris,
This is exactly what I was looking for.
At $2500, I can see some people saying it is cheaper than buying Crystal if
you already have SQL RS. But what would be REALLY nice :-) is if something
like this was bundled with SQL 2005.
Any plans to provide such a report designer in 2005?
Malik
"Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
news:8AD69179-DC3A-495B-BAFD-D73CAD08E362@.microsoft.com...
> Goto www.cizer.com, they have a web based report designer called "quick
query". It runs off of Reporting Services.
> Regards
> Chris
> "Abdul Malik Said" wrote:
> > How do I put the power of SQL RS into the hands of your average
financial
> > analyst or manager who doesn't know XML and doesn't ever want to use
Visual
> > Studio? Most of these people will still use crystal reports until they
have
> > their own report designer tool.
> >
> > I have read some predictions that 3rd party report designers would be
> > developed... but who is doing this? Can we expect a report designer with
SQL
> > 2005 or is there someone working on it now who may release something
sooner?
> >
> > Malik
> >
> >
> >|||Microsoft bought one of Cizer's competitors in the recent past ( proabably
to do just what you need.)
I am certain that the dev team is aware of your needs, and I expect we will
see many good things in the YUKON version especially in the area of
non-technical report development... The dev team will let us know details
when they are ready, but I have huge high hopes... You MS really does know
how to make a UI...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:eFGVtrAZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> Thanks Chris,
> This is exactly what I was looking for.
> At $2500, I can see some people saying it is cheaper than buying Crystal
if
> you already have SQL RS. But what would be REALLY nice :-) is if something
> like this was bundled with SQL 2005.
> Any plans to provide such a report designer in 2005?
> Malik
> "Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in
message
> news:8AD69179-DC3A-495B-BAFD-D73CAD08E362@.microsoft.com...
> > Goto www.cizer.com, they have a web based report designer called "quick
> query". It runs off of Reporting Services.
> >
> > Regards
> > Chris
> >
> > "Abdul Malik Said" wrote:
> >
> > > How do I put the power of SQL RS into the hands of your average
> financial
> > > analyst or manager who doesn't know XML and doesn't ever want to use
> Visual
> > > Studio? Most of these people will still use crystal reports until they
> have
> > > their own report designer tool.
> > >
> > > I have read some predictions that 3rd party report designers would be
> > > developed... but who is doing this? Can we expect a report designer
with
> SQL
> > > 2005 or is there someone working on it now who may release something
> sooner?
> > >
> > > Malik
> > >
> > >
> > >
>|||Just to clear up a misconception. There is no need to know XML at all. You
do have to use Visual Studio but XML plays no visible part of developing a
report. Yes, the report definition is in XML but the designer creates it
which is all visual design. I think as there become books available the
level of skill required to create reports will be less especially if going
against SQL Server and can use the visual query tool.
If they can use Crystal Reports I'm not sure that RS is any more difficult
than that.
I have only used Crystal Reports a little bit so I can not tell you that
definitively. Someone who has used both should jump in.
Bruce L-C
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uaGQ1LAZEHA.4008@.TK2MSFTNGP09.phx.gbl...
> How do I put the power of SQL RS into the hands of your average financial
> analyst or manager who doesn't know XML and doesn't ever want to use
Visual
> Studio? Most of these people will still use crystal reports until they
have
> their own report designer tool.
> I have read some predictions that 3rd party report designers would be
> developed... but who is doing this? Can we expect a report designer with
SQL
> 2005 or is there someone working on it now who may release something
sooner?
> Malik
>|||Yes, you are right. As long as you have Visual Studio, no need to mess with
the RDL files or know the RDL schema. However, most report developers in
today's world don't know what visual studio is, far less know how to use it.
I have used Crystal Reports designer, and I can tell you that I like the
Visual Studio designer much better. However, this needs to be offered to
someone outside of the Visual Studio licencing scheme. Report writers are
not necessarily full-fledged developers, and should not incur as much cost
to the company for developer licences.
I can see a great future for stuff like that Cizer product, which simply
provides the Visual studio interface to a web client. That way, the user
doesn't need a visual studio licence.
Great discussion, needs attention from Microsoft people who can make sure
this gets in the next release! :-D
Malik
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:#1G#MtCZEHA.996@.TK2MSFTNGP12.phx.gbl...
> Just to clear up a misconception. There is no need to know XML at all. You
> do have to use Visual Studio but XML plays no visible part of developing a
> report. Yes, the report definition is in XML but the designer creates it
> which is all visual design. I think as there become books available the
> level of skill required to create reports will be less especially if going
> against SQL Server and can use the visual query tool.
> If they can use Crystal Reports I'm not sure that RS is any more difficult
> than that.
> I have only used Crystal Reports a little bit so I can not tell you that
> definitively. Someone who has used both should jump in.
> Bruce L-C
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:uaGQ1LAZEHA.4008@.TK2MSFTNGP09.phx.gbl...
> > How do I put the power of SQL RS into the hands of your average
financial
> > analyst or manager who doesn't know XML and doesn't ever want to use
> Visual
> > Studio? Most of these people will still use crystal reports until they
> have
> > their own report designer tool.
> >
> > I have read some predictions that 3rd party report designers would be
> > developed... but who is doing this? Can we expect a report designer with
> SQL
> > 2005 or is there someone working on it now who may release something
> sooner?
> >
> > Malik
> >
> >
>|||Abdul,
We were in the same situation. The way we got around this today was to
purchase VB.NET standard for our non development users ($99 US a copy I
believe) and install the RS designer into that. Works great for us and
is as cost effective as it gets today.
Like you though I would love to see a powerful dedicated report designer
with some nice bells and whistles for power reports folks.
Hope this helps,
Matt
Abdul Malik Said wrote:
> Yes, you are right. As long as you have Visual Studio, no need to mess with
> the RDL files or know the RDL schema. However, most report developers in
> today's world don't know what visual studio is, far less know how to use it.
> I have used Crystal Reports designer, and I can tell you that I like the
> Visual Studio designer much better. However, this needs to be offered to
> someone outside of the Visual Studio licencing scheme. Report writers are
> not necessarily full-fledged developers, and should not incur as much cost
> to the company for developer licences.
> I can see a great future for stuff like that Cizer product, which simply
> provides the Visual studio interface to a web client. That way, the user
> doesn't need a visual studio licence.
> Great discussion, needs attention from Microsoft people who can make sure
> this gets in the next release! :-D
> Malik
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:#1G#MtCZEHA.996@.TK2MSFTNGP12.phx.gbl...
>>Just to clear up a misconception. There is no need to know XML at all. You
>>do have to use Visual Studio but XML plays no visible part of developing a
>>report. Yes, the report definition is in XML but the designer creates it
>>which is all visual design. I think as there become books available the
>>level of skill required to create reports will be less especially if going
>>against SQL Server and can use the visual query tool.
>>If they can use Crystal Reports I'm not sure that RS is any more difficult
>>than that.
>>I have only used Crystal Reports a little bit so I can not tell you that
>>definitively. Someone who has used both should jump in.
>>Bruce L-C
>>"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
>>news:uaGQ1LAZEHA.4008@.TK2MSFTNGP09.phx.gbl...
>>How do I put the power of SQL RS into the hands of your average
> financial
>>analyst or manager who doesn't know XML and doesn't ever want to use
>>Visual
>>Studio? Most of these people will still use crystal reports until they
>>have
>>their own report designer tool.
>>I have read some predictions that 3rd party report designers would be
>>developed... but who is doing this? Can we expect a report designer with
>>SQL
>>2005 or is there someone working on it now who may release something
>>sooner?
>>Malik
>>
>>
>|||Please see the following for more about Reporting Services and Active Views
http://www.microsoft.com/presspass/press/2004/apr04/04-26ActiveViewsPR.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uaGQ1LAZEHA.4008@.TK2MSFTNGP09.phx.gbl...
> How do I put the power of SQL RS into the hands of your average financial
> analyst or manager who doesn't know XML and doesn't ever want to use
Visual
> Studio? Most of these people will still use crystal reports until they
have
> their own report designer tool.
> I have read some predictions that 3rd party report designers would be
> developed... but who is doing this? Can we expect a report designer with
SQL
> 2005 or is there someone working on it now who may release something
sooner?
> Malik
>|||I think RS need to much SQL knowledge for your average user to create thier
own reports, crystal takes that away for all but the most complicated of
reports.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uaGQ1LAZEHA.4008@.TK2MSFTNGP09.phx.gbl...
> How do I put the power of SQL RS into the hands of your average financial
> analyst or manager who doesn't know XML and doesn't ever want to use
Visual
> Studio? Most of these people will still use crystal reports until they
have
> their own report designer tool.
> I have read some predictions that 3rd party report designers would be
> developed... but who is doing this? Can we expect a report designer with
SQL
> 2005 or is there someone working on it now who may release something
sooner?
> Malik
>|||Greg,
You are right, but that is not a bad thing - Reporting Services as it stands now is aimed at the Reporting/Development professional.
Use Cizers products or other equivalents for end user report design.
By the way, anyone know how to get Active Views? All enquiries on-line send me to the press release about Microsofts acquisition of them!
Chris McGuigan
"Greg Rodger" wrote:
> I think RS need to much SQL knowledge for your average user to create thier
> own reports, crystal takes that away for all but the most complicated of
> reports.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:uaGQ1LAZEHA.4008@.TK2MSFTNGP09.phx.gbl...
> > How do I put the power of SQL RS into the hands of your average financial
> > analyst or manager who doesn't know XML and doesn't ever want to use
> Visual
> > Studio? Most of these people will still use crystal reports until they
> have
> > their own report designer tool.
> >
> > I have read some predictions that 3rd party report designers would be
> > developed... but who is doing this? Can we expect a report designer with
> SQL
> > 2005 or is there someone working on it now who may release something
> sooner?
> >
> > Malik
> >
> >
>
>

Report deployment

Hello,

I have two questions:

1. When I debug my application it seems it deploys reports to report manager, how can I prevent that from happening, I would like to deploy when I chose deploy command only?
2. I have a report which has many sub-report, when I deploy sub-reports are deployed to report manager to and they become visible in the report manager screen., so user my chose and try to run them, I would like to make only my main report be visible on the report manager, is there anyway to accomplish this?

Thanks,

Disable the deploy of your project in the configuration for the solution in debug mode.

Report Credentials

Hi i have created serveral reports in sql and uploaded it to report manager. We have an issue here. We have 5 departments at our place.

Each of the department has 5 reports. We want the department for instance Administration to open/view only their reports and no others. How is this done

"Credentials supplied by the user running the report"

Basically if i give sa and sa as username and password, i will be able to enter any department reports but i want something like sa say 'admin' this user will only open his reports and no one else.

there is also security for the folder. I could clump all the reports instead of type do it by department. So all admin reports in one folder and only admin should have access and no one else say if there is another user manager he cant access it.

Do you have any idea on how to go abt this situation?

Sheldon

Hey anyone can help me please?|||

Hi,

Each of the department has 5 reports. We want the department for instance Administration to open/view only their reports and no others

From your description, it seems that you want to grant different permission against the your users from different department, right?

In your post, you have mentioned such accounts like 'sa', I think this is the account which is for accessing the database. But in your case, we don't need to care the database security layer. What you need is to use Administrator account to logon your report site, and create different repot folders for different departments. After that, Just as you said, go into the folder and open the property tab, click on "security", here, you can grant the permission to specific users for the current folder.

there is also security for the folder. I could clump all the reports instead of type do it by department. So all admin reports in one folder and only admin should have access and no one else say if there is another user manager he cant access it.

For this part, I'm not quite sure if I've misunderstood your words. Do you mean you have multiple users with administrator permissions? If so, there's no way to prevent him from accessing folders on this report site.

Thanks.

|||

Okay All Reports Divided Into Departments

How to create a user for each department so that the user will access only their repective folder.

Dont know how to do this

|||

Hi,

You can open your IE and visit your report site, go into site settings, and conifig the site's security, create a new role assign, type the name, select the corresponding role, and submit your action.

Thanks.

Report Catalog Database

Hi All,

In a scale out deployment, which component sends the query to the database, the report catalog or the Report Manager?

Report Manager is just a report portal. Running a report in report manager will send a request to the RS scale out deployment. If you are using a load balancer, it will send the request to one of the server nodes in the scale out deployments. This server node (a RS web service) will then execute the report which includes running queries, retrieving data, processing data, and rendering the result and sending it back to the client (which is report manager in this case).

-- Robert

report caching

here is the deal- i have a bunch of reports to which i need to add a generic
caching plan. i know how to do this through the report manager web
interface on a per-report-basis. my problem is that i am lazy and don't
want to click through every single report individually setting up the
caching plan. is there a way to do this across all reports in a directory?
please tell me there is...
tia,
jtOn May 4, 5:13 pm, "JTL" <j...@.clickstreamtech.com> wrote:
> here is the deal- i have a bunch of reports to which i need to add a generic
> caching plan. i know how to do this through the report manager web
> interface on a per-report-basis. my problem is that i am lazy and don't
> want to click through every single report individually setting up the
> caching plan. is there a way to do this across all reports in a directory?
> please tell me there is...
> tia,
> jt
As far as I know, aside from modifying the caching plan one report at
a time, there is no other way to change the caching plan. Sorry I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hello,
You can perform operations on a report server through the use of the rs
utility (RS.exe).
In this way you can programmatically administer a report server using
Microsoft Visual Basic scripts.
I think this is only way to automate setting configuration for many reports.
Regards,
Radoslaw Lebkowski
MCTS
U¿ytkownik "JTL" <jt@.clickstreamtech.com> napisa³ w wiadomo¶ci
news:O3wJllpjHHA.588@.TK2MSFTNGP06.phx.gbl...
> here is the deal- i have a bunch of reports to which i need to add a
> generic caching plan. i know how to do this through the report manager
> web interface on a per-report-basis. my problem is that i am lazy and
> don't want to click through every single report individually setting up
> the caching plan. is there a way to do this across all reports in a
> directory? please tell me there is...
> tia,
> jt
>sql

Report Builder with Forms Authentication

Hi,

After implementing custom security extension for forms authentication, the report server works fine with Report Manager and web application. However, there is a problem with Report Builder.

It gives SecurityException "That assembly does not allow partially trusted callers.". Its becos I am using my own security assembly for authentication. I resolved this issue by using the following in my assemblyinfo.cs

[assembly: System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.RequestMinimum, Name="FullTrust")]

However, now when I login to Report Builder it gives me error System.IO.FileNotFoundException. Its not able to find my security assembly.

I also tried giving FullTrust to the assembly using Framework 2.0 Configuration. I read somewhere that the ClickOnce application caches its last called settings in the manifest file and you have to delete the manifest and manually alter the security in the application settings(properties).

Is this true? Is there any solution to this issue? Is this really an issue with clickonce application?

This is really urgent. Any suggestions.

Thanks in advance.

Is there any solution to this?
This is really frustrating. We are duplicating all our security code into CustomSecurity Extension module. At least it stopped giving error at the point, where the call was made to an assembly. Dont know if it will really work, even after moving all the code to extension module.

I just hope someone from MS at least reads this post, if not care to reply.
I hope this helps someone.

Thankssql

Report Builder not working with Forms Authentication

We have successfully implemented forms authentication. The ReportServer and Report Manager both are working fine. However, when we launch the ReportBuilder using the url http://<server-name>/ReportServer/ReportBuilder/ReportBuilder.application or from the Report Manager, it prompts for user name and password. On entering the valid user-name and password, it gives the following error.

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

It doesnt accept any user-name, password (neither forms one, nor windows). This error is when we are trying to access Report Builder on the server (not tried on the client machine). The user-name has been given System Administrator and System User role. We have also given the Content Manager, Browser, ... etc all roles to the user.

However, we are testing this on June CTP. Is this a problem ?

This is very urgent as the rest all is working fine. Any suggestions ?

Thanks in advance.

Is there any solution? Does Report Builder work with Forms Authentication ?|||

If I remember correctly, this was a bug that we fixed before the RTM release of RS 2005. If you upgrade to RTM - or better yet, to SP1, this should work.

Thanks

Tudor

Report Builder imported questions from a customer

Hi,
1. If a table has a relation to itself example :
employee id emp name manager id
1 Melissa 2
2 Steven 100
This means Steven is the manager of Melissa.
Is it possible to make a report in Report Builder to have a list with of the
managers and their employees?
2.Following example in report builder an organization with his employees you
will see in Report builder this : (organization will appear only once)
Microsoft Steven
Melissa
BMW Jan
Els
In export to xls the customer wants to see this :
Microsoft Steven
Microsoft Melissa
BMW Jan
BMW Els
Is this possible?
And if a certain organization does not have employees they want to see this
organization for the moment the report only list organizations with employees?
3. If the email field of a person (table 1) is empty they want to see in the
report the email field of the organization (table 2) is this possible with
the function if then else... in the creation of a new field without having
fields of the organization in the report displayed?"carolineb" <carolineb@.discussions.microsoft.com> wrote in message
news:FE5D33EF-66CC-4420-B60C-CC8AC82AA616@.microsoft.com...
> Hi,
> 1. If a table has a relation to itself example :
> employee id emp name manager id
> 1 Melissa 2
> 2 Steven 100
> This means Steven is the manager of Melissa.
> Is it possible to make a report in Report Builder to have a list with of
> the
> managers and their employees?
Write query like this:
select
c2.Name as ManagerMame,
c1.*
from Employees c1
left join Employees c2
on c2.EmployeeID = c1.ManagerID
order by c1.ReportsTo
> 2.Following example in report builder an organization with his employees
> you
> will see in Report builder this : (organization will appear only once)
> Microsoft Steven
> Melissa
> BMW Jan
> Els
> In export to xls the customer wants to see this :
> Microsoft Steven
> Microsoft Melissa
> BMW Jan
> BMW Els
> Is this possible?
> And if a certain organization does not have employees they want to see
> this
> organization for the moment the report only list organizations with
> employees?
As far as I know this is not possible (export should be WYSIWYG if it is
working correctly)
> 3. If the email field of a person (table 1) is empty they want to see in
> the
> report the email field of the organization (table 2) is this possible with
> the function if then else... in the creation of a new field without having
> fields of the organization in the report displayed?
>
Yes it is possible, you don't have to display all fields.
Regards,
Stjepan|||"Stjepan Puljko" wrote:
> "carolineb" <carolineb@.discussions.microsoft.com> wrote in message
> news:FE5D33EF-66CC-4420-B60C-CC8AC82AA616@.microsoft.com...
> > Hi,
> >
> > 1. If a table has a relation to itself example :
> >
> > employee id emp name manager id
> > 1 Melissa 2
> > 2 Steven 100
> >
> > This means Steven is the manager of Melissa.
> > Is it possible to make a report in Report Builder to have a list with of
> > the
> > managers and their employees?
> Write query like this:
> select
> c2.Name as ManagerMame,
> c1.*
> from Employees c1
> left join Employees c2
> on c2.EmployeeID = c1.ManagerID
> order by c1.ReportsTo
> caroline : we cannot write a select in report builder?
> >
> > 2.Following example in report builder an organization with his employees
> > you
> > will see in Report builder this : (organization will appear only once)
> >
> > Microsoft Steven
> > Melissa
> > BMW Jan
> > Els
> > In export to xls the customer wants to see this :
> > Microsoft Steven
> > Microsoft Melissa
> > BMW Jan
> > BMW Els
> > Is this possible?
> > And if a certain organization does not have employees they want to see
> > this
> > organization for the moment the report only list organizations with
> > employees?
> As far as I know this is not possible (export should be WYSIWYG if it is
> working correctly)
> > 3. If the email field of a person (table 1) is empty they want to see in
> > the
> > report the email field of the organization (table 2) is this possible with
> > the function if then else... in the creation of a new field without having
> > fields of the organization in the report displayed?
> >
> Yes it is possible, you don't have to display all fields.
caroline : I have tried to do this and was only allowed to use fields of one
table in the if then else function, he did allowed to select a field from
another table in the if then else but indicated with an error message that
the function is not valid?
> Regards,
> Stjepan
>
>

Report Builder

I have tried using the report builder for the first time by clicking on it from the report manager.

I am not able to proceed ahead because of the error .

The error occured when i start the application . The details log shows me this error.

Error :

Exception occurred loading manifest from file ReportBuilder.exe: the manifest may not be valid or the file could not be opened.
+ File ReportBuilder.exe is not a valid Portable Executable (PE) file.
+ PE file does not have enough data.

Has the .NetFramework 2.0 been installed successfully? Additionally, check version of Reporting Services and ensure you are running RTM version.

If you can, let me know build topology and client build.

Cheers,

Phillip Cox

Replication: EM-Could not retrieve the list of registered subscribers

When I try to open the subscribers tab in the publisher and distributor properties in SQL Enterprise Manager I get the following error:

SQL Enterprise Manager could not retrieve the list of registered subscribers.
Error 8152: String or binary data will be truncated

Anyone who has experienced similar problems or has a solution?

Best Regards
MFYou might have a problem in the distribution database. I would check the system table mssubscriptions first to see if there's anything wrong.