Nice one, misread the question.. I was just thinking of how many 'rows effected'...

But It reminds me again, Read/Listen what's being asked..

How?

Yep, I can create like below...

CREATE TABLE Emp(

EmpID INT PRIMARY KEY,

Emp_Name VARCHAR(100),

Emp_JoinDate DATE,

Emp_Salary Money,

Emp_Designation Varchar(50),

Emp_ManagerID INT FOREIGN KEY REFERENCES Employee(EmpID)

)

You may get issues while inserting into Emp_ManagerID , you may...

Hello Sirisha,

Did you find the solution for this?

I m planning to do the same with my current requirement. But I am dealing with only 3 file formats Text, excel...

Here is my little research on this issue.. I am not sure If its true.. Is its something like lack of permissions?

So when you are connecting remotely to the server...

Hi vardan.hakopian,

When ever you creates a database, You must had the option popup besides the window Filename.(If you want you can change this different than Logical Name)

Logical Name and Physical...

@ninja's_RGR'us: Thanks very much for this solution. I am working closer with this solution.

@Kurt W. Zimmerman: You are obsoltely right.I have done similarly before but used waitfor delay...

I didnt understand exactly what you are looking for.Can you breifley expalin ? what is the result you are getting? Is something like an error or what?

Yes standard and express edition doesn't support partitioning too, it's only possible in enterprise and developer edition