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 124448

SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.

1
vote
You should change the owner of all your databases, for example to "sa" (even if it's disabled it'll work) The command is alter authorization on database::yourDB to sa
answered May 24 '17 by sepupic
2
votes
You should use sp_help to get what you want. This is SQL Server, not Oracle. use yourDB; exec sp_help 'yourTable'; sp_help (Transact-SQL) Reports information about a database object (any object …
answered Jan 11 by sepupic
0
votes
It's not clear from your question if you want to distinguish between logins with SQL Server Authentication and Windows Authentication. If you just want any user (every future user included) of this d …
answered Dec 4 '17 by sepupic
4
votes
But it possible to setup to restore transaction log after finish of current running and this interval time no other user connect secondary database. Yes it's possible, you can read more about …
answered Nov 9 '17 by sepupic
0
votes
I agree with ypercubeᵀᴹ answer, the query should be rewritten. Can you maybe explain why this is so much faster? The query that use the second index is faster only because it's executing in para …
answered Feb 25 by sepupic
0
votes
You can find the answer in this article Inside the Storage Engine: Ghost cleanup in depth When a record is deleted, apart from it being marked as a ghost record, the page that the record is on i …
answered Jun 2 '17 by sepupic
4
votes
Reason: Failed to open the explicitly specified database. ... The Database which the login is trying to access is a temporary Database and is in Single user mode for last 15 days fail …
answered Oct 5 '17 by sepupic
2
votes
Starting with SQL Server 2012 you can use contained databases as described here: SQL Server 2012 Contained Database Feature There is no need to create logins, it's a database that authenticates you. …
answered Jun 13 '17 by sepupic
1
vote
Let's start with the main issue of this trigger: SET @@Message = (SELECT STAT_MESSAGE FROM dbo.TABLE_NAME) This will produce the following error Subquery returned more than 1 value. This is not …
answered Dec 14 '17 by sepupic
2
votes
You should check log_reuse_wait_desc of sys.databases after taking log backup to find out the reason. Log backups just try to clear the log, but it can happen that it's impossible. In this article s …
answered Sep 29 '17 by sepupic
2
votes
Your query seems to be some kind of report where some parameters can be omitted. Conditions like these: WHERE (@TenantId IS NULL OR O.TenantId = @TenantId) AND (@Soh IS NULL OR M.Soh …
answered Jan 24 by sepupic
2
votes
I asked the OP if the code is intended to be executed on the whole server, i.e. in all databases or in some of them and still no anwer, so I suppose he needs the code to be executed in ALL databases: …
answered Jul 25 '17 by sepupic
1
vote
You can use the following code to catch your ALTER DATABASE statements launched by your application server: use master; create table dbo.ddl_hist( [id] [int] identity(1,1) not null, [dt] [da …
answered Feb 13 by sepupic
6
votes
What you see is correct. When you rebuild an index first the new index is built and only then the old index is dropped. And if you don't use SORT_IN_TEMPDB = ON the space that server needs to mak …
answered Oct 29 by sepupic
2
votes
It's not a bug, you should use T-SQL statement as you did and not a GUI. When your update/delete statement affects more than one identical rows (duplicates) you've got this kind of error ("or they alt …
answered May 11 '17 by sepupic

15 30 50 per page