Search Results
| 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 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| 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 sql-server
Search options not deleted
user 93455
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.
16
votes
Accepted
Length of LOB data (2135980) to be replicated exceeds configured maximum 65536
This configuration can be changed using Management Studio by right-clicking the server -> Properties -> Advanced tab -> Miscellaneous -> Max Text Replication Size.
Or you may want to try :
EXEC sys. …
- 887
7
votes
Issue with Table Naming Conventions and Policy Management in SQL Server 2016
Tested the scripts on a SQL Server 2016 SP1 CU2 instance and the policy works if the Evaluation mode is set to "On Change : Prevent". (there is a bug that doesn't let you evaluate policies that use sp …
- 887
3
votes
How to Denormalize data efficently
To answer your second question, you can try to rewrite the select query like this:
SELECT
j.[JobID]
, j.[Active]
, jf.[JobFieldTypeId]
, jf.[ValueString]
, jf.[ValueInt]
, jf. …
- 887
1
vote
3
answers
93
views
Enforce uniqueness on combination of columns + aggregate function
I have a SQL Server database with the following tables:
CREATE TABLE [dbo].[Rule]
(
[RuleId] [int] IDENTITY(1,1) NOT NULL,
[Value1] [int] NOT NULL,
[Value2] [int] NOT …
- 887
0
votes
How automate backup and restore in Azure SQL Managed Instance?
You can use an SQL Agent Job to backup and restore a database from a storage account, you just need to create a credential in advance:
SELECT * FROM sys.credentials;
CREATE CREDENTIAL [https://Storag …
- 887
0
votes
How to drop a table that was replicated in the past?
You can run the following script to cleanup any orphan replication objects:
USE [<YourDatabaseName>]
GO
exec sp_cleanupdbreplication
GO
exec sp_removedbreplication
GO
- 887