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
What the different types of replication and why are they used? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what is the diffrence between core dba and apps dba?
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?
what functionality does oracle provide to secure sensitive information?
what is asm?
what is the use of ocr?
how can you find out if a table can be redefined?
how can you communicate with operating system files from oracle?
what is the use of recording information about current session?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how does an oracle clusterware manage crs resources?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA