All Questions
Tagged with ssms sql-server-2014
77
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 ...
0
votes
1
answer
104
views
SSMS 2014 can't view Indexes on views
In SSMS 2008R2 you can navigate to a Database > Views > Find a specific view that you have an index on and unfurl the Index(es)
In SSMS 2014 (possibly other modern versions) you cannot. When you ...
2
votes
2
answers
1k
views
Enable Toolbox window in SQL Server Management Studio
I am assuming that the Toolbox windows in SSMS is used to store code samples. So I am able to highlight code in the editor and drag it to the Toolbox window.
However, if I wanted to use the code ...
0
votes
3
answers
469
views
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
3
votes
3
answers
5k
views
How to find column which causing "Conversion failed" error
I've run into quite a lot of issues specially when it comes to conversion errors:
convert(datetime, [fieldname]) or SELECT CAST([field2] AS int).
Imagine a large select statement with 30+ conversion ...
0
votes
2
answers
2k
views
How to increase agent history rendering timeout in SSMS?
We keep only 30 days of SQL agent job history but due to the frequent execution of jobs, SSMS will experience the following timeout error when trying to view history for a given job:
Execution Timeout ...
0
votes
2
answers
56
views
SQL Server instance level action tracking
How can we track actions happening at instance level in SQL Server 2014 .e.g. would like to know who created database, who changed recovery model, who setup backup strategy, who gave permissions to ...
1
vote
1
answer
198
views
Cannot take backup into NAS storage at specific time
I have a job which runs every 30 minute and takes t-log backup of the database suing Ola's script. Every Thursday and Friday at 22:45 I get an error:
11/07/2019 22:45:00,Backup,Unknown,Error: 3041<...
0
votes
1
answer
349
views
How to grant xp_delete_file to non-sysadmin login?
I want to delete old backups from shared folder, which are located on separate NAS storage, using newly created SQL login. Is there any workaround to execute xp_delete_file using another account which ...
0
votes
1
answer
853
views
SSMS 2014 does not launch Graphical Execution Plan from clicking hyper-linked query plan - ShowPlanXML
I am working with an older version of Microsoft SQL Server Management Studio 2014. I run the following query:
SELECT TOP 10 Q.*
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_query_plan( qs....
0
votes
1
answer
2k
views
lost all my databases after reinstalling sql server management studio
SQL server management studio was not working so, after googling this issue, I found that I have to reinstall it. So, after re installation, I lost my database and I didn't get a backup of it. So, is ...
1
vote
1
answer
732
views
Using PIVOT to convert multiple rows and columns
So my current query output is as follows:
I would like to consolidate all of these rows to just one long row like so:
MyID Customer relc_rate relc_consumption relc_daysofservice ...
0
votes
0
answers
182
views
Failed Login on Registered Server When Opening Connection
I have a number of servers registered in the Registered Servers pane in SQL Server Management Studio.
When I right click a server group and select "New Query", a window opens in which I can execute a ...
4
votes
1
answer
976
views
Is it possible to use just one shared folder for log shipping?
I wonder if it is possible to use one shared folder(only in source database) instead of two (one in source db and another in destination db). That's Server1 will store its t-log backups there and ...
1
vote
1
answer
357
views
What kind of changes does snapshot file store?
Assume that I created a database called [DBS] and inside that database I created a table called [products].
Then I inserted 4 rows into [products].
Afterwards I took a snapshot of [DBS]. As a result,...