Are there any system stored procs to report the stats and metadata of a database itself in SQL Server 2005? What I need is a quick way to output a list of tables, the size of each table, the number of rows in each table and so on. Stored procs for individual tables and metadata would also be useful. Advice appreciated. ...
Whats the best, most consistent way to check if a table exists in NHibernate (or with Fluent-Nhibernate)? Is it even possible? I mean it seems like a simple task for such a heavy-duty ORM. Also on a related question, can you check if a set of tables or a whole schema exists with NHibernate? ...
I'm trying to figure out a way to get the underlying SQL table name for a given entity type. I've experimented around with the MetadataWorkspace queries and while I can get lots of information from the object or the storage space, I can't seem to figure out how to map between the two. So say I have a type in the object model called Look...