When we create a user with database db_datareader it restricts on all tables. My requirement is :

1. Should not be able to modify any table

2. Should be able to update...

Thanks Cozyroc !!

Thanks Cozyroc once again !!

One more small query - what rights do we need to set on folder storing the package ?

Also the system I am going to deploy my package will not have SQL server installed in it. It will be just a web server. Integration Services is a part...

Thanks Cozyroc.

By SSIS Framework you mean Integration Services. Right ?

Also what about the sharing part ? Do we need to set some sharing rights on the folder storing...

As I mentioned in 2nd point, we need to cpoy selective data depending on user input. So its going to be dynamic at runtime. Its not a one time process.

That was a good explanation. But how to avoid this problem in future ? Is there a problem with indexes which processes wanted to acquire or there is a problem...

Sorry the image could not be loaded properly earlier. Also xml contents are as below.

...

I just want to store XML in Database. Dont want to enforce schema on it. Dont want to update portions of it.

If XML gets modified, just want to update the...

Thanks for all the help Guys !! Will try to find out the best solution for my scenario...

But that would mean creating 20 SP's more...that would be more difficult to manage. Any other possible solution ?

Ok. I got it.

convert(datetime,'09/17/2008',101)

Earlier I was misunderstanding above statement. What I thought was above statement converts the given date in 101 format. But actually it means that we want to...

Yes...SP is writing to a single temporary table based on the condition and then that temporary table is returned at the end.

Use

set @key = scope_identity()

and not @@identity.

It gives incorrect value for different sessions.

Thanks to All.