View filegrop

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Mar 2008
Posts: 136
Reputation: cVz is an unknown quantity at this point 
Solved Threads: 7
cVz's Avatar
cVz cVz is offline Offline
Junior Poster

View filegrop

 
0
  #1
Dec 17th, 2008
hey there lovely people, i am trying to make an application that makes database backups, now obviously i need to add the file / filegroup backup option too , which is not a problem except for this one little problem...

How can i get the application to display a list of all the primaries and and FG's ?

I realized that this would have to be done because not all administrators use the same naming structure ...

If anyone could at least just give me an idea of where to go, thank you in advance ...
Delphi & C# programmer deluxe...
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2008
Posts: 136
Reputation: cVz is an unknown quantity at this point 
Solved Threads: 7
cVz's Avatar
cVz cVz is offline Offline
Junior Poster

Re: View filegrop

 
0
  #2
Dec 17th, 2008
sql Syntax (Toggle Plain Text) 
  1. SELECT FILEGROUP_NAME(1) AS [Filegroup_Name];

This works cool and all , but i want all the stuff to display in one listbox ....
Last edited by peter_budo; Dec 17th, 2008 at 8:15 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Delphi & C# programmer deluxe...
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2004
Posts: 4,267
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 493
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: View filegrop

 
0
  #3
Dec 17th, 2008
Exact procedure depends on the programming language, but idea is same. Collect your results from DB, store it in Vector/Array/List and pass it to your application GUI to display in combo box or similar
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the MS SQL Forum


Views: 457 | Replies: 2
Thread Tools Search this Thread



Tag cloud for MS SQL
"last autogrowth business connectingtodatabaseinuse count cursor data database dateadd datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit live loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC