 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 : declare @source varchar(30)
select @source = "10.236.155.17"
while charindex(".",@source) > 0
begin
select @source = stuff(@source,charindex(".",@source),1,",")
end
select @source ... Read Answers (2) | Asked by : Sarathy 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 What is the use of 'with check' option in views? Latest Answer : When you create a view using the with check option clause, each insert and update through the view, is validated against the view’s selection criteria. If the rows inserted or updated are out of criteria then it fails and gives error message. For ex, ... 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
