Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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.

0
votes
1answer
38 views

SSMS 17.8.1 Error: Accessing SQL Server logs

I am experiencing an error when I am trying to access the SQL Server Logs through SSMS 17.8.1 for SQL 2017. I click to expand the SQL Server Log folder in SSMS and I get the following error. How can ...
0
votes
1answer
25 views

data translating issues [on hold]

I have these two table here in ssms: one is called client table, which have a column called city, and it is really city name, like new york, etc. Another table is called city table, it has city's ID ...
1
vote
3answers
44 views

Cant restore database from A to B using any method in SSMS GUI

I have two databases. One is production (A), the other is development (B). I use to be able to restore database from a backup.BAK file of A in B by using SSMS > right clicking databases > restore ...
0
votes
0answers
20 views

SSMS crashes when attempting to create a database diagram

I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
1
vote
0answers
50 views

SQL Server was unable to communicate with the LaunchPad service

I have run the below code: execute sp_configure 'external scripts enabled'; and it is giving me the output as: name minimum maximum config_value run_value external scripts ...
-1
votes
0answers
54 views

How to limit SQL Server sessions based on hostname? [duplicate]

When I run sp_who, I can see the information about current sessions. I need to limit that sessions according to hostname. For example, I need to say the host named x can only have 1 session at a ...
1
vote
2answers
86 views

Active Directory not working through SQL server Management studio

I have created a Group in SQL Server and add an Active Directory group to it with which contains users. When I try to login through Windows authentication, it gives me the following error: Login ...
0
votes
1answer
30 views

Microsoft Key Storage Provider for Always Encrypted Master Key

Hoping someone can help- I've been experimenting with Always Encrypted columns and have generated a certificate in the "Microsoft Software Key Storage Provider" - How can I remove the "Always-...
0
votes
2answers
42 views

Transfer data from Excel to table

How can I transfer information from an Excel file to a table in a SQL server database through SSMS? Excel file Consists of five columns and a thousand rows. I followed the steps as explained here,at ...
0
votes
1answer
37 views

How to have folders in the SSMS 2017 project? [closed]

I am using SSMS 2017 and SQL server 2017, I have many companies and each company has many databases. For example. I have five companies: Company1, Company2, Company3, Company4, Company5 Every ...
0
votes
1answer
32 views

Why does SQL Server Profiler crash when its run against a DB machine from a client machine?

I have: SQL Server 2014 (default instance )is on a Win Server 2012 machine. SQL Server Management Studio (v17.7) is on a Win 7 machine. Both machines are on the same domain. I'm logged into the Win 7 ...
-1
votes
1answer
53 views

Analysis of queries or stored procedures which ran on the database for last 15 days [duplicate]

We had a site slowdown between 11.57 am and 12:02 pm on 6th Aug 2018, To trace back the queries which were ran our production database (SQL Server Standard Edition 2012) and which might have caused a ...
0
votes
1answer
38 views

Restore Log and Differential Backups Simultaneously in MS SQL Server

I have the full backup of a database, also one differential backup and one log backup. Is it possible to restore this 3 backups together? SSMS lets only full backup and only one of them. Is there a ...
-1
votes
1answer
42 views

how to select query to inner join same column twice?

Table A: Col1 [TicketSubject] Col2 [Createuserid] Col3 [Modifyuserid] Table B: Col1 [ID] Col2 [Name] How I imagine it would work SELECT a.ticketsubject ,a.createuserid ,a.modifyuserid ...
0
votes
0answers
26 views

What does the WQL Select * from SQLService return 0 rows in WBEMTest mean?

So, I've been trying to solve the blue icon question mark on my sql server in SQL Server Management Studio by following the answer in the following link: Blue icon with question mark - what does it ...
1
vote
0answers
17 views

Problem about listing network instances on SSMS

I have a problem about listing network instances on SSMS. When I look at the Network Instances on SSMS, it shows only local server instances. By the way, it shows all the instances on the network ...
1
vote
2answers
49 views

How to Locate Resource System Database in MS SQL Server

