How we can transfer balance gl from one fiscal year to another fiscal year? plz, give in detials, it's urgernt.
3 10241Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
2 6616How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
1 3243When we are using this query to shrink the log file,what
exactly it will execute internally? Do we lose any data
when we run this script? which data it will truncate in the
log file and where it is saved. Please let me know...
USE DatabaseName
GO
DBCC SHRINKFILE(
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
1 4608I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 27925There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
1 5705Post New Cognizant Interview Questions
What is a function call or a callable object in python?
How you can remove a rule from security group?
explain supply side and demand side energy management with advantages & disadvantages
have u done any performance tuning? how u ll do?
how to do the batch testing in test director using manual testing procedure?
What is verbose_name in django?
In what way program "hello world" you can write in vbscript?
What is the output of this below query?
How do I format columns in word?
What is the rpa tool did you used and explain the architecture of the tool?
For an AND-OR implementation of a two input Mux, how do you test for Stuck-At-0 and Stuck-At-1 faults at the internal nodes? (You can expect a circuit with some redundant logic)
Define excel bi toolkit?
What are the several dijit layout widgets?
What do we mean by Redemption of shares and debentures?
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table by using proc sql?