wht's the differece between sqlserver05 and sqlserver2000
Answer Posted / jerry joseph
.NET Runtime integration
SQL Server 2005 is integrated with .NET Runtime
Email sending capability
You can send emails from SQL Server 2005 which you couldnt
do with SQL Servr 2000
TRY CATCH error handling
In SQL Server 2005 we have TRY CATCH for better error
handling. We had only @@ERROR in SQL Server 2000 which was
very primitive
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a recursive stored procedure in sql server?
Explain how to use linked server?
What is the contrast between sql and mysql?
What types of Joins are possible with Sql Server?
What are the different types of collation sensitivity in sql server?
What are the indexes in sql server?
What is difference in performance between insert top (n) into table and using top with insert?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What is use of except clause? How it differs from not in clause?
Write the SQL query to drop, truncate and delete table.
What is a unique index?
What is the current limitation of the size of SQL Azure DB?
What are different types of roles provided by ssrs?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do