what are three different authentications to connect linked
servers?
Answer / vidhya sagar
Self mapping
Delegation
Remote Credentials
| Is This Answer Correct ? | 5 Yes | 0 No |
Explain primary key and foreign key constraints?
How to create a local temporary stored procedure?
What is a function? Give some example?
What happens to a trigger with multiple affected rows?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Are semicolons required at the end of sql statements in sql server 2005?
What does the on delete cascade option do?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is nonclustered index on computed columns?
Explain about nested stored procedure?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is meant by indexing files?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)