What is role playing dimension with two examples? : sql server analysis services, ssas
No Answer is Posted For this Question
Be the First to Post Answer
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,
What are the database roles? : sql server security
Which command is used for user defined error messages?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is the difference between constraints and triggers?
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
What is a primary key?
What is trace flag in sql server?
What are null values in ms sql server?
Can you pass expressions to function parameters?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How to automatically create a log when an exception is being received into SQL Server?