Where are the SQL Experts? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Where are the SQL Experts?

Author

Topic

SqlShaun
Starting Member

14 Posts

Posted - 2005-02-15 : 09:40:30

Why cant anyone answer my 28549 question? how can i find the offending data / table?
Am i in the wrong forum? where is the SQL CE 2.0 forum?

aaaaaaaahhhhh!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-15 : 09:44:56

em... what? how bout you post the whole link??

Go with the flow & have fun! Else fight the flow

SqlShaun
Starting Member

14 Posts

Posted - 2005-02-15 : 09:48:27

Well no need to repost, got a pda, sync'ing to a database via gprs, get 28549 The row update or insert cannot be reapplied due to an integrity violation. Not applicable SSCE_M_FAILEDRETRIES want to find what the offending table / data is in the subset of data this particular user would get. therefore would know what filter to remove from the replication script!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-02-15 : 10:37:17

SqlShaun,
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45933
This was a nicely written, easy to understand response. How come you can't use that same level of eloquence to post your own questions? I have no idea what you are asking.

Be One with the Optimizer
TG

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-02-15 : 21:03:06

Shaun-

One problem, one post. DO NOT CROSS POST:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45943
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45656
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45710

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2005-02-15 : 21:11:24

>>where is the SQL CE 2.0 forum?

Better yet, where is google???

http://support.microsoft.com/default.aspx?scid=kb;en-us;312292
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827914#appliesto

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-02-16 : 01:59:56

maybe you just have a problem with referential integrity (like the error states). A little googling finds this:

Schema: Violation of Referential Integrity

SQL Server CE handles most referential integrity violations by reattempting to apply the row. If the row sent from the SQL Server CE Subscriber cannot be applied at the SQL Server Publisher, the following error is returned. This error is usually caused by the violation of a self-reference on a table.

Source: Microsoft SQL Server 2000 Windows CE Edition

Native Error: 28549

HR: 80040E2F

Description: Run

Param = 0

Param = 0

Param = 0

Param =

Param =

Param =

To correct this error, remove the violation by updating or deleting the row that violates integrity at the Subscriber.

Seems pretty straightforward to me.

-ec

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2005-02-16 : 03:40:31

Where are the SQL Experts?

After the cocktail party, the super-model impregnation program and optimising the petabyte analysis cube at the Petagon, I rushed straight here... Am I late?

DavidM

[i]A front-end is something that tries to violate a back-end.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-16 : 04:43:25

david:
hahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahahaha!!!!!!!!!!!!!!!!!!!!
that's all i have to say to that.

oh yeah... where can you sing up for the model impregnation program?

Go with the flow & have fun! Else fight the flow

Kristen
Test

22859 Posts

Posted - 2005-02-16 : 14:16:33

"where can you sing up for the model impregnation program?"

Here:

http://www.christian.org.uk/pressreleases/1999/november_11_1999.htm

Search for "Leicester City Council"

I may have got your orientation wrong!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-16 : 14:18:07

kristen: ROTLF

just one question. Why are you reading that?

Go with the flow & have fun! Else fight the flow

Kristen
Test

22859 Posts

Posted - 2005-02-16 : 14:56:08

My business partner lived in a region that supported similar policies, and he was miffed that his taxes paid for it. So I Googled for that and found that "Leicester City Council" have a similar policy ... Honestly!

Kristen

Xerxes
Aged Yak Warrior

666 Posts

Posted - 2005-02-16 : 15:18:45

This is the reason I come to this site: the phenomenal things one can learn here! Wow!

Semper fi, Xerxes, USMC(Ret.)
-------------------------------------------------------------------------
Once a Marine Programmer Analyst ALWAYS a Marine Programmer Analyst

SqlShaun
Starting Member

14 Posts

Posted - 2005-02-17 : 07:38:47

I think no-one has a clue what I am talking about as no-one has an answer. Sending me articles from google is not the solution, as you dont even know what you are reading, but think it is a solution to my problem. I am looking for a person that has experience with this sort of issues, not someone that thinks they can help or try be smart. However I do appreciate your attempts. If there is anyone out there, who uses SQL CE 2.0 on the PDA, please respond if you are familiar with integrity violations and how to solve them. error code 28549 I suspect I will not be hearing from anyone. Goodday!

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-02-17 : 08:11:43

quote:
Originally posted by SqlShaun

I am looking for a person that has experience with this sort of issues, not someone that thinks they can help or try be smart.

This is a free forum and the people on here answer all kinds of questions and give advice or pointers as to get to the solutions (right or wrong - thats what this forum is all about).

Given your criteria above, my advice is PAY someone or find the answer yourself!!

And given your attitude, yes i would say you are right you probably wont be hearing from anyone

Beauty is in the eyes of the beerholder

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-17 : 08:36:21

i doubt that anyone here has had much experience with sql server CE.
have you seen this place: http://www.pocketpcmag.com/forum/default.asp
they have a forum. maybe you'll find your answer there...

Go with the flow & have fun! Else fight the flow

SqlShaun
Starting Member

14 Posts

Posted - 2005-02-17 : 12:23:12

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-02-17 : 12:34:03

quote:
Originally posted by SqlShaun

I think no-one has a clue what I am talking about as no-one has an answer. Sending me articles from google is not the solution, as you dont even know what you are reading, but think it is a solution to my problem. I am looking for a person that has experience with this sort of issues, not someone that thinks they can help or try be smart. However I do appreciate your attempts. If there is anyone out there, who uses SQL CE 2.0 on the PDA, please respond if you are familiar with integrity violations and how to solve them. error code 28549 I suspect I will not be hearing from anyone. Goodday!

open a ticket with microsoft then.

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-02-17 : 12:49:02

Why is it that the huffy ones never fill out their bio??

"
oh yeah... where can you sing up for the model impregnation program?
"

ME TOO!!!!!!

But I cannot sing like Mladen so will have to sign.

Jim
Users <> Logic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-17 : 12:54:04

damn typos....

but hey i'd sing too not just sign...

Go with the flow & have fun! Else fight the flow

Xerxes
Aged Yak Warrior

666 Posts

Posted - 2005-02-17 : 13:06:19

So....How about singing
"Happy Birthday"
for Mladen's 25th

which is today! So, Mladen, you were born on a SUNDAY?

Semper fi, Xerxes, USMC(Ret.)
-------------------------------------------------------------------------
Once a Marine Programmer Analyst ALWAYS a Marine Programmer Analyst

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources