What is the difference between push and pull subscription? : sql server replication
How the authentication mode can be changed?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
Working with TLogs
How to create a trigger for insert only?
what is difference between Enterprise Manager and Query Analyer
Why variables called the most powerful component of ssis?
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is a database in ms sql server?
Where are magic tables stored ? Is it in the same database where it is created ?
What is sql server replication? : sql server replication
Explain what is meant by replication of database?