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 71657

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.

8
votes
5answers
I have a process which involves executing various commands between multiple databases - however, when I use dynamic SQL to change DB with 'use @var', then it doesn't actually change the database. Exe …
asked Oct 21 '15 by SeanR
2
votes
1answer
I have a table which contains a few columns, one of which is an image datatype, this is used to store BLOB data, which could be anything from a jpg to a large PDF. I have a requirement to update one …
asked Dec 14 '15 by SeanR
0
votes
1answer
I'm just starting to use SSMS 17.3 - and one of the main things I was looking forward to trialing was XE Profiler. However, when you start a session (either Standard or TSQ) and add the Database Name …
asked Nov 1 '17 by SeanR
2
votes
2answers
I am running maintenance plans on a server, which is running several instances of SQL Server 2104. I have set up a nightly maintenance plan to run backups for all user databases, with the backups set …
asked Aug 26 '15 by SeanR