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 34065

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
No, if nothing is found in the join, nothing will be updated.
answered Mar 29 '17 by MrTCS
1
vote
update a set a.calendar=b.calendar_code from master_mind_table a,hrrtsup_emp_elig_maintain b where a.elig_carry_eff_from=b.year_start_date and a.elig_carry_eff_to=b.year_end_date and …
answered Jun 28 '17 by MrTCS
2
votes
1answer
I'm working on a request to start logging some additional data for PCI compliance. I need to log who, when, and what changed on a set of tables. I set up SQL auditing which would work fine except fo …
asked Jan 14 '15 by MrTCS
3
votes
1answer
I'm trying to grant permissions to a user to run one job. I created a certificate, assigned it to the stored proc, and granted the cert role membership to SQLAgentOperatorRole, but when executing the …
asked Jun 1 '17 by MrTCS
1
vote
You can only add a database to an AG from the Primary node. Your options are to back and restore the database to the new primary, or fail back over to SQL06 to make it the primary, then add it to the …
answered Jan 10 '17 by MrTCS
5
votes
2answers
I'm working on a script I can run on new servers to do some initial configuration. I would like to be able to skip some sections but the problem I'm running into is the "GO" that's required. Because …
asked Dec 9 '14 by MrTCS
3
votes
I should have kept researching just a little bit longer. I found this article and discovered I needed to counter-sign a few more stored procedures within msdb. Once I did that my user was able to ex …
answered Jun 1 '17 by MrTCS
1
vote
Yes, you will need to manually backup and restore the databases, with logs, to the new secondary and then join the databases to the AG. This might help.
answered Jan 10 '17 by MrTCS
1
vote
1answer
CDC has been set up for one of our databases in our test environment but it's not capturing any of the changes. I've made sure the capture job is running. I've disabled CDCs for the database, enabled …
asked Feb 10 '14 by MrTCS
3
votes
2answers
I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the l …
asked May 14 '14 by MrTCS
4
votes
It sounds like you are trying to add a database to your AG from a node other than the primary (is instance3 even part of your cluster), you can't do that. You would have to fail over to instance3 and …
answered Oct 17 '17 by MrTCS
0
votes
0answers
One of the servers I'm responsible for now was set up under the wrong license so can only use 40 cores on the server. This has led to an imbalance in the NUMA node schedulers. I'm planning on using …
asked Jul 26 '18 by MrTCS
1
vote
1answer
I'm trying to add an assembly to SQL server 2012 but I'm getting the following errors. I've tested the dll and it works fine from C# so don't think it's a code issue. Any suggestions? Msg 6218, Leve …
asked Dec 27 '17 by MrTCS
0
votes
3answers
We are having memory pressure issues (RESOURCE_SEMAPHORE waits) on one of our servers but there are very few active connections going on at one time. Logically, it wouldn't seem like sleeping connecti …
asked Oct 12 '16 by MrTCS
0
votes
1answer
I am trying to restore a database from a Prod environment (11.0.6020.0) to a lower environment server (11.0.3128.0). I realize the lower has an older SP, we are working on correcting that now. The r …
asked Feb 8 '17 by MrTCS

15 30 50 per page