All Questions
Tagged with ssms sql-server-2012
129
questions
2
votes
1
answer
167
views
Forwarding SQL Server Error Logs to Another Server
I wasn't sure where to post this question. If this is not the right place, kindly point me in the right direction.
We have SQL Server 2012 and 2014 on-prem. My intention was to forward the error logs ...
1
vote
1
answer
2k
views
Cannot connect to SQL Server, cannot start SQLEXPRESS service
There are 2 issues at the same time.
I cannot connect to the database (SQL Server 2012) using SSMS - I'm getting error 1225
I cannot start the SQLEXPRESS service - getting error 3414
Earlier last ...
1
vote
1
answer
700
views
Run MSSQL stored procedures containing SSIS packages using Windows Authentication from another computer
I am new to MSSQL. I have a question about executing MSSQL Stored Procedure.
Let me briefly talk about my development environment first:
PC400 (Computer/Server A), where SQL Server 2012 is installed
...
1
vote
1
answer
171
views
Publication Properties window in SSMS hung when attempting to update
We have a SQL 2012 Database that is mirrored. It also has one publication with 3 subscribers. After a problem occurred (a view that couldn't replicate) during a snapshot push to one of the ...
1
vote
1
answer
96
views
SSMS Template Browser Add-In development
Okay, I’m trying to do something that I just can’t seem to get accomplished and I haven’t found anything online to address this request.
In the “Template Browser” I want to add another category of ...
0
votes
2
answers
194
views
Cannot Find Job Associated Active Email Notifications
We have a email notification going via our SQL Server however I cannot find any job or setting associated with it. Its definitely the correct server and I am logged in as admin. The email is sent via ...
0
votes
2
answers
336
views
Deny certain user from updating certain rows [duplicate]
Say I have a table like this:
canModify | name | age
------------------------
1 | John | 24
0 | Nick | 21
I want to grant update access to a specific user only where canModify=1
I ...
0
votes
1
answer
149
views
SSMS execution time queries besides SET STATISTICS [closed]
When I run my query, it prints multiple execution times instead of just one. I only want one so what should I use instead of SET STATISTICS?
SET STATISTICS TIME ON
DECLARE @firstNum INT, @secondNum ...
0
votes
1
answer
1k
views
MSSQL 2016 - Restore SSISDB from MSSQL 2012
On "MSSQL 2016 (SP2-CU11) (KB4527378)" I created empty SSISDB. After that I restored SSISDB from "MSSQL 2012 (SP4) (KB4018073)" to "MSSQL 2016 (SP2-CU11) (KB4527378)" On DB I set owner to sa and ...
1
vote
1
answer
1k
views
SQL Server Extended Events purging
How do we purge events older than a day in Extended Events in SQL Server 2012. Stopping and Starting the session is not helping.
Target : asynchronous_file_target
Trying to create a job which will ...
3
votes
2
answers
989
views
SSMS cannot connect remote server by IP through Windows authentication
I'm trying to connect a remote server by IP,port via Windows authentication.
It will end out with the following error
Connection Timeout Expired. The timeout period elapsed while
attempting to ...
1
vote
1
answer
200
views
When are statistics created?
I know that when we create an index then statistics are automatically created. My question is: Is it the only case when statistics are created? I remember that once I found on the internet that we ...
3
votes
1
answer
1k
views
Available space differs between sys.database_files and database properties dialog in SQL Server Management Studio
I am looking at this for a few minutes now and could not find a thread mentioning this.
I wanted to query currently used space and available space from a database on SQL Server.
The numbers I query ...
2
votes
1
answer
483
views
Line breaks handled inconsistently by SSMS
Probably more of a SQL Management Studio question than SQL, per se, but when I run the following simple query:
SELECT results = 'Foo' + CHAR(13) + CHAR(10) + 'Bar'
I appear to get different results ...
1
vote
1
answer
142
views
SQL Server 2016 - Disparity Between View Definition and View Design
I've run into an interesting issue with some databases I've inherited, and could use some help unpacking it all.
The Issue
After adding a column to a table, views selecting * from that table are now ...