wat is the main diff between sql server 2000and sql server 2005
Answer Posted / hari
In 2005 More features is available
Database Mirroiring
CLR Integration(Common language Runtime ) Integration
Management Studio
SIS Package
mirror backup
DAC(Dedicate Administration Connection)
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are different types of statement?
What is service broker? : sql server database administration
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are pages and extents? : SQL Server Architecture
why would you call update statistics? : Sql server database administration
What is the difference between varchar and nvarchar datatypes?
What is relationship? What number of sorts of relationship are there?
What is a rownum?
Explain security with sql azure?
Name some of the open source software that you can use in alternative to SSR?
What are the lambda triggers?
What is a transactions?
What is snapshot parameter in ssrs?
How do you migrate data from mssql server to azure?
Explain transaction server isolation?