This job already has one schedule that runs on the first of the month. However, we need to run the job on a different schedule if the first of the...

In response to frederico_fonseca

This job already has one schedule that runs on the first of the month. However, we need to run the job on a different schedule if the...

Jeffery, thanks for the direct answer that I was looking for "As for changing system objects - no."

I later spoke with a Microsoft Support Manager, and he provided the following:  "Any...

Mr. Brian Gale, I just want to say thank you for such a detailed and thorough response to my post. The information you provided was very helpful and we have...

The upgrade involves the DB Engine, SSIS, SSAS, and SSRS. Microsoft informed me to stop SSRS. I guess I will leave the other services running. With older SQL Server versions,...

Thanks Eric that would work also. I ended up placing the user in the db_datareader database role and the db_denydatawriter database role. It appeared that when I put the user...

Thanks for your responses Jonathan and Lynn!

Jonathan, I think your response provides some pros/cons of the two methods.

Lynn, regarding your question, "My question is why are you shrinking the transaction...

Thanks Grant for the feedback. I see these terms used interchangeably on resumes a lot. For example, I perform comprehensive database management tasks or I do comprehensive database administration tasks. This...

Thanks Sue and Jeff for your suggestions.

Thanks Sue_H. Your suggestions are a HUGE help!

Thanks again Sue. Now, hopefully my last question, now that I have added the GRANT CONNECT permission to the db role and removed it from the individual developer db user,...

Thanks Sue. 

Another permissions related question, I removed permissions from the individual developers' db users, created a db role, assigned permissions to the db role, and then made the...

Here is what I am trying to accomplish. I would like to be able to give a developer the GRANT EXECUTE TO [Login or DBRole] WITH GRANT Permission so they...

I may may not have asked this clearly in my earlier posts but what I really want to know is what is the least privilege method to allow a...

I am receiving the following error when I GRANT Execute on the stored procedure to the db role:

USE [DBName]

GO

GRANT EXECUTE ON [SchemaName].[StoredProcedureName] TO [DB Role];

Msg 15151, Level 16,...