nice question to start Monday morning.

Thanks for sharing

good QotD.. thanks for sharing

Koen Verbeeck (11/13/2013)

---

First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

Secondly, developer is the same as enterprise feature-wise,...

good question .. thanks for sharing

indeed ...

nice question to end the week, my week got extented this time :hehe:

thanks for sharing !!!

its not the folder access which is causing the issue, its the Bulk insert task which required sysAdmin, BulkAdmin role associated with the User Login.

you can check it if you...

check if BulkAdmin rights are assigned to the user which you are connecting to database.

happens 😉

nice question .. Thanks for sharing

and nice DP Steve 😛

steve.jacobs (11/4/2013)

---

twin.devil, you stated it perfectly, it is a trap...

place a parentID column ... following will be the values in the...

Better practice is to maintain a sequence column in the table.

Anyways following is the query ....

Declare @tblTemp table ( ID int identity(1,1)

, houseno varchar(25)

)

Insert into @tblTemp

Select '3-13-1' union...

Its a boobby trap ... 🙂

🙂

excellent QotD , things aren't so straight as they seems right 😛

thanks for sharing