Having Custom Legend to Pie Charts

Hi All,

what I want is a custom Legend for the Pie Chart.

I have followed this article and have done what was written under

Custom Chart Color Palettes and Legends

http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic4

But still the color of the legend is not uniform.

Basically I am using a stored procedure which returns two values : Circle, Total based on a parameter called Customer.

1. I have pasted the code asked in the Code Section of the report.

2. Have Disabled the 'Show Legend' box in Chart Properties.

3. Have included the following code in the Values->Appearance->Series Styel->Fill

=Code.GetColor(Fields!Circle.Value)

4. In the Category groups ->Group on-> this is my expression =Fields!Circle.Value (Basically I am not sure where

should I include Circle Field. I have tried this both by putting it in Category Groups and Series Groups.)

5. Dragged and dropped new table and have done the following

a.table1->Properties->Groups->Add->General->Group on Expression Fields!Circle.Value

b.Deleted Detail row.

c.Dragged and dropped rectangle in the column value and set the background value to =Code.GetColor(Fields!Circle.Value)

When I run the report for different customers the colors are not remaining constant. I have 17 values for Circles. So included three more colors in the "colorPalette " variable..

After doing all this still I am not able to get the same colors. Could someone tell me where I am going wrong?

Well, it looks like there was nothing wrong with the way I have been doing at all. My requierment was immaterial of whether certain value is present or not I wanted a color associated to that i.e. if for a given date(the input) my data returns the circles say Circle 1, Circle 2 with green and yellow colors associated with them respectively. So if those circles are not returned by the query then what was happening was green was getting applied to Circle 2 rather than sticking on to Circle 1. I changed my settings back at DB for this and now it is working fine.

For those of you whose results are static that is if you have data with all the circles say Circle 1 to Circle 5 all the time and you have to define your custom palette in it then this is the perfect method.Hope this helps some others.
Thank you
sql

Having Custom Legend to Pie Charts

Hi All,

what I want is a custom Legend for the Pie Chart.

I have followed this article and have done what was written under

Custom Chart Color Palettes and Legends

http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic4

But still the color of the legend is not uniform.

Basically I am using a stored procedure which returns two values : Circle, Total based on a parameter called Customer.

1. I have pasted the code asked in the Code Section of the report.

2. Have Disabled the 'Show Legend' box in Chart Properties.

3. Have included the following code in the Values->Appearance->Series Styel->Fill

=Code.GetColor(Fields!Circle.Value)

4. In the Category groups ->Group on-> this is my expression =Fields!Circle.Value (Basically I am not sure where

should I include Circle Field. I have tried this both by putting it in Category Groups and Series Groups.)

5. Dragged and dropped new table and have done the following

a.table1->Properties->Groups->Add->General->Group on Expression Fields!Circle.Value

b.Deleted Detail row.

c.Dragged and dropped rectangle in the column value and set the background value to =Code.GetColor(Fields!Circle.Value)

When I run the report for different customers the colors are not remaining constant. I have 17 values for Circles. So included three more colors in the "colorPalette " variable..

After doing all this still I am not able to get the same colors. Could someone tell me where I am going wrong?

Well, it looks like there was nothing wrong with the way I have been doing at all. My requierment was immaterial of whether certain value is present or not I wanted a color associated to that i.e. if for a given date(the input) my data returns the circles say Circle 1, Circle 2 with green and yellow colors associated with them respectively. So if those circles are not returned by the query then what was happening was green was getting applied to Circle 2 rather than sticking on to Circle 1. I changed my settings back at DB for this and now it is working fine.

For those of you whose results are static that is if you have data with all the circles say Circle 1 to Circle 5 all the time and you have to define your custom palette in it then this is the perfect method.Hope this helps some others.
Thank you

has anyone here done Stretch Clustering?

http://www.microsoft.com/technet/pr.../sql/2000/deplo
y/hasog05.mspx
Has anyone used the Stretch Clustering techniques used in
this article? If it works that good theres no reason to
use Transactional Replication is there? What are the
goods/ bads?
TIA, ChrisROne of the banks here uses this quite successfully...
There is a difference between this and transactional replication...
Stretch clustering allows ONLY the primary node to access the data at any
given time.
There is a limit of 4 nodes on the cluster.
The hardware is more expensive.
This is a high availability solution
Replication may have many subscribers to the same publication, all
accessed/updated concurrently.
Less expensive hardware is required.
This works on SQL Standard Edition (Clustering requires EE)
Replication does NOT replicate system tables ( no users/permissions, etc) ,
but the Stretch clustering covers everything.
Replication is intended to make near real time copies of the data available
locally and is not a high availability solution...
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
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2ae5201c4685a$22b5c660$a601280a@.phx
.gbl...
> http://www.microsoft.com/technet/pr.../sql/2000/deplo
> y/hasog05.mspx
> Has anyone used the Stretch Clustering techniques used in
> this article? If it works that good theres no reason to
> use Transactional Replication is there? What are the
> goods/ bads?
> TIA, ChrisR

has anyone here done Stretch Clustering?

http://www.microsoft.com/technet/pro...sql/2000/deplo
y/hasog05.mspx
Has anyone used the Stretch Clustering techniques used in
this article? If it works that good theres no reason to
use Transactional Replication is there? What are the
goods/ bads?
TIA, ChrisR
One of the banks here uses this quite successfully...
There is a difference between this and transactional replication...
Stretch clustering allows ONLY the primary node to access the data at any
given time.
There is a limit of 4 nodes on the cluster.
The hardware is more expensive.
This is a high availability solution
Replication may have many subscribers to the same publication, all
accessed/updated concurrently.
Less expensive hardware is required.
This works on SQL Standard Edition (Clustering requires EE)
Replication does NOT replicate system tables ( no users/permissions, etc) ,
but the Stretch clustering covers everything.
Replication is intended to make near real time copies of the data available
locally and is not a high availability solution...
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
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2ae5201c4685a$22b5c660$a601280a@.phx.gbl...
> http://www.microsoft.com/technet/pro...sql/2000/deplo
> y/hasog05.mspx
> Has anyone used the Stretch Clustering techniques used in
> this article? If it works that good theres no reason to
> use Transactional Replication is there? What are the
> goods/ bads?
> TIA, ChrisR

has anyone here done Stretch Clustering?

http://www.microsoft.com/technet/prodtechnol/sql/2000/deplo
y/hasog05.mspx
Has anyone used the Stretch Clustering techniques used in
this article? If it works that good theres no reason to
use Transactional Replication is there? What are the
goods/ bads?
TIA, ChrisROne of the banks here uses this quite successfully...
There is a difference between this and transactional replication...
Stretch clustering allows ONLY the primary node to access the data at any
given time.
There is a limit of 4 nodes on the cluster.
The hardware is more expensive.
This is a high availability solution
Replication may have many subscribers to the same publication, all
accessed/updated concurrently.
Less expensive hardware is required.
This works on SQL Standard Edition (Clustering requires EE)
Replication does NOT replicate system tables ( no users/permissions, etc) ,
but the Stretch clustering covers everything.
Replication is intended to make near real time copies of the data available
locally and is not a high availability solution...
--
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
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2ae5201c4685a$22b5c660$a601280a@.phx.gbl...
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deplo
> y/hasog05.mspx
> Has anyone used the Stretch Clustering techniques used in
> this article? If it works that good theres no reason to
> use Transactional Replication is there? What are the
> goods/ bads?
> TIA, ChrisR

hanging on one table

Hi,
sometimes (often) my merge replication agent hang on this step:
Processing article 'table1'...
or (occasionally):
The merge process is cleaning up meta data in database 'db1'...
table1 is a large table (22 fields, approx 400.000 rows) with no Primary Key.
I don't have any idea with 'meta data' errors.
After this hang/error we always have this happen again the next time we tried again.
what happen with this? pls help...
TIA
echo
can you post the exact error message you are getting?
Also right click on your problem merge agent and select Agent Properties,
click on steps, and then click on run agent. Then click Edit and at the end
of the commands you find there, hit the space bar, and type -QueryTimeOut
600
Then restart your merge agent.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"echo" <echo@.discussions.microsoft.com> wrote in message
news:922613C3-C666-412F-B35B-F70B2B044F95@.microsoft.com...
> Hi,
> sometimes (often) my merge replication agent hang on this step:
> Processing article 'table1'...
> or (occasionally):
> The merge process is cleaning up meta data in database 'db1'...
> table1 is a large table (22 fields, approx 400.000 rows) with no Primary
Key.
> I don't have any idea with 'meta data' errors.
> After this hang/error we always have this happen again the next time we
tried again.
> what happen with this? pls help...
> TIA
> echo

Handling errors in transactional replication

Hello,
I have this problem, I have transactional replication
setup with 2 table as article for a publisher. Consider a
transaction which inserts one row into each of these
table in the publisher database. At subscriber database
one of the commands suceeds and the other fails (lets say
because of duplicate value for a key field).
What I would like is ...
1. Enable the error to be logged to a application table.
2. Have both the commands fail (not just one)
3. Have the replication continue without erroring out
4. Have the erroneous trasction be tried at a later time.
Could help me resolving this sticky problem.
Answers on how to acheive any of the points are welcome
too.
Thanks,
Ramuk
If you have a transaction on the publisher, you may check @.@.error and then
call rollback, but whether you rollback or not the sp is still executed on
the subscriber. This situation is altered (no subscriber call) if you set
the transaction isolation level to serializable. This is important to do
because even if you trap the same error in the transaction on the subscriber
and rollback there, the error is registered and the distribution agent will
fail. SkipErrors would avoid this problem but ideally the call shouldn't be
sent from the publisher to the subscriber if it has already failed once.
Logging of this error could be done from within the transaction using
xp_logevent or simply inserting to a SQL table.
HTH,
Paul
|||Thanks for the response ... though the problem I face is, that the transaction suceeds on the publisher. Its only on the subscriber that it fails.
Any ideas?
-- Paul Ibison wrote: --
If you have a transaction on the publisher, you may check @.@.error and then
call rollback, but whether you rollback or not the sp is still executed on
the subscriber. This situation is altered (no subscriber call) if you set
the transaction isolation level to serializable. This is important to do
because even if you trap the same error in the transaction on the subscriber
and rollback there, the error is registered and the distribution agent will
fail. SkipErrors would avoid this problem but ideally the call shouldn't be
sent from the publisher to the subscriber if it has already failed once.
Logging of this error could be done from within the transaction using
xp_logevent or simply inserting to a SQL table.
HTH,
Paul
|||Ramul,
in theory this shouldn't be possible! If all the articles are replicated
then the same transaction should be applied.
What is the error on the subscriber?
Regards,
Paul
|||Paul,
We are in the design stage ... so the problem is yet theoretical.
The problem is when two commands which are part of the transaction are applied at the subsciber, it could be possible for one of the commands to fail (because of business logic at subscribers end) .
If I were to go the route of using "Continue on Data Consistency Errors" then the failed command will not be applied on the subscriber but the other command will ... which cause an invalid state. If I do not set "Continue on Data Consistency Errors" ... t
hen the replication would stop... that is the crux of the problem.
So an ideal solution would be for both the commands not being applied in case of an error on any one ... the error being logged into an application table (for purposes of monitoring) ... and if possible the transaction marked for retrial later.
Also another question ... can I get the value of the "Transaction sequence number" at the distributer? Can it be passed to the Custom SP's at the subscriber?
Thanks for the help,
Ramuk.
|||Ramuk,
my recollection is that if the 2 data modifications are wrapped in a
transaction which has error-trapping (or set xact_abort on) then the
transaction will be successfully completely rolled back on an error at the
subscriber. I haven't tried this out in all circumstances and AFAIR you'll
still need -SKIPERRORS. Am off home now, but will retest it out some time
tomorrow.
Regards,
Paul

Hacking the sa password

Hi,
I was shown recently at a training session an article that showed how
your could break the sa password by using network monitoring tools and some
other steps. I am currently trying to find this myself so I can show the
developers at my company one of the reasons I am opposed to the sa account
being used and SQL logins in general.
Does anyone out there know where this article would be or what the exact
process is so I can replicate it quickly.
Cheers,
JohnWhen one uses a relatively anonymous moniker, John,
<John@.discussions.microsoft.com>", how would we know that you aren't just
trying to hack into someone's database and you are trying to get us to help
you?
;-)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"John" <John@.discussions.microsoft.com> wrote in message
news:9DB6A662-08C1-41FB-81A8-18BC7D4FCBF1@.microsoft.com...
> Hi,
> I was shown recently at a training session an article that showed how
> your could break the sa password by using network monitoring tools and
> some
> other steps. I am currently trying to find this myself so I can show the
> developers at my company one of the reasons I am opposed to the sa account
> being used and SQL logins in general.
> Does anyone out there know where this article would be or what the exact
> process is so I can replicate it quickly.
> Cheers,
> John|||Well Arnie, how do we know who anyone really is over the internet. Besides
John is my name but I don't want the entire world to have all my details
especially anyone trawling through forums for personal details to SPAM or
send marketing material through too. I can also not be bothered setting up
a
hotmail bogus account as this wa y I still get emails when my posts are
replied to sent to my work email.
On a more interesting note, do you happen to know the location of the
article I am interested in. From memory it uses SQLPing2 which I already
have downloaded.
"Arnie Rowland" wrote:

> When one uses a relatively anonymous moniker, John,
> <John@.discussions.microsoft.com>", how would we know that you aren't just
> trying to hack into someone's database and you are trying to get us to hel
p
> you?
> ;-)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9DB6A662-08C1-41FB-81A8-18BC7D4FCBF1@.microsoft.com...
>
>|||It sounds like this may be the article you are referring to:
http://searchsqlserver.techtarget.c...00.h
tml
-Sue
On Mon, 25 Sep 2006 19:36:02 -0700, John
<John@.discussions.microsoft.com> wrote:

>Hi,
> I was shown recently at a training session an article that showed how
>your could break the sa password by using network monitoring tools and some
>other steps. I am currently trying to find this myself so I can show the
>developers at my company one of the reasons I am opposed to the sa account
>being used and SQL logins in general.
>Does anyone out there know where this article would be or what the exact
>process is so I can replicate it quickly.
>Cheers,
>John|||I have an example of a TSQL function that will do the job as part of the
following presentation
http://www.sqldbatips.com/presentat...HACKING_SQL.zip
Note that SQL2005 doesn't use the same method, it uses a self signed
certificate to properly encrypt the login handshake as opposed to SQL2000
which basically just uses obsfucation.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"John" <John@.discussions.microsoft.com> wrote in message
news:9DB6A662-08C1-41FB-81A8-18BC7D4FCBF1@.microsoft.com...
> Hi,
> I was shown recently at a training session an article that showed how
> your could break the sa password by using network monitoring tools and
> some
> other steps. I am currently trying to find this myself so I can show the
> developers at my company one of the reasons I am opposed to the sa account
> being used and SQL logins in general.
> Does anyone out there know where this article would be or what the exact
> process is so I can replicate it quickly.
> Cheers,
> John