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 2241

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

1
vote
Oftentimes this problem stems from one of two scenarios: Either you created the table in the wrong database, or you never created the table at all (user error or just forgetfulness. It happens to us …
answered Dec 31 '13 by Thomas Stringer
0
votes
Are you sure that the Windows User ad\dkboon01 is added as a login in SQL Server? Just because you are able to use Windows Authentication doesn't necessarily mean that particular user has access. It …
answered Sep 29 '12 by Thomas Stringer
10
votes
Both of those server configuration options do not require a restart of the database engine. Running RECONFIGURE will be sufficient in this case. exec sp_configure 'show advanced options', 1 go recon …
answered Aug 13 '12 by Thomas Stringer
2
votes
That will be no problem to have multiple default instances in your environment. The only real restriction here is you can only have one default instance per machine. You will have different network …
answered Dec 31 '13 by Thomas Stringer
12
votes
To create a contained user in SQL Server 2012 that authenticates at the database, you can do the following: use YourDatabase go create user YourContainedUser with password = 'yourPassword' go You …
answered Jul 5 '12 by Thomas Stringer
29
votes
The FlushCache message in the error log is caused by checkpoint logging, and in this case by a long checkpoint (which is defined as a checkpoint that is taking longer than the recovery interval). Whe …
answered Aug 19 '14 by Thomas Stringer
3
votes
Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally Yes, with AlwaysOn Availability Groups having commit mode set to asynchronous commit for a replica …
answered Dec 17 '13 by Thomas Stringer
3
votes
;with cte as ( select ID, Priority, Type, Name, row_num = row_number() over (partition by Type order by Priority desc) from dbo.your_table …
answered Jan 9 '14 by Thomas Stringer
1
vote
As per your comments in your question, what you need to do is two-fold: Add SQL Server Agent as a cluster resource type Add the SQL Server Agent cluster resource to the failover cluster resource gro …
answered Jun 26 '13 by Thomas Stringer
1
vote
First off, there is no such thing as an "active/active" cluster. That is a huge misnomer, and can lead to a large amount of confusion. What you have is two failover cluster instances in a Windows fa …
answered Mar 31 '14 by Thomas Stringer
8
votes
I have seen this issue before, what seems to happen if you have this type of sequence: create session start session stop session add columnar data (action or field) start session The GUI doesn't s …
answered Jan 8 '15 by Thomas Stringer
3
votes
Judging by your comment, it sounds like you are looking to make the move to AlwaysOn Availability Groups. The way that availability groups work is that you choose which databases are added to the ava …
answered Jan 20 '14 by Thomas Stringer
1
vote
Since you are talking about Availability Groups, there isn't an instance startup like you're thinking about as there is with failover cluster instances. Because all replicas/instances are online (dur …
answered May 21 '13 by Thomas Stringer
1
vote
The first attempt would be to try to get either the primary replica back online, or to get the synchronized secondary replica online to ensure that there is no data loss. But provided this is a true …
answered Oct 28 '14 by Thomas Stringer
7
votes
What you will have to do is connect to the instance that has a mis-matched SID, and you'll have to recreate the login and specify an explicit SID. For instance, on the instance where you have the orp …
answered Dec 8 '12 by Thomas Stringer

15 30 50 per page