Questions tagged [ssms]
SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.
1,276
questions
-1
votes
2
answers
202
views
Data retrieving is taking more than 4hrs to fetch 400K records
I have a table with 15 million rows, it's a parent table with 12 child tables.
Even for a simple count query, it is taking hour's to complete.
select count(1) from table
where col_filter >= 'number'...
- 129
0
votes
1
answer
30
views
SQL Server database migration to Azure SQL Database
We are currently in the process of setting this up, but my boss has asked whether a restore of any of the 13 databases will affect the local publications/ Subscriptions which have been set on the ...
- 11
2
votes
1
answer
8k
views
Unable connect to SQL Server on SSMS and Got error 10054
I have an issue with connecting to a server on SSMS SQL Server. I got this error 10054 when i tried to connect :
SQL Server error 10054
===================================
Cannot connect to <IP>...
- 21
0
votes
2
answers
35
views
Error Selecting XLSX Files Attached to a Solution in SSMS
I want to link Excel files to a solution in SSMS to have the handy for reference. Adding them works just fine. They show up under Miscellaneous. SSMS recognizes that they are Excel files by putting ...
- 121
2
votes
3
answers
135
views
Find "naked" varchars
It is clear that omitting the length from a varchar is a bad thing. Unfortunately I am now working with a code base where this has happened. Extensively. I would like to correct this. The first step ...
- 24.9k
0
votes
2
answers
474
views
SQL Server Profiler trace only contains my user's activity - Want to trace other users
I have what is probably a basic question, but I'm not getting anywhere searching/trying it on my own.
What I'm trying to accomplish: run a trace against a SQL DB used by Dynamics NAV and get a ...
0
votes
2
answers
331
views
How to refresh messages pane in SSMS
I need to refresh Messages pane in SSMS more often, is there a way to achieve that without GO statements?
My query is:
DECLARE @Deleted_Rows INT @Deleted_Rows = 1;
DECLARE @Deleted_Rows_Total bigINT ...
- 629
0
votes
1
answer
88
views
Keeping track of client logged-in OS user when connecting to a database server
We are implementing a monitoring solution that keeps track of logins to SQL Server.
We need to capture the following event: a user logs in to a Windows client and from there logins to a remote SQL ...
- 210
-1
votes
1
answer
663
views
What does the question mark on availability group replica mean in SQL Server Management Studio?
I'm doing some testing with availability group in SQL Server. When I'm on the primary replica, I can see all replica nodes have a refresh icon on them.
But when I check on a secondary replica, all ...
- 1,179
0
votes
0
answers
69
views
My SSMS does't see the directory with db files
I did nothing and my SSMS does not see db directories with files.
When I'm trying attach db ssmms can't find this way. But when I create db the files put there
As I understood there is the problem ...
0
votes
1
answer
468
views
DBCC Srhinkfile is stuck running for 2+ days
Forgive me, but I am very new to being a DBA as I ended up in this role out of necessity :)
I am currently working on reducing the size of several databases. I previously asked a question here about ...
- 27
0
votes
1
answer
351
views
DBCC ShrinkDatabase is increasing my file size
Yesterday, I asked a question about how to reduce the size of a database. The community suggested using the command dbcc shrinkdatabase. I followed their advice and ran the command for over 24 hours. ...
- 27
0
votes
1
answer
11k
views
SSMS error : The certificate chain was issued by an authority that is not trusted
Im getting the below error while logging into the database.By default only "Encrpt connection" is checked .
In this case should I need to uncheck "Encrypt connection" and "...
0
votes
1
answer
74
views
How does sql server derive the `Restore As` value?
When I'm restoring a database, it is auto populating the original file name and restore as.
The check box (relocate all files to folder) is to change the destination path.
No matter if this checkbox ...
- 3,476
0
votes
1
answer
670
views
Using SSIS Project Parameters in SQL Agent Jobs
I'm using SQL Server 2019 and attempting to set up project parameters for my SSIS projects. I've set up project-level parameters within the package itself and those parameters do appear in SSMS for me ...
- 167