A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

What are the types of subquery?

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,

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

What are the default system databases in sql server 2000?

0 Answers  

---

---

What is Extended user-defined?

0 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

Define Joins?

0 Answers   HCL,

---

How to rename databases in ms sql server?

0 Answers  

---

What is sql server english query?

0 Answers  

---

What is 2nf normalization?

0 Answers  

---