i have daily SSRS reports hitting that table for SQL app log errors, failed logins, etc that go back a few days and i'm pretty sure it doesn't subtract milliseconds....

there is a vb script on all the servers to dump data to a staging table for that server. then this import job runs to copy only the new data...

This is the table

USE [logs]

GO

/****** Object: Table [dbo].[sql_server_logs] Script Date: 12/01/2010 10:14:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[sql_server_logs](

[EventLog] [varchar](255) NULL,

[RecordNumber] [bigint] NOT NULL,

[TimeGenerated]...

got it figured out with help from the MSDN forums

if there are no events it's not a 0, but a null or some other kind of value. i've had this...

what about just running perfmon all the time? on our DBA server we monitor a few hundred counters from all our servers

made me think of Spinal Tap

got it installed, this one does go to 11

is this for MS Access? just set a low timeout value on the server level

are you getting any 14151 errors in the app log and pop ups on the console. you have to check the actual console and not RDP.

and have you checked the...

what's the error? are these personal owned iphones or company owned? any difference in the apps installed? any jailbroken? was it with the default Safari browser or one of the...

how are you going to get the image to the DR site? you can ship it via SAN replication software or if you use Netbackup or something similar for backups...

have you tried to test it using SSMS? it could be relay settings or a number of different things

ask your email admins to look in the smtp logs as well

which iOS version are they on?

is ssrs 2008 r2 serving it as excel 2007 format and they are saving it in an earlier version?

just tried it on my iphone 3GS...

i have log files that are larger than that, unless you need the space there is no reason to shrink

what are you going to do with blank hard drive space...

GilaMonster (11/9/2010)

---

Joshua T. Lewis-378876 (11/9/2010)

---

Simon,

Just as an FYI, Microsoft has depreciated the TRUNCATE_ONLY option in SQL 2008, and you have to use a different option in the BACKUP LOG command:

BACKUP...