Registration is simple, painless and free! All you need to do is provide a name and email. Once you are registered you will have full access to the site, which includes the FREE Award Winning SQLRanger™ application, Standards Booklet, Install Checklist, as well as scripts and other useful stuff.
CREATE ROLE db_executor
GRANT EXECUTE ON SCHEMA::schema_name TO db_executor
exec sp_addrolemember ‘db_executor’, ‘Username’
So, this article ruffled a few feathers. I believe it’s because of the provocative title. I wrote the title that way so that I could, “Catching the Readers Attention”. The truth of course is that not EVERY SQL Server will be a cluster, but the point I was trying to make is that you should consider using clustering for the reasons I state in the article. All valid reason, in my opinion.
Check out my article over on SQLServerCentral http://www.sqlservercentral.com/articles/cluster/108625/
It’s finally out. SQLRanger is sporting a new monitor interface.
Check it out in the tools section.