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 1573

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.

0
votes
If you're okay with using a script through SSMS the script below will search through user tables for a certain string. In a system with a lot of tables and columns it will take a long time. :) set …
answered Mar 23 '12 by Jason Cumberland
0
votes
Local temporary tables should not have this problem, but if you want to ensure that the table creation doesn't cause a DDL conflict then just put a conditional drop statement at the top of the stateme …
answered Dec 23 '14 by Jason Cumberland
1
vote
Backup your primary database and restore that to your mirror instance, then backup your primary log and restore that to the mirror instance, both with norecovery. After that you need to configure mir …
answered Feb 8 '12 by Jason Cumberland
1
vote
If this is installed on a windows 2008 server then you will need to check that the firewall is either disabled (not recommened) or that there is a firewall rule for the SQL port (1433 for default inst …
answered Mar 19 '12 by Jason Cumberland
0
votes
As long as you're monitoring and alerting based on the status of the mirroring for each database then refreshing the secondary shouldn't be needed.
answered May 20 '13 by Jason Cumberland
0
votes
Similar answer to Marks's, but will not need to modify startup parameters or databases. If you are starting over with new hardware you can: install SQL to the same directory path as the previous se …
answered Feb 3 '12 by Jason Cumberland
3
votes
Re-run through the database configuration part to select the same database and it will re-issue the grants to make sure the permissions are in place, but make sure the account you run the wizard with …
answered Jan 18 '12 by Jason Cumberland
2
votes
The MSX/TSX is indeed related to the SQL Agent, allowing you to schedule jobs on a master server and have those jobs pushed out to slave servers. CMS is an extension on the registered servers concept …
answered Feb 10 '12 by Jason Cumberland
4
votes
Your steps to do this are pretty much right, I've added some steps and changed the wording on a few items. Some SAN vendors provide migration software so you only have to turn off the cluster nodes f …
answered Feb 23 '12 by Jason Cumberland
3
votes
In management studio configure the database mail option under "Management" (both the account and the profile) and then use the stored procedure sp_send_dbmail in the msdb database. http://msdn.micros …
answered Jan 5 '12 by Jason Cumberland
2
votes
@@identity is not a good solution and will return incorrect results since . SCOPE_IDENTITY() is session based and will return the last inserted record for the session. There isn't a way to correct t …
answered Sep 17 '13 by Jason Cumberland
2
votes
This is sort of possible using the SQL 2012 AlwaysOn feature, which allows you to create a cluster between two nodes that do not share storage. The setup uses database mirroring behind the scenes to …
answered Aug 22 '12 by Jason Cumberland
4
votes
When you switch the recovery mode to shrink the log file you are invalidating prior backups because it breaks the log chain. What you need to do it switch it to simple, shrink it down to what you wan …
answered Jan 24 '12 by Jason Cumberland
0
votes
One solution, albeit kinda sucky, is the convert the Agent jobs from SSIS tasks to CMDExec tasks and then call DTExec directly. If you do this you can set the environment variable in the batch file b …
answered May 16 '12 by Jason Cumberland
1
vote
I think you need to specify an "/en" option in order to change the encryption level. See this link. http://support.microsoft.com/kb/906562
answered Nov 22 '13 by Jason Cumberland

15 30 50 per page