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 is the role of dip user in our database?
what is the use of recording information about current session?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different types of replication and why are they used? : sql server DBA
how does an oracle clusterware manage crs resources?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you connect from 10g user to 11g user??
how can you find out if a table can be redefined?
how can you schedule a job in database?
What the different components in replication and what is their use? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
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?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?