When I look at my publisher and the publications in EM, they say they are
transaction replication.
HOWEVER, when I run sp_helppullsubscription on both of the subscriber DBs,
they return a publication_type of 1 (well except for one of them which
returns a 0 and is the one causing me high latency issues.) BOL says 1 =
snapshot and 0 = transactional replication.
Can someone please explain what in the heck is going on? My brain is about
to explode.
Thx,
Kristy
That's strange. I just deployed a transactional and snapshot publication and
verified that BOL is accurate here.
can you review the descriptions to make sure that they are referring to
current productions, sometimes data from old publications remain.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:u8Cc2lEVGHA.4248@.TK2MSFTNGP10.phx.gbl...
> When I look at my publisher and the publications in EM, they say they are
> transaction replication.
> HOWEVER, when I run sp_helppullsubscription on both of the subscriber DBs,
> they return a publication_type of 1 (well except for one of them which
> returns a 0 and is the one causing me high latency issues.) BOL says 1 =
> snapshot and 0 = transactional replication.
> Can someone please explain what in the heck is going on? My brain is about
> to explode.
> Thx,
> Kristy
>
|||Not exactely sure what you mean by "review the descriptions". There is another thread on this that gives a little more info. It's called "Confused about snapshot repl". It has the scripted versions of the subscriptions. Let me know if you need anything else.
Thanks,
--Kristy
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:uvuc5PXWGHA.2376@.TK2MSFTNGP03.phx.gbl...
> That's strange. I just deployed a transactional and snapshot publication and
> verified that BOL is accurate here.
> can you review the descriptions to make sure that they are referring to
> current productions, sometimes data from old publications remain.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kristy" <pleasereplyby@.posting.com> wrote in message
> news:u8Cc2lEVGHA.4248@.TK2MSFTNGP10.phx.gbl...
>
Showing posts with label confusion. Show all posts
Showing posts with label confusion. Show all posts
Monday, March 26, 2012
Monday, February 20, 2012
Money type confusion
I need a little advice for the Money datatype. When entering a value like $18.20 into a column of datatype Money, it stores and returns a value of 18.2 . It is set to the default paramaters. How can I change this so that it is correctly displayed as $18.20. My results are printed onscreen through VB, is that where I need to reformat?You sure it's money?
DECLARE @.x money
SELECT @.x = 18.20
SELECT @.x
EDIT: It's a presentation layer issue...
Then There Also
SELECT CONVERT(varchar(15),@.x,1)|||Positive it's Money|||Where's the sql being executed from? a stored procedure or called from a front end?
Did you try the code I posted in QA?|||It's a .asp page with VB. It's a dynamic SQL statment. And after running your code I got 18.2000. So it looks like it's good to 4 decimal places. This may be dumb to ask now, but should I kill that column and recreate it?|||You should be able to use the Convert function to format your output as a string, but formatting is best handled by your application interface.
blindman|||Do you know how to script the table so we can see the DDL?
Did you use the convert from the page?|||I'm a graphic designer doing the basics on MSSQL, I didn't even know you could script a table let alone tell you what a DDL is. But I'm a smart guy, I'll catch on quick.
And by converting do you mean something like CSTR to cast the returned value into a string or is it done within the SQL statment?
Originally posted by Brett Kaiser
Do you know how to script the table so we can see the DDL?
Did you use the convert from the page?|||SELECT CONVERT(varchar(15),@.x,1)
Just replace the @.x with the column name
Do you have SQL Server client tools installed on your desktop?
Do you know what Enterprise Manager is?|||Actually you should make the varchar(25) to handle all possible money values...
money and smallmoney
money
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
smallmoney
Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.|||[i]Actually you should make the varchar(25) to handle all possible money values...
quote:
------------------------
money and smallmoney
money
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
smallmoney
Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.
------------------------
Brett ...
That sounds like an awful lot of Money. Hope the person having so much can lend some to me :D|||HAHA, after 5 minutes of staring at the wrong webpage I was working on, I got myself straightened out and found the right one. The Convert expression works like magic.
And yeah, i'm working in Enterprise Manager. I guess I'm a little above basic.|||I thought 15 was enough...but you still have to take in the right side of the decimal, the decimal itself, commas, and a sign...25
922 Trillion Dollars...|||Thanks for you help, I should be able to manage from here|||If we were dealing with 922 Trillion Dollars do you think I'd be posting to a free forum for help? I think they'd have someone a little more experienced on this.|||Actually, it's more a matter of a development methodolgy...always code for what can happen...always...
That way there will never be any holes...|||Originally posted by stmaher
If we were dealing with 922 Trillion Dollars do you think I'd be posting to a free forum for help? I think they'd have someone a little more experienced on this.
There go my hopes down the drain :D.
BTW Brett is right. The code should take care of all possible conditions.
Brett ... though I think varchar(15) will take care of Bill Gates wealth for sure|||Free forum !? What is your mailing address ? Or you can call the toll free number and submit your credit card information.|||What? Have NONE of you guys been receiving your checks?
Must be a problem in the payroll database...
blindman|||Just send me your SSN's and mailing addresses and I will get you on the payroll. If you receive any unexpected mail, like credit cards ..., ignore it and just forward them to me. :-)|||> That sounds like an awful lot of Money
hang on a sec...you must be assuming USD. I wonder whether the amount would still look so large if it was to refer to Japanese Yen. Not to mention some inflated currency from a developing country.|||You'd be surprized.
We have a thing in the IT dept. we call the "2 comma rule".
In other words, if the number (currency) doesn't have at least 2 commas, it isn't worth worrying about.
Swear to God.
DECLARE @.x money
SELECT @.x = 18.20
SELECT @.x
EDIT: It's a presentation layer issue...
Then There Also
SELECT CONVERT(varchar(15),@.x,1)|||Positive it's Money|||Where's the sql being executed from? a stored procedure or called from a front end?
Did you try the code I posted in QA?|||It's a .asp page with VB. It's a dynamic SQL statment. And after running your code I got 18.2000. So it looks like it's good to 4 decimal places. This may be dumb to ask now, but should I kill that column and recreate it?|||You should be able to use the Convert function to format your output as a string, but formatting is best handled by your application interface.
blindman|||Do you know how to script the table so we can see the DDL?
Did you use the convert from the page?|||I'm a graphic designer doing the basics on MSSQL, I didn't even know you could script a table let alone tell you what a DDL is. But I'm a smart guy, I'll catch on quick.
And by converting do you mean something like CSTR to cast the returned value into a string or is it done within the SQL statment?
Originally posted by Brett Kaiser
Do you know how to script the table so we can see the DDL?
Did you use the convert from the page?|||SELECT CONVERT(varchar(15),@.x,1)
Just replace the @.x with the column name
Do you have SQL Server client tools installed on your desktop?
Do you know what Enterprise Manager is?|||Actually you should make the varchar(25) to handle all possible money values...
money and smallmoney
money
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
smallmoney
Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.|||[i]Actually you should make the varchar(25) to handle all possible money values...
quote:
------------------------
money and smallmoney
money
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
smallmoney
Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.
------------------------
Brett ...
That sounds like an awful lot of Money. Hope the person having so much can lend some to me :D|||HAHA, after 5 minutes of staring at the wrong webpage I was working on, I got myself straightened out and found the right one. The Convert expression works like magic.
And yeah, i'm working in Enterprise Manager. I guess I'm a little above basic.|||I thought 15 was enough...but you still have to take in the right side of the decimal, the decimal itself, commas, and a sign...25
922 Trillion Dollars...|||Thanks for you help, I should be able to manage from here|||If we were dealing with 922 Trillion Dollars do you think I'd be posting to a free forum for help? I think they'd have someone a little more experienced on this.|||Actually, it's more a matter of a development methodolgy...always code for what can happen...always...
That way there will never be any holes...|||Originally posted by stmaher
If we were dealing with 922 Trillion Dollars do you think I'd be posting to a free forum for help? I think they'd have someone a little more experienced on this.
There go my hopes down the drain :D.
BTW Brett is right. The code should take care of all possible conditions.
Brett ... though I think varchar(15) will take care of Bill Gates wealth for sure|||Free forum !? What is your mailing address ? Or you can call the toll free number and submit your credit card information.|||What? Have NONE of you guys been receiving your checks?
Must be a problem in the payroll database...
blindman|||Just send me your SSN's and mailing addresses and I will get you on the payroll. If you receive any unexpected mail, like credit cards ..., ignore it and just forward them to me. :-)|||> That sounds like an awful lot of Money
hang on a sec...you must be assuming USD. I wonder whether the amount would still look so large if it was to refer to Japanese Yen. Not to mention some inflated currency from a developing country.|||You'd be surprized.
We have a thing in the IT dept. we call the "2 comma rule".
In other words, if the number (currency) doesn't have at least 2 commas, it isn't worth worrying about.
Swear to God.
Subscribe to:
Posts (Atom)