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 are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is a system database and what is a user database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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 is the use of ocr?
What are the steps you will take to improve performance of a poor performing query?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you enable flashback feature?
how can you process messages in order asynchronously?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is replication? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is a crs resource?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA