Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
babuman
Starting Member
5 Posts |
 Posted - 2007-09-27 : 12:39:32
|
| Hi all,I am using .net 2/C# to write an application that will populate a tree with all the objects available in any given database on a particular Sql 2005 server. I am doing this using SMO. This process seems to be very time consuming. So, I would like to let the user know of the progress using a progress bar. My problem is figuring out the total objects in the selected database in the first place. Since I don't have an idea how, I am unable to properly display the percentage of completion. Can somedoby help me with this? Is there a system stored proc or even an SmoObject property to tell me this number?Thanks in advance.Babu. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-27 : 12:52:12
|
| Try sys.objects view. check books on line for what info gets stored in the view.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
How to find total objects in a Sql 2005 database