Look at my reply in the following thread:

http://www.sqlservercentral.com/Forums/Topic748200-149-1.aspx

Could you provide a sample illustrating what you need to do?

Please, see my reply in your other thread:

http://www.sqlservercentral.com/Forums/Topic741501-338-1.aspx

If the role is supposed to have execute permissions on every stored procedure in the database then why not grant it a database-wide execute permission?

E.g.:

grantexecute

ondatabase::your_database_name_here

tocustom_role

Note, that a database-wide execute permission...

Could you post some sample data or post the entire XML document?

This is a known, although not harmful issue with nested FOR XML queries.

You can vote for it to be fixed at Connect:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=265956

Anyway, the XML produced by the query still conforms...

What data type is used for the OutletID column in the destination table? Does the value in the source file exceed the limitations of the destination colum type?

You could use SQL CLR to access a remote resource directly from the Database Engine, but sooner or later you might end up reinventing elements that are already available in...

Have you tried uninstalling SP1 for Visual Studio?

I believe the service pack might be the culprit in this case.

Have you tried recreating the perent package?

Are you using package configurations? Perhaps you've modified one or more of the connections and haven't propagated the changes to the configuration file?

Care to tell us why you're using undocumented DBCC commands?

What's the business case behind this requirement?

Is the default collation of your database (or instance) case-sensitive?

With case-sensitive collations "@DOC" "@doc".

Sets are unordered by definition. If you want the results of a query to be returned in a specific order, you need to specify it using ORDER BY when retrieving...

If I had to choose between (i) maintaining multiple copies of practically identical modules containing pre-defined customized data (making them in effect not equal) and (ii) maintaining multiple copies of...

Those darn manuals. They know everyting!