Viewing 13 posts - 181 through 193 (of 193 total)
Distribution is used in replication.
January 12, 2011 at 5:24 am
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...
January 12, 2011 at 2:20 am
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...
January 11, 2011 at 11:45 pm
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...
January 11, 2011 at 2:54 pm
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...
January 11, 2011 at 2:20 pm
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...
January 11, 2011 at 1:45 pm
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...
January 11, 2011 at 1:19 pm
Do you have to write script, can you just add the files in the GUI and do it that way?
January 11, 2011 at 1:03 pm
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...
January 11, 2011 at 12:53 pm
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,...
January 11, 2011 at 9:03 am
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
January 11, 2011 at 8:39 am
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...
January 11, 2011 at 5:32 am
Thank you, I figured as much.....I was hoping to save a bit of cash on my lack of confidence for the next exam!
January 10, 2011 at 7:54 am
Viewing 13 posts - 181 through 193 (of 193 total)