Not yet, thank you.

Edit: I do not see where you can GRANT that...

Yes I read the link.

Thank you.

Eric M Russell (9/29/2016)

GilaMonster (9/29/2016)

And, after you're read that, tell me whether 'CREATE PROCEDURE', 'ALTER PROCEDURE', 'DROP TABLE', etc are valid permissions to be granted on a...

I found this before I read the link.

Edit: Before I read your post.

As CREATE PROCEDURE isn't a schema-level permission, just try GRANT CREATE PROCEDURE TO [domain\user].

I tried this and I...

Msg 102, Level 15, State 1, Line 0

Incorrect syntax near 'CREATE PROCEDURE'.

I get the same error ON ALTER and DDROP PROCEDURE.

Also,I get the same error ON CREATE...

I get a syntax error on the following command:

GRANT CREATE PROCEDURE ON SCHEMA ::ca TO CCUser;

What is wrong with this statement?

GRANT CREATE PROCEDURE for User Canada on schema ca?

GRANT CREATE PROCEDURE ON ::ca TO Canada WITH GRANT OPTION;

I do not need the WITH GRANT Option.

Does that look right?

How do I grant to CREATE PROCEDURE for User Canada on schema ca?

Thank you.

Making the user the owner of the schema will work.

Shouldn't a Path for the file name be specified?

It works. My bad.

Thanks to everyone.:-)

I'm doing something wrong for I do not have that option in the drop down list.

I just want to accomplish the following in SQL Server 2012.

The instructions provided are for SQL Server 2008.

"Provide a screenshot showing that Adhoc Remote Queries are disabled by using the...

Has anyone performed a backup and restore of a Replicated Database?

https://msdn.microsoft.com/en-us/library/ms152560.aspx

Looks to me like a backup is helpful.

I was told it was useless.

https://technet.microsoft.com/en-us/library/ms152560(v=sql.110).aspx

https://technet.microsoft.com/en-us/library/ms152560(v=sql.110).aspx