Distribution is used in replication.

http://msdn.microsoft.com/en-us/library/ms183524.aspx

Okay, I've just had a look..apologies for the lame naming!

CREATE SCHEMA dba

CREATE ROLE schema_test

GRANT EXECUTE ON SCHEMA::dba TO schema_test

CREATE PROCEDURE dba.Test_Schema

AS SELECT * FROM dbo.MyTestTable

When I view the permissions on...

Thank you very much for the reply, very good point.

Is it likely there would be an upgrade route from 2005 to 2011, I ask because I read on one forum...

Im not 100% sure, but would the following work?

GRANT EXECUTE ON SCHEMA::SchemaName TO RoleName

Admittedly I am not sat on SQL right now so cant test and as said, I work...

But could you GRANT EXECUTE ON SCHEMA TO ROLE? That way only the necessary objects are contained and it would simplify future user set ups as they only need...

If I am honest, I am not a fan of the idea of crash courses.

I bought a book for the MCITP certification (431, 443 and 444), downloaded an...

The way that I have it set up is as you said, to add stored procedures to schemas of which certain roles are granted the relevant permissions.

Users are then added...

Do you have to write script, can you just add the files in the GUI and do it that way?

I may have misunderstood but...

As stated, as long as you have the full back up and relevant transaction log backup files then I dont think there is any reason why...

There is a stored procedure sp_spaceused that will return your info on a particular db, I believe you can pass a command into sp_msforeachdb, that might do what yopu want,...

It isnt something I know too much to be honest.

I did find this link for testing a relay if that is of any use to you?

http://support.microsoft.com/kb/304897

Regards

D

Are you sending the DB Mail from a job by any chance, I remember that the account that is used for the SQL Server Agent Service needs to be added...

Thank you, I figured as much.....I was hoping to save a bit of cash on my lack of confidence for the next exam!