GRANT CREATE PROCEDURE  TO [username]

--user name can be a  MS SQL Server user, SQL Server role(userrole),NT user or NT group.

--user can create a stored procedure

DENY CREATE PROCEDURE  TO [username]...

hi,

try this

select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

Binary sort order is case-sensitive, that is lowercase precedes uppercase, and accent-sensitive. This is the fastest sorting order.

If this option is not selected, SQL Server follows sorting and comparison...

Hi,

What is the size of database? The database have the secondary data files?

Whe you use this option, must have in mind how often data is modified.

This option, fillfactor is useful to optimize the performance of INSERT or UPDATE statements.