Sql Server 2005 contain .net frame work is inbuild. but 
2000 contain is not available.

Sql Server 2005 Contain Good Reporting services available. 
but 200o contain is not available.

1.through satellite assembly we can develop assembly and 
(if we want to use in any language like chines,etc and we 
can use it anywhere}


2. garbage collector run after a particuler point of time 
may depends on memory requiremtnt or time
first garbage collector check unused resources from memory
from generation first(which is L2 cache)and then find any 
references in genertion second(RAM)and then in third 
generation (virtual memory)

when garbage collector find any unused resources, it put 
that object in finalizition quere, for destruction of 
object and free memory from unused resources

and there is a thread is associated with which free objects 
one by one from this queue

and we can call  explicitly  the GC
like GC.collect(int )(here int is the generation number)

Satellite assembly:Assembly containing no executable code—
only resources. Typically, satellite assemblies are used 
for storing localized data. Satellite assembles can be 
added, modified, and loaded into a .NET application at 
runtime without recompiling. Use the Assembly Linking 
Utility to create satellite assemblies by 
compiling .resource files.

Satellite assemblies are often used to delpoy langauge-
specific resources for an application.  These language 
specific assemblies work in side-by-side execution because 
the application has a separate product ID for each language 
and installs satellite assemblies in language-specific 
subdirectory for each language.

As u r not interested, better try 4 new oppurtunities only.
But, u should be prepared for giving the apt answer as the
interviewers will definetely ask u abt the Gap.

Landscape is nothing but, it is a combination of Sandbox, 
development server, quality&assurence server and 
production/golden client server.

In development server the implimentation will be done, what 
ever the business enarios we have implimented in sandbox.
 mail me on ckreddyg@yahoo.com for more details.

Development Server, Quality Server and Production server

Development server is where the consultants do the 
customization as per the company's requirements.

Development Server - Where the consultants do all 
customisation / configuration

Quality Server - Where the Core Team persons test the 
configuration 

Production Server - Where users will do their routine tasks.

The cost center from PA side is aavaliable in Infotype 0001 
basically. But you can also use IT0027, IT0315, IT 0017 for 
Travel management.

cost center will be used in 0001 infotype.

Cost Center will be USed in Infotype 001 - Organisational 
Assignment

Infotype 0027 is used for cost centre.

You can also maintain cost center in IT0017 for TYravel 
management

These are the three different security model connecting to 
Linked Server. 

In Self Mapping SQL Server tries to connect to the linked 
server using current users credentials(UserId and PWD).

In Delegation SQL Server tries to connect to the Linked 
server by using the Windows credential.

In Remote Credentials the Local login credential is mapped 
into remote credential.

copa means particular entity wise see the profit or loss.
entity means product wise,or customer wise,or business area 
wise,or company code wise.

Profitability Analysis (CO-PA) enables you to evaluate 
market segments, which can be classified according to 
products, customers, orders or any combination of these, or 
strategic business units, such as sales organizations or 
business areas, with respect to your company's profit or 
contribution margin.

The aim of the system is to provide your sales, marketing, 
product management and corporate planning departments with 
information to support internal accounting and decision-
making.

Two forms of Profitability Analysis are supported: costing-
based and account-based.

Costing-based Profitability Analysis is the form of 
profitability analysis that groups costs and revenues 
according to value fields and costing-based valuation 
approaches, both of which you can define yourself. It 
guarantees you access at all times to a complete, short-
term profitability report. 
Account-based Profitability Analysis is a form of 
profitability analysis organized in accounts and using an 
account-based valuation approach. The distinguishing 
characteristic of this form is its use of cost and revenue 
elements. It provides you with a profitability report that 
is permanently reconciled with financial accounting.
You can also use both of these types of CO-PA 
simultaneously.

Hi,
COPA is not similar to other modules in SAP. You may look at
it as a database or even a table with certain
characteristics and key figures. 

Several financial and logistic flow arrive in COPA:

    * Sales order (if you have activate the uptade in the
custo) : document generate in COPA with document type A.
Every time you have a forecast in a sales orders
    * Customer invoice : document type F: every time you
have a billing in SD
    * settlement of the cost center : document type D : the
COPA document is generated when you execute the KEU5 transaction
    * Settlement of the internal order : document type C :
the COPA document is generated when you execute the KO88
transaction
    * direct posting from FI to COPA : document type B

For each flow, you have to do customizing uder SPRO/
controlling / profitability analysis.

Thank You.

We can't create Uncecked Exceptions

You can create unchecked exception by inhereting
RuntimeException class. Spec does not say that we can't do
it but it is advisable to go for custom checked exception

There are some exceptions that are not defined by java api
ex- invalid age exception ,invalid number exception etc.

in user defined exceptions are raised by programmer,
thrown by programmer ,handled by programmer

while predefined exceptions are raised by system,
thrown by system
handled by programmer

user defined exception is used throwing out(user) own
exception..

Yes,

public class UnCheckedExceptionExam extends RuntimeException
{

public UnCheckedExceptionExam(){
System.out.println("No argument");
}
public UnCheckedExceptionExam(String message){
System.out.println(message);
System.out.println(initCause(new Throwable("define 
exception")));
}
public UnCheckedExceptionExam(Throwable cause){
System.out.println(cause.getCause());
}
public UnCheckedExceptionExam(String message,Throwable 
cause){
System.out.println(message);
System.out.println(cause.getCause());

}
}

We can use Traceability Matrix for Test Coverage.

Mapping the Requiement No with the Test Cases and with the 
Given Build

Through Traceability matrix which can be used to track back
the test cases with requirements to ensure that nothing is
missed

by using traceability matrix we mapp test cases and 
requirements, so by this if any requirements are not 
satisfied for that requirements we write test cases so by 
this we can ensure 100% coverage testing

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

select count (*) from tablename.

@Anshul..
Bro..through your code u can obtain the Total numbers of 
rows in your Table.
---------------------------------

For getting Total Columns i will use this:

SELECT Count(*)As Coloumns 
FROM Sys.SysColumns
Where ID = 
(SELECT ID FROM Sys.SysObjects Where Name = 'YourTableName')

--Count of Columns
SELECT COUNT(*) NO_OF_COLUMNS
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID

--Column Names 
SELECT [NAME] 
FROM SYS.COLUMNS
WHERE OBJECT_ID = OBJECT_ID('<TableName>')
ORDER BY Column_ID

IN SQLSERVER 20005 


SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = N'TABLENAME'


try in sql server 2000

None of the above answer can result the columns which is 
having auto incremented (Identity).
Also if a column is binded to user defined data type that 
is also  excluded....
So the Correct Number of column cannot be resulted in the 
above answers.........