There is a database called Resource database, which I know that is read only and contains information about system objects and does not save any user related data or metadata. I am using SSMS to ...
8
votes
4answers
772 views

What does a RED X on a database user mean?

I created two new AD groups and added them as users of a database but they show with a RED X. What does this mean? Thanks.
0
votes
0answers
25 views

SSMS sessions calling CLR packages intermittently stops processing completely, but SSMS appears to still be processing

It's a third party app on SQL Server 2008R2. In Test, they are trying to run some reporting, and they have to use the SPs with many built in CLR functions. Running the script in SSMS on a system with ...
3
votes
2answers
332 views

Cursor causes SSMS to crash

I have a cursor that generates one record of JSON text from a group of tables. The cursor has been making SSMS crash. The script runs for a time then SSMS fails. Below is the code that I have ...
2
votes
0answers
49 views

Elegantly handling 'enum-like' magic numbers in T-SQL code

We run Dynamics GP, and anybody that's dealt with GP will be familiar with all of its "magic number" columns representing the various enum values inside the application. For example, a reporting query ...
0
votes
1answer
62 views

Query and index optimization for a table containing 10 million records [closed]

I was trying to retrieve data from a table A to retrieve data for 1 month, which has around 10 million records and 21 indexes built on it, It took me 3 min to retrieve around 20 columns and total of ...
1
vote
2answers
41 views

SSMS Timeout when browsing for sql servers?

When connecting to a sql server instance one has the option of browsing the network for sql instances. This used to work for (returning ~50 entries) us until we were migrated into a larger domain ...
0
votes
0answers
23 views

Daily import into SQL server, using different Destination DB names (date) on each

First post here, and hopefully this isn't too basic. I did several searches and wasn't able to locate anything. What I am attempting to do is a daily import from an Eloquence database to SQL. I ...
1
vote
1answer
41 views

SSMS registered Servers

I am currently trying to migrate my ssms registered servers from one machine to another. This is complicated by the fact that I am running ssms 17 on the source, and ssms 16 on the destination. I ...
0
votes
1answer
52 views

Which server is used in script? [closed]

In MS SQL Server, if I'm connected to two servers (for example dev and production) that both have a DB called MyDb which server is targeted when I run a script like use MyDb SELECT Description FROM ...
0
votes
0answers
14 views

How to backup only primary filegroup ?

I need to exclude one of my table in database during backup. So I move the table to another filegroup "SECONDARY". bkpDifferential.Action = BackupActionType.Files; bkpDifferential....
0
votes
1answer
42 views

Cleaning up cut and pasted outlook email addresses

I often have to create or update e-mail distribution lists in SSMS, where the requestor will ask "please add Anne Hathaway, Albert Einstein, and Ash Ketchum to the DL. Get their email from Outlook." ...
0
votes
1answer
42 views

SSMS Keeps Crashing

SSMS keeps shutting down without any detectable pattern, usually within 30 seconds of opening the app. Any ideas on how to fix? Here's the error from the Event Log: Application: Ssms.exe Framework ...
1
vote
2answers
68 views

How to copy & paste “Missing Index” in “Execution plan” tab of SSMS?

Notwithstanding that blindly creating suggested missing indices is less than ideal, is there a way to copy and paste the suggested missing indices from the "Execution plan" tab in SQL Server ...
0
votes
0answers
11 views

One of the DB Roles Not Showing Up Under A Login

Upon a request that I received, I have queried out the all the database roles under a particular login. To make sure that the result is correct, I opened up that particular login and went over to ...
0
votes
1answer
85 views

