SQLTeam.com | Weblogs | Forums

SQL TrsndNXtI have some doubts...could you please clear it


#1

1)Procedure to resolve login issues??
2)Automatic failover is not supported in??
a)mirroring)Clustering
c)Log Shipping
3)Repair option work in DBCC checkDB/DBCC CHECKTABLE kept only for backward component
1)repair fast
2)repair build
3)repair allow
4)repair loss

4)To know latest SP installed. Commane
a)@@version
2)@@Servicepack

5)Sysytem table allocated in :
1)Primary file group
2)Secondary filegroyp

6)Details of db?
a)sp_helpdb
b)xp_helpdatabase
c)sp_help

7)db not used in sql server?
a)db owner
b)db accessadmin
c)db security admin

8)which of the following supports replica in sql server2008 and later version?
a)mirror to
b)copy t0
c)move to

9)Best tool used to change the login account details of the user realetd tpo SQL??


#2

these questions all have easy-to-find answers via google


#3

I couln't find..Could you please answer them


#4

then you haven't tried. e.g. for q8

replicaion