I was in the File Explorer Window and went to the File Menu and then clicked on the cmd prompt.

the cmd prompt window opened with the:

1>

2>

and so on.

I was able to run the cmd prompt and execute sql statements.  It had the 1> prompt in the screen.

I could not find a sqlcmd.exe or a sqlcmd.bat.  I did...

Microsoft SQL Server 2012 ( SP1 ) - 11.0.3156.0 (X64) May 4 2015 Express Edition 64-bit

what is the difference between tables like:

OrionAuditLog

OrionAuditLogMT?

Seems the only thing to do is...

I think it is Express. How do I tell?

I wil try expanding the db as per the note.

thanks.

If I run this cmd:

select count(*) from ePO_MS.dbo.EPOProductEvents

where DetectedUTC < DATEADD(dd, -30, getdate())

------

1147

A straight table select returns 1277.

I don't have a table EPEEventParameters?

I don't believe this is SQL Express. ...

is it possible to truncate the ProductEvent table? Instead of deleting from it?

thanks.

It is SQL Server 2012 and is hosted on the C drive. The C drive has 12 gb of free space.

thanks.