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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How would you extract DDL of a table without using a GUI tool?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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
What types of replication are supported in sql server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the last version,the release date of that version and fix pack of ibm db2 udb?