Here is one solution perhaps the best I've learned so far:

// Transact-SQL

REVOKE privilege_name

ON object_name

FROM {user_name |PUBLIC |role_name}

// Example

REVOKE DELETE

ON TransactionRecordsTable

FROM employee

I've been reading BOL but the nuance you provided is not there so thanks for some added clarification.

Thanks for the clarification. The link shown about and your comments help explain this type of login

Thanks for the link... both explanations help a lot

I agree as I presumed connecting from a remote website with correct connection string should be no different than connecting remotely using Visual Studio or Management Studio --however-- my own...

Thanks Craig.

Yes, I'm trying to cope with a now arrogant ripoff hosting provider WebHost4Life (HostServerA) that has refused to update ASP.NET for the past 21 months after being acquired by...

Storing XML in SQL2005 is in demand and for ASP.NET developers who have to learn to wear the dba hat the entire database process is murky. Especially for RSS web...

This issue has been resolved.

Load the URL [1] and scroll down the page or use Edit > Find to locate "Distributed Transaction Coordinator failed to start" Follow the procedure which throws an...

Yes, it was failing with the same message. Thank you for replying Joseph. Late last night I resolved the problem with SQL server 2005 and as it turns out the...

Custom Settings are configured to support cookies.

Is my browser being asked to access a datasource

across a domain?