Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SMS Database Full
- Thread starter ehawk01
- Start date
Could be the size of machinedatahistorytable
if so from T-SQL
USE SMS
select * from machinedatahistorytable
this will find the earliest timekey
Then
USE SMS
delete from machinedatahistorytable where timekey <'mm/dd/yyyy'
(earliest date) this should free up some space
if so from T-SQL
USE SMS
select * from machinedatahistorytable
this will find the earliest timekey
Then
USE SMS
delete from machinedatahistorytable where timekey <'mm/dd/yyyy'
(earliest date) this should free up some space
- Status
Similar threads
- Locked
- Question
- Locked
- Question