What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

Explain how does the report manager work in ssrs?

0 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

---

How to make a column nullable?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

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

0 Answers  

---

What are transactions and its controls?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---