How will you handle when an replication thread goes down?
How do you check db space and what are the measures available to increase the db space?
Latest Answer: sp_helpdb gives information about memory used and available.sp_spaceused - gives space used.. ...
What do you mean by Stable Device in Sybase replication?
Latest Answer: I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco. ...
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. ...
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 ...
How is Workspace used in Sybase?
Latest Answer: I think it needs clarification. The only 'workspace' that comes to my mind here is a *.ws file from Sybase Power Designer. In that case a workspace serves as a container for physical, logical ERDs and reports, etc. ...
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 we can add a NotNull Column in a table by using alter command (without using default command)?
Latest Answer: First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True. ...
how to lock a table in sybase? give me its text command.
Latest Answer: lock table table_name in {share | exclusive} mode [wait [no_of_seconds] | nowait] ...
Latest Answer: declare @var intselect @var = 1update set @var = @var*< colname >select @var ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
