This lesson shows you how to configure permissions and create a view and a stored procedure as the object. The Get Started Querying with Transact-SQL learning path provides more in-depth content, ...

Denies permissions on a member of the OBJECT class of securables. These are the members of the OBJECT class: tables, views, table-valued functions, stored procedures, extended stored procedures, ...

Even if you could (I don't know specifically, server-wide permissions can be fine grained by right clicking on the server object and going to properties), there would be nothing preventing you ...

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

ScriptLogic aims to help DBAs using Microsoft SQL Server manage, back up and restore permissions more easily.

Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of experience in databases. He is founder and co-owner of the website MidnightDBA.com, where he records free SQL ...

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...