Tag: db_owner

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Roles

by

Troubleshooting SQL Server 2017 Roles If you have problems with SQL Server 2017 roles, review this troubleshooting checklist to find potential solutions. 1. The error 920 may occur when you modify the database script level. This error indicates that only members of the sysadmin role can modify the database script level. To resolve this problem, ensure that user, who modify...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 full-text search

by

Troubleshooting SQL Server 2017 full-text search If you have problems with SQL Server 2017 full-text search, review this troubleshooting checklist to find potential solutions. 1. Ensure the user needs to create, alter or drop the full-text catalogs have appropriate permissions. To create a full-text catalog the user must have CREATE FULLTEXT CATALOG permission on the database, or must be a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Troubleshooting SQL Server 2014 Roles

by

Troubleshooting SQL Server 2014 Roles If you have problems with SQL Server 2014 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was […]

Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 database settings

by

Tips for using SQL Server 2012 database settings To change the database settings, you can use the ALTER DATABASE SET Options or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Roles

by

Troubleshooting SQL Server 2012 Roles If you have problems with SQL Server 2012 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 roles

by

Troubleshooting problems with SQL Server 2008 R2 roles If you have problems with roles in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 role bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →