Update stats error

Question

Update stats error

zeenister

SSC Enthusiast

Points: 113
More actions
October 7, 2010 at 3:26 am

#224822

Update stats error : -2147218798

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Eh?

I don't know what you're asking, what the context is or anything. If you want help you're going to have to give a fair bit more information about the problem.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 2

Google your error. See what you come up with. When you get confused, refer to these threads:

How to ask questions

How to post problems[/url]

How to post code questions[/url]

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

What were you doing when you got that error?

How did you arrive to this error?

Do you have any other errors to go with it?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 4

Who are you?

Who sent you?

Why are you following us?

😛

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

zeenister SSC Enthusiast Points: 113 More actions · Answer 5

HI,

I recieved this error when update stats failed and i picked this error no from the logs.

It says

update stats failed -2147218798

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

That's still of no use. That number is not a SQL error number (which are between 1 and 50000). You haven't said what you're doing exactly? A maint plan? A custom job? Something else? you haven't said where you saw that error. Which log? Any other information at all?

Please remember I can't see your screen and I can't read your mind.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

grahamc SSCertifiable Points: 6762 More actions · Answer 7

GilaMonster (10/8/2010)
That's still of no use. That number is not a SQL error number (which are between 1 and 50000). You haven't said what you're doing exactly? A maint plan? A custom job? Something else? you haven't said where you saw that error. Which log? Any other information at all?
Please remember I can't see your screen and I can't read your mind.

Thankfully, you are a lot MORE patient than me... how on earth are you South African :hehe:

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

grahamc (10/8/2010)
how on earth are you South African :hehe:

I'm British (birth and descent). I live in South Africa (and have for quite some time)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

grahamc SSCertifiable Points: 6762 More actions · Answer 9

GilaMonster (10/8/2010)
grahamc (10/8/2010)
how on earth are you South African :hehe:
I'm British (birth and descent). I live in South Africa (and have for quite some time)

Im the same, except Im Welsh :alien: grew up in SA, primary high school...