is there a column to which a default can't be bound? : Sql server database administration

980

What are acid properties of transaction?

908

What are the restraints imposed on the table design by a merge replication?

994

What are the fixed server level roles? : sql server security

1061

What are audit control procedures?

947

What is the security principal at the database level that represents your session?

905

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.

2720

Explain an incremental backup?

946

What is a primary index?

888

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

924

What is sql server profiler?

962

Explain the rules for designing files and file groups in sql server?

952

Explain stored procedure?

1001

Can a table have 2 foreign keys?

860

Can we use having clause without group by?

933