If there is no match in the matrix - it displays an empty cell. Is there a way to display some default number instead?
Thanks,
Igor
have you tried the following (as an expression):
iif(field = nothing,some#,field)
Showing posts with label empty. Show all posts
Showing posts with label empty. Show all posts
Wednesday, March 28, 2012
put default number in a data cell of a matrix
Hi,
If there is no match in the matrix - it displays an empty cell. Is there a way to display some default number instead?
If there is no match in the matrix - it displays an empty cell. Is there a way to display some default number instead?
Wednesday, March 7, 2012
Publisher is empty under Replication Monitor - Publisher.! But replication is still runnin
I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..
You could try running sp_MSload_replication_status.
To investigate further I'd like to know if you see the publication under the
"Replication" folder and/or the "Publications" folder in the published
database.
Also, there was an issue with this prior to sp4
(http://support.microsoft.com/kb/814032) so please ensure that you've got
the latest sp.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> Yes, I do see the publications under the Replication --> Publication
> tab. I can also confirm that the replication is working as it is
> pushing those updates to the subscriber. I am unable to run the
> sp_MSload_replication_status as it is returning the following error..
> Server: Msg 8152, Level 16, State 6, Procedure
> sp_MSload_replication_status, Line 19
> String or binary data would be truncated.
> The statement has been terminated.
> Thanks for the update. I would appreciate if you can help me figure out
> the issue...
> Thanks again..
>
> On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
|||I had finally figured out the issue... I changed the SQL Jobs
associated with the replication and when i changed back the sql job
names it appeared under my Replication monitor group window...
Query Builder wrote:[vbcol=seagreen]
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
>
> Query Builder wrote:
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..
You could try running sp_MSload_replication_status.
To investigate further I'd like to know if you see the publication under the
"Replication" folder and/or the "Publications" folder in the published
database.
Also, there was an issue with this prior to sp4
(http://support.microsoft.com/kb/814032) so please ensure that you've got
the latest sp.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> Yes, I do see the publications under the Replication --> Publication
> tab. I can also confirm that the replication is working as it is
> pushing those updates to the subscriber. I am unable to run the
> sp_MSload_replication_status as it is returning the following error..
> Server: Msg 8152, Level 16, State 6, Procedure
> sp_MSload_replication_status, Line 19
> String or binary data would be truncated.
> The statement has been terminated.
> Thanks for the update. I would appreciate if you can help me figure out
> the issue...
> Thanks again..
>
> On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
|||I had finally figured out the issue... I changed the SQL Jobs
associated with the replication and when i changed back the sql job
names it appeared under my Replication monitor group window...
Query Builder wrote:[vbcol=seagreen]
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
>
> Query Builder wrote:
Publisher is empty under Replication Monitor - Publisher.! But replication is still runnin
I have a wired situation..!
sql jobs related to the replication. When I changed the name back to
what it was, and now I can see the replication tree under the
replication Monitor window...
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..Has anyone seen this issue? Any thoughts? Thanks in advance..
Query Builder wrote:
Quote:
Originally Posted by
I have a wired situation..!
>
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
>
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
>
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
>
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
>
All it says is (No Items)...
>
I would appreciate any help to correct this issue... Thanks in advance..
sql jobs related to the replication. When I changed the name back to
what it was, and now I can see the replication tree under the
replication Monitor window...
Query Builder wrote:
Quote:
Originally Posted by
Has anyone seen this issue? Any thoughts? Thanks in advance..
>
>
Query Builder wrote:
Quote:
Originally Posted by
I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..
Publisher is empty under Replication Monitor - Publisher.! But replication is still runnin
I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..You could try running sp_MSload_replication_status.
To investigate further I'd like to know if you see the publication under the
"Replication" folder and/or the "Publications" folder in the published
database.
Also, there was an issue with this prior to sp4
(http://support.microsoft.com/kb/814032) so please ensure that you've got
the latest sp.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Yes, I do see the publications under the Replication --> Publication
tab. I can also confirm that the replication is working as it is
pushing those updates to the subscriber. I am unable to run the
sp_MSload_replication_status as it is returning the following error..
Server: Msg 8152, Level 16, State 6, Procedure
sp_MSload_replication_status, Line 19
String or binary data would be truncated.
The statement has been terminated.
Thanks for the update. I would appreciate if you can help me figure out
the issue...
Thanks again..
On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> You could try running sp_MSload_replication_status.
> To investigate further I'd like to know if you see the publication under the
> "Replication" folder and/or the "Publications" folder in the published
> database.
> Also, there was an issue with this prior to sp4
> (http://support.microsoft.com/kb/814032) so please ensure that you've got
> the latest sp.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:
> Yes, I do see the publications under the Replication --> Publication
> tab. I can also confirm that the replication is working as it is
> pushing those updates to the subscriber. I am unable to run the
> sp_MSload_replication_status as it is returning the following error..
> Server: Msg 8152, Level 16, State 6, Procedure
> sp_MSload_replication_status, Line 19
> String or binary data would be truncated.
> The statement has been terminated.
> Thanks for the update. I would appreciate if you can help me figure out
> the issue...
> Thanks again..
>
> On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> > You could try running sp_MSload_replication_status.
> > To investigate further I'd like to know if you see the publication under the
> > "Replication" folder and/or the "Publications" folder in the published
> > database.
> > Also, there was an issue with this prior to sp4
> > (http://support.microsoft.com/kb/814032) so please ensure that you've got
> > the latest sp.
> > Cheers,
> > Paul Ibison SQL Server MVP,www.replicationanswers.com.|||I had finally figured out the issue... I changed the SQL Jobs
associated with the replication and when i changed back the sql job
names it appeared under my Replication monitor group window...
Query Builder wrote:
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
>
> Query Builder wrote:
> > Yes, I do see the publications under the Replication --> Publication
> > tab. I can also confirm that the replication is working as it is
> > pushing those updates to the subscriber. I am unable to run the
> > sp_MSload_replication_status as it is returning the following error..
> >
> > Server: Msg 8152, Level 16, State 6, Procedure
> > sp_MSload_replication_status, Line 19
> > String or binary data would be truncated.
> > The statement has been terminated.
> >
> > Thanks for the update. I would appreciate if you can help me figure out
> > the issue...
> >
> > Thanks again..
> >
> >
> > On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> > > You could try running sp_MSload_replication_status.
> > > To investigate further I'd like to know if you see the publication under the
> > > "Replication" folder and/or the "Publications" folder in the published
> > > database.
> > > Also, there was an issue with this prior to sp4
> > > (http://support.microsoft.com/kb/814032) so please ensure that you've got
> > > the latest sp.
> > > Cheers,
> > > Paul Ibison SQL Server MVP,www.replicationanswers.com.
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..You could try running sp_MSload_replication_status.
To investigate further I'd like to know if you see the publication under the
"Replication" folder and/or the "Publications" folder in the published
database.
Also, there was an issue with this prior to sp4
(http://support.microsoft.com/kb/814032) so please ensure that you've got
the latest sp.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Yes, I do see the publications under the Replication --> Publication
tab. I can also confirm that the replication is working as it is
pushing those updates to the subscriber. I am unable to run the
sp_MSload_replication_status as it is returning the following error..
Server: Msg 8152, Level 16, State 6, Procedure
sp_MSload_replication_status, Line 19
String or binary data would be truncated.
The statement has been terminated.
Thanks for the update. I would appreciate if you can help me figure out
the issue...
Thanks again..
On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> You could try running sp_MSload_replication_status.
> To investigate further I'd like to know if you see the publication under the
> "Replication" folder and/or the "Publications" folder in the published
> database.
> Also, there was an issue with this prior to sp4
> (http://support.microsoft.com/kb/814032) so please ensure that you've got
> the latest sp.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:
> Yes, I do see the publications under the Replication --> Publication
> tab. I can also confirm that the replication is working as it is
> pushing those updates to the subscriber. I am unable to run the
> sp_MSload_replication_status as it is returning the following error..
> Server: Msg 8152, Level 16, State 6, Procedure
> sp_MSload_replication_status, Line 19
> String or binary data would be truncated.
> The statement has been terminated.
> Thanks for the update. I would appreciate if you can help me figure out
> the issue...
> Thanks again..
>
> On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> > You could try running sp_MSload_replication_status.
> > To investigate further I'd like to know if you see the publication under the
> > "Replication" folder and/or the "Publications" folder in the published
> > database.
> > Also, there was an issue with this prior to sp4
> > (http://support.microsoft.com/kb/814032) so please ensure that you've got
> > the latest sp.
> > Cheers,
> > Paul Ibison SQL Server MVP,www.replicationanswers.com.|||I had finally figured out the issue... I changed the SQL Jobs
associated with the replication and when i changed back the sql job
names it appeared under my Replication monitor group window...
Query Builder wrote:
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
>
> Query Builder wrote:
> > Yes, I do see the publications under the Replication --> Publication
> > tab. I can also confirm that the replication is working as it is
> > pushing those updates to the subscriber. I am unable to run the
> > sp_MSload_replication_status as it is returning the following error..
> >
> > Server: Msg 8152, Level 16, State 6, Procedure
> > sp_MSload_replication_status, Line 19
> > String or binary data would be truncated.
> > The statement has been terminated.
> >
> > Thanks for the update. I would appreciate if you can help me figure out
> > the issue...
> >
> > Thanks again..
> >
> >
> > On Nov 3, 4:42 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> > > You could try running sp_MSload_replication_status.
> > > To investigate further I'd like to know if you see the publication under the
> > > "Replication" folder and/or the "Publications" folder in the published
> > > database.
> > > Also, there was an issue with this prior to sp4
> > > (http://support.microsoft.com/kb/814032) so please ensure that you've got
> > > the latest sp.
> > > Cheers,
> > > Paul Ibison SQL Server MVP,www.replicationanswers.com.
Subscribe to:
Posts (Atom)