Inserting 3 lakh (300'000) records into a table [closed]

I have a table named transaction into which I want to insert 3 lakh (300'000) records. I need it to be created as dynamic query instead of writing thousands of insert statements. For example : ...
0
votes
1answer
58 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...
0
votes
1answer
52 views

sql server managemenent studio won't launch

i'm having trouble with launching the SSMS 17.7. i downloaded it using this page, using this after the installation was completed, i tried to launch the SQL servers management studio, but the app ...
1
vote
1answer
57 views

How to make a test Database grow in size by running transactions to test autogrowth factor?

I have created a test Database instance which is currently having zero activity on it. I have set the auto growth parameter for this DB similar to our actual production DB which is 600 MB per day , ...
1
vote
1answer
75 views

SSMS 10.5 alongside 17.7

To set the scene, I maintain 4 local SQL Server 2008 R2 instances. At some point in the near future, 3 of these will be upgraded to SQL Server 2017 and migrated to azure. I am currently using SSMS ...
1
vote
1answer
50 views

On Insert Trigger To Create Email

I am wanting to send an email through the SQL Server Agent once an insert has been made to a specific table. I tried the syntax below, but the email is not being sent, nor queued to send. ALTER ...
3
votes
0answers
214 views

Couldn't install SSMS: A pending restart is blocking setup from completing [closed]

SSMS version : 17.7 Log file: Log_file I have SQL Server 2016 and Visual Studio 2017 Community Edition. I tried reinstalling both tools but the error is still the same. Some links mention registry ...
0
votes
1answer
101 views

Source - ODBC is not compatible with this version of the DataFlow

After deploying an SSIS package from a development server to another environment, execution and validation of the package fail with the following error: Error: The version of #5) Source - ODBC - ...
3
votes
2answers
35 views

Connect to SQL Server on Linux over the network

I have setup Microsoft SQL Server on an Ubuntu VM. I know how to connect to SQL Server on Windows using SSMS -> but unfortunately I can not install SSMS on Ubuntu. Which leads me to the question ...
0
votes
0answers
127 views

SSIS error in lookup for lookup yielding no rows

I am trying to have lookup component to find some column is equivalent to max number of date from TR table. My query is below select CAST(max(prDate)as datetime) as date from TrTable In SSMS it ...
0
votes
1answer
41 views

SQL Server Agent appears to be treating sysprocesses (and dm_exec_sessions) differently

I have a watchdog process that runs via a SQL Agent job to manage some custom tasks. One of the checks is that the process no longer exists: UPDATE R SET IsOrphaned = 1, DebugTimestampUtc = ...
5
votes
1answer
173 views

What is the right tool to process big .xel files (SQL Server Extended Events logs)?

My aim is to audit all queries on an instance, who's running them and from where, how many reads, in order to consolidate/migrate on another instance. Figured out the best way is via Extended Events ...
0
votes
1answer
93 views

Autogrowth Analysis in PROD DB based on the trace file data

I have used the below query to check our Production Database Autogrowth events so that we can set to a value which is much more realistic than the current value of 200 mb , unrestricted for mdf file ...
0
votes
1answer
20 views

Hide bottom status bar in SSMS

Is there a way to hide the most bottom status bar? It doesn't have that much useful information (line number, column number, etc) and takes a decent amount of screen real-estate. I don't think it's ...
0
votes
2answers
95 views

Recommended Auto Grow settings suitable for database whose size is 867666.25 MB [closed]

I need recommendations for setting/modifying the auto grow options for our production database. size of FUNDSDB 867666.25 MB Also, I have attached the current autogrowth statistics , looks like ...
0
votes
1answer
32 views

How to restrict in SSMS to allow remote connections only specific IP / Host

I cannot change sql server user. How can I restrict in SSMS to allow remote connections only specific IP / HostAddress.
0
votes
1answer
36 views

Error in AG Dashboard when looking at a Distributed AG

I have a Distributed AG, but whenever I go to look at the AG Dashboard it says "An error occurred on the Always On Dashboard". When I click for details I get "Object reference not set to an instance ...
0
votes
1answer
37 views

Find minimum number of columns that identify uniqely all rows

I'm using SQL Server Management Studio. I've a table and I want to find a Primary Key for this table. Can I write a script in T-SQL that finds which columns (and I want that the number of columns is ...
0
votes
2answers
160 views

Imposssible to expand a database in SQL Server Management Studio

I am experiecing a strange problem. I have a SQL Server 20008 R2 instance that recently (after years of running smoothly) started to become slow. One symptom that I notice is that when working from ...