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
how can you get actual data change values from previous transactions in oracle?
What is a correlated sub-query? : sql server DBA
How to start SQL Server in minimal configuration mode?
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?
how can a session indicate its interest in receiving alerts?
internal architecture
how can you initialize log miner?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what do you understand by fine-grained auditing?
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.
how can you record information about current session?
What are the recovery models for a database? : sql server DBA
what are the differences of where and if in SAS?
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?
how can you find out if a table can be redefined?