• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1799
  • Last Modified:

EXEC sp_msforeachtable 'sp_spaceused ''?'''

This is related question to
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21786711.html
Please read original question also and if you can help there it would be helpful.

I can use this syntax to retrive all the size of the table. Can I also retrive the datecreated of the table ?

EXEC      sp_msforeachtable 'sp_spaceused ''?'''  

Regards,
0
pinaldave
Asked:
pinaldave
1 Solution
 
pai_prasadCommented:
0
 
pinaldaveAuthor Commented:
Select name
from sysobjects
where type = 'U'
     and crdate <= dateadd(m,1,getDate())
     and name like 'MyTmp_%'

This is the correct answer and is part of the original question.
Though this is separate question, I am sure I can assign points for that.

Kind Regards,
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now