Figured it out - SA requires a case insensitive collation type for statistical & interchange data, and the default for that particular SQL box is case sensitive.
Mark. > -----Original Message----- > From: Brent Ozar [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 1 October 2003 1:22 a.m. > To: [EMAIL PROTECTED] > Subject: RE: [SA-list] Stats table not being populated > > > I've been doing stats logging to Microsoft SQL Server 2000 > since 4.0 came > out, and it works fine for me. I'm currently using build > 1506 with the MSN > fix, but it was working last week with 1498. > > Brent > > > -------------------------------- > Brent Ozar - UniFocus > -------------------------------- > "I hate the outdoors. To me the outdoors is where the car is." > Will Durst > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of [EMAIL PROTECTED] > Sent: Monday, September 29, 2003 8:39 PM > To: [EMAIL PROTECTED] > Subject: RE: [SA-list] Stats table not being populated > > > I have the same issue logging to MSSQL2k - logging of debug > data to SQL > works fine, as does statistical logging to a file. Statisical > to SQL is a no > go though. > > This is with build 4.0.1503 BTW. > > Mark. > > > -----Original Message----- > From: Chris Robinson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 17 September 2003 7:33 p.m. > To: [EMAIL PROTECTED] > Subject: [SA-list] Stats table not being populated > > > Hi All, > > I am logging servers alive data to a MySQL database. The > interchange and > logging tables are being populated but the stats table isn't. > Does anyone > have any ideas why this is so? Are there any settings that I may have > neglected to set? > > cheers, > Chris > > > To unsubscribe from a list, send a mail message to > [EMAIL PROTECTED] > With the following in the body of the message: > unsubscribe SAlive > Milburn New Zealand Ltd. has changed its name to Holcim (New Zealand) Ltd. Please visit our new web site http://www.holcim.com/nz This e-mail is confidential and only for the use of the intended recipient. If you have received this e-mail in error, please delete it immediately and notify us by e-mail or telephone. To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
