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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Is it possible get the size of the folder

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2009-11-03 : 09:53:13
I have a folder D:\Projectfiles\DUS
There are thousands of files in it, is it possible to get the size of the fo,der in MB's.

Thank you very much for the helpful information.

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-11-03 : 10:46:47
Other than just hovering over it with your Mouse Pointer?

Google is your friend

http://wiki.sqlis.com/default.aspx/SQLISWiki/File%20Size.html

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2009-11-03 : 15:26:19
JimF, I don't think you read my question, i do know how to using C# or VB.net or classic vb.

But want to see if there is a way to get the info via sql server.
Thank you.
quote]Originally posted by jimf

Other than just hovering over it with your Mouse Pointer?

Google is your friend

http://wiki.sqlis.com/default.aspx/SQLISWiki/File%20Size.html

Jim

Everyday I learn something that somebody else already knew
[/quote]
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-03 : 15:31:07
Sure

http://weblogs.sqlteam.com/brettk/archive/2005/06/28/6895.aspx



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-04 : 03:16:18
Remove where clause and try
http://sqlblogcasts.com/blogs/madhivanan/archive/2009/05/07/how-to-find-size-of-backup-files-in-a-folder.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2009-11-04 : 07:35:25
Thanks Madhivanan.


quote:
Originally posted by madhivanan

Remove where clause and try
http://sqlblogcasts.com/blogs/madhivanan/archive/2009/05/07/how-to-find-size-of-backup-files-in-a-folder.aspx

Madhivanan

Failing to plan is Planning to fail

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-06 : 02:28:45
quote:
Originally posted by cplusplus

Thanks Madhivanan.


quote:
Originally posted by madhivanan

Remove where clause and try
http://sqlblogcasts.com/blogs/madhivanan/archive/2009/05/07/how-to-find-size-of-backup-files-in-a-folder.aspx

Madhivanan

Failing to plan is Planning to fail




You are welcome

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -