 Related Questions Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database. Latest Answer : Defncopy is a sybase tool that defines the objective statements such views, triggers, defaults,rules and so on ... Read Answers (2) | Asked by : James What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and In real time when we go to truncate the log? Read Answers (1) | Asked by : srihari Latest Answer : 1. Select * from <database name>..<Table name> 2. Use <database name>
go ... Latest Answer : The minimum table size is equal to 1 extent (that is equal to 8 pages). ... Latest Answer : In pre sybase 15 all database options will take effect after a use database and checkpoint command is run.For Sybase 15 the option take effect immediately since all sp_dboption commands have an automatic checkpoint. ... Read Answers (1) | Asked by : srihari A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ? Read Answers (5) | Asked by : Karthi How will you purge data from audit database? Latest Answer : To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get the data into a more persistent location. From there ... What are the default size of master database in sybase ? Latest Answer : The default size of a master database in sybase is 6MB for a 2K page size Adaptive server. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
