what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4723

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.

1544

last function used in MS Access to convert sql what function will use in sql

827

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

684

how can u get last observation in an unknown dataset ?

1107

whats the maximum size of view state??

914

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1222

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

915

What is data modeling and Reterminal integrity?

633

If user is owning any SQL Objects, can we drop that user

830

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

772

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?

1020

tell me the disaster recovery plan

1261

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1118

Why we need to use secondry database file? though, we can do same work using primary database file also.

4176