Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 118303

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

2
votes
2answers
I've granted membership in the db_datareader and db_datawriter roles for some testing being performed by a specific user. Looking at the names of each role, I know what the roles do. However, I want …
asked Mar 6 '17 by Matt
1
vote
1answer
I recently created a new SQL Server environment and I am trying to use best practices where I can, especially the least privileged approach. Other servers in our environment just have jobs running wit …
asked Mar 23 '17 by Matt
2
votes
1answer
My server admin asked me to grant a user SA privileges for the purpose of upgrading our vCenter environment from 5.5 to 6.x and I refused. So I found a VMWare article that outlined all of the required …
asked Mar 22 '17 by Matt
0
votes
1answer
I am trying to get the last second of the last month as a default value for a parameter. I can get the last day of the last month from this query on social.msdn.microsoft.com last month last day e …
asked Oct 18 '18 by Matt
0
votes
They key is the placement of DateValue() which: Returns a Date value containing the date information represented by a string, with the time information set to midnight (00:00:00). The problem w …
answered Oct 18 '18 by Matt
7
votes
4answers
I am just trying to look up more verbose information for a maintenance plan task that failed. I open up the log file viewer and check the box to view the logs for my maintenance plan. There are no act …
asked Apr 20 '17 by Matt
0
votes
0answers
I was having an issue getting SQL Server Reporting Services 2008R2 SP3 working under a domain service account on Windows Server 2008R2. It started with this What am I missing for my SSRS Service accou …
asked Apr 25 '17 by Matt
2
votes
As part of the troubleshooting I was doing to try and address the issue I ran Process Monitor while I was trying to start the service. I tracked as event that also had a result of "Access Denied" wh …
answered Apr 25 '17 by Matt
1
vote
2answers
I have a relatively new instance on SSRS 2008R2 SP3 running on Windows Server 2008 R2. I am trying to set up separate domain service accounts for the separate SQL Services i.e. agent, engine, reportin …
asked Apr 24 '17 by Matt