Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do you resize a data file?

Answer Posted / monal

in SQL Server 2005:

ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)

Is This Answer Correct ?    9 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you get actual data change values from previous transactions in oracle?

1083


What is a correlated sub-query? : sql server DBA

1075


How to start SQL Server in minimal configuration mode?

7952


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2498


how can a session indicate its interest in receiving alerts?

1037


internal architecture

2184


how can you initialize log miner?

1135


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1031


what do you understand by fine-grained auditing?

1049


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2559


how can you record information about current session?

1040


What are the recovery models for a database? : sql server DBA

1124


what are the differences of where and if in SAS?

2185


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3403


how can you find out if a table can be redefined?

1004