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 50728

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

3
votes
There are several steps to configuring a server to accept ReadOnly traffic. The following link walks you through it, http://msdn.microsoft.com/en-us/library/hh710054.aspx ,but basically you need to c …
answered Jan 16 '15 by Steve Mangiameli
0
votes
The problem with a sequence is that you have to specify the top end of the range and that's unpredictable in your scenario. But you could track it on your own without having to worry about caching. B …
answered Sep 25 '17 by Steve Mangiameli
0
votes
This solution uses two CTEs to identify your open and close records and then joins the two datasets together. Enjoy --Build the test tables (using BIT instead of OPEN / CLOSE IF OBJECT_ID(' …
answered Sep 2 '15 by Steve Mangiameli
1
vote
"abc" would be a default instance, where "abc" is the actual server name. Sounds like you created a named instance where /xyz is the name of the instance. This allows you to have multiple instances of …
answered Mar 18 '16 by Steve Mangiameli
2
votes
It's impossible to do this in the procedure. This wait type is a function of the scheduler. Each SPID gets a finite amount of time (4ms) on the processor. Once that time, or quantum, elapses, the S …
answered Mar 9 '16 by Steve Mangiameli
3
votes
Yes what you want to do is possible. It is impossible, from what you've given, to know how long it will take or how many additional resources will be required in terms of disk space. Testing will get …
answered Sep 29 '16 by Steve Mangiameli
3
votes
A linked server is referenced just like you would reference a database, with multi-part naming - LinkedSvrName.DBName.SchemaName.ObjectName. There isn't really anything else to "accessing" a linked s …
answered Jun 8 '16 by Steve Mangiameli
1
vote
Ste, what you are wanting is a point and click solution or a setting somewhere. Unfortunately, none of these currently exist in "off the shelf" form. It would be realllly nice if Microsoft included …
answered May 10 '16 by Steve Mangiameli
2
votes
Assuming your or a user for which you have credentials has applicable permissions, it is very easy to run scripts into SQL Server. The simplest method is to use Invoke-Sqlcmd. You can set the -Query …
answered Dec 15 '15 by Steve Mangiameli
1
vote
So what you want is an insert, an update and a delete procedure for each table. Then you want a "wrapper" procedure that tracks the inserts/updates/deletes and responds accordingly to errors. A "tr …
answered May 12 '16 by Steve Mangiameli
15
votes
Listen to your adviser. By restoring a backup, you are essentially replacing the database schema and data. You will need to turn synchronization off, remove the DB from HA and perform the restore on …
answered Jan 16 '15 by Steve Mangiameli