[MS SQL2005] How to query table and stored procedure last modify date

In the MS SQL Management Studio. Although I can find the table create date in summary page, but sometimes I need know last modify date ,but i only find create date .

But,we can find so many information in sys.all_object .

You can use this sql statement query table information



select [name],create_date,modify_date FROM sys.all_objects where type_desc = 'USER_TABLE'



You can use this sql statement query stored procedure information



select [name],create_date,modify_date FROM sys.all_objects where type_desc = 'SQL_STORED_PROCEDURE'
and substring([name],1,3) not in ('sp_','dt_','xp_')



Why we need to filter 'sp_,dt_,xp_' ,because they are at beginning of sql server system stored procedure name.

©Yichen

[ASP.NET] VS2005 ReportViewer V.S IE7

When i use vs2005 ReportViewer control to show local reports,I encountered a problem that the horizontal scrollbar is disappear on IE7!
I feel very said about it. Because both are Microsoft products.

So I open the html code . I found the "div" tag maybe coverage each other ,because the bottom margin is too small.
I add a ReportViewer attribute about "div" style.


ReportViewer1.Attributes.Add("style", "margin-bottom: 70px;");


I solve it .


This problem doesn't occur in vs2008. I think that's a good news.

©Yichen