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.

Filter by
Sorted by
Tagged with
0
votes
2answers
61 views

Where do I use T-sql for SQL Server? [closed]

I have used SQL Server a fair amount but always with SSMS. I would like to be able to use all the capabilities and understand the environment better but I do not know where I use T-sql. I have tried ...
0
votes
1answer
32 views

SSMS Restore Database Wizard questions while restoring to different destination

I need to pull some data from an earlier backup of a current prod database, so I'm using the SSMS Restore Wizard to run a point in time restore and put it into a temporary restore database (for ...
2
votes
2answers
98 views

What does this margin symbol in the SSMS text editor mean?

While editing text in SSMS I mistakenly pressed a random keyboard combination, which I think began with Ctrl-K, and found this diagonal arrow symbol appeared in the text margin where the breakpoints ...
1
vote
3answers
733 views

List all users on SQL Server for auditing

I'm using SQL Server Management Studio 17 and I'm trying to list all the users for auditing in an organized way with mentioning their database name. I tried the query below but it's showing the ...
1
vote
1answer
592 views

Restoring development database from production backup triggered production database to restore as well

We backed up our production database to restore our development database. When we restored our development database from the backup it triggered the production database to restore as well. The ...
1
vote
2answers
53 views

sp_spaceused reveals 0 rows but 72 KB of reserved space

When I run sp_spaceused dummybizo I get the following results: name rows reserved data index_size unused dummybizo 0 72 KB 8 KB 8 KB 56 KB I am expecting the ...
0
votes
2answers
183 views

Granting a SQL Server database only user execute on xp_instance_regread fails

So I'm not finding an answer to my specific issue. SQL Server 2012 database SSMS 17 admin tool Log on as a database (not domain) user foo. Receive sys.xp_instance_regread no permission errors. In ...
1
vote
2answers
322 views

running many CREATE VIEW and GRANT SELECT statements in one execution

Is there a way to run multiple CREATE VIEW commands and/or multiple GRANT SELECT commands by hitting F5 in SQL Server Management Studio? If so, how can I do this?
1
vote
1answer
58 views

SQL Batches and the GO command: which parts of my script failed?

I executed a script that had multiple sections, separated by the GO command, something like this: Use DB1 GO ALTER TABLE foo ADD bar VARCHAR(10) NULL UPDATE foo SET bar = 'nananana' ALTER TABLE foo ...
0
votes
1answer
307 views

Cannot connect to SQL server through SSMS from other machine after IP change [closed]

There was an ip change on the sql server and after that I cannot connect from other machines ssms but can connect locally . The firewall is disabled on the server and moreover its listening on port ...
1
vote
2answers
430 views

ODBC Driver for Salesforce: Access Linked Server Object in SSMS

I have problems to access a linked server for a Salesforce ODBC data source with our MS SQL Server 2016 (Standard 64-Bit) using the Devart ODBC Driver for Salesforce in SSMS and SQL Studio Management ...
0
votes
1answer
69 views

SqlLocalDB.msi and DBNETLIB / PowerShell SqlServer ServerConnections

I'm trying to setup a development SQL server using SqlLocalDB.msi which installs a local version of SQL Server 2017. I can connect to the SQL engine with SSMS (v14.0.17277.0) using MDAC (v10.17134.1)....
0
votes
1answer
25 views

data translating issues [closed]

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
405 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
1answer
674 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 ...
2
votes
1answer
764 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 ...
2
votes
2answers
772 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
61 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
3answers
1k 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
76 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
322 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
58 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
107 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
2k 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 ...
1
vote
0answers
171 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
19 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
340 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 ...
12
votes
4answers
11k 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
26 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
879 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
403 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
79 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
105 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 ...
1
vote
1answer
54 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
53 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
1answer
43 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
3k 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 ...
2
votes
2answers
1k 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
1answer
284 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 ...
1
vote
1answer
60 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
87 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
251 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 ...
2
votes
1answer
1k views

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

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
527 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
77 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
802 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
63 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 = ...
6
votes
2answers
2k 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
125 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
71 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 ...