Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Update stats error Expand / Collapse
Author
Message
Posted Thursday, October 7, 2010 3:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 10, 2011 9:17 AM
Points: 9, Visits: 82
Update stats error : -2147218798
Post #1000227
Posted Thursday, October 7, 2010 3:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 42,437, Visits: 35,492
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 2008, MVP
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

Post #1000235
Posted Thursday, October 7, 2010 5:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:11 AM
Points: 7,128, Visits: 6,291
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

How to post code questions


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1000312
Posted Thursday, October 7, 2010 8:53 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:55 PM
Points: 21,204, Visits: 14,889
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1000579
Posted Thursday, October 7, 2010 9:43 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:13 AM
Points: 3,998, Visits: 6,053
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? -- Stephen Stills
Post #1000645
Posted Friday, October 8, 2010 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 10, 2011 9:17 AM
Points: 9, Visits: 82
HI,

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

It says


update stats failed -2147218798
Post #1001108
Posted Friday, October 8, 2010 3:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 42,437, Visits: 35,492
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 2008, MVP
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

Post #1001123
Posted Friday, October 8, 2010 3:58 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:05 AM
Points: 563, Visits: 999
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
Post #1001124
Posted Friday, October 8, 2010 4:10 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 42,437, Visits: 35,492
grahamc (10/8/2010)
how on earth are you South African


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



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1001137
Posted Friday, October 8, 2010 4:16 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:05 AM
Points: 563, Visits: 999
GilaMonster (10/8/2010)
grahamc (10/8/2010)
how on earth are you South African


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


Im the same, except Im Welsh grew up in SA, primary high school...
Post #1001145
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse