Answer / oliva

Actually If we specified a username & pwd

in connection string and we are using

Integrated Security=SSPI ...

Answer / ankur negi

If your application runs on a Windows-based intranet, you
might be able to use Windows integrated authentication for
database access. Integrated security uses the current
Windows identity established on the operating system thread
to access the SQL Server database. You can then map the
Windows identity to a SQL Server database and permissions.

To connect to SQL Server using Windows integrated
authentication, you must identify the Windows identity under
which your ASP.NET application is running. You must also be
sure that the identity has been granted access to the SQL
Server database. This topic includes a code example that
displays the current Windows identity of the ASP.NET
application.

What can be used instead of trigger?

0 Answers   ADITI,

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

Explain the properties of the relational tables?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

---

Will the writetext statement activate a trigger?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

What is named calculation? : sql server analysis services, ssas

0 Answers  

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

In what sequence sql statement is processed?

0 Answers  

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---