Answer / guest

Windows mode and mixed mode (SQL & Windows).

Answer / guest

there are two authentics in sql server.
1- windows authentics
2- sql authentic

Answer / rajkumar v

1.Windows authentication
2.Mixed authentication(SQL Server and Windows
authentication mode)

Answer / dupinder singh

SQL Server 2008 offers two authentication mode options:

Windows authentication mode requires users to provide a
valid Windows username and password to access the database
server. In enterprise environments, these credentials are
normally Active Directory domain credentials.

Mixed authentication mode allows the use of Windows
credentials but supplements them with local SQL Server user
accounts that the administrator may create and maintain
within SQL Server.

check, not null,unique

2 Answers   IBM,

---

Explain how many normalization forms?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

Can binary strings be converted into numeric or float data types?

0 Answers  

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

what are constraints? : Sql server database administration

0 Answers  

---

Write query to return all rows sql?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Explain transaction server consistency?

0 Answers  

---

Can we add our custom code in ssis?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---