Grants permissions on a server. :::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: [Transact-SQL syntax conventions](../../t-sql ...

When you create database objects, you must explicitly grant permissions to make them accessible to users. Every securable object has permissions that can be granted to a principal using permission ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

SQL is not my thing, I know how to install it, run a query, and thats about it. I am doing a consulting job right now for a friend of mine setting up a small ecommerce .com infrastructure. Most of the ...

Hoping to pull from the hive mind on this one. I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What kind ...