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

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
20 views

Log-in as service account in SQL Server Management Studio

The stored procedure that performs a CTE in production is being executed using a service account. However, the stored procedure returns empty and I tried checking this using SSMS but I my domain ...
0
votes
0answers
19 views

Access Denied issue, SQL Server LocalDB on Windows Server 2008 R2 SP1

Running SQL Server LocalDB 2012 and 2014 on Windows Server 2008 R2 SP1 VM I have some bizarre issues which don't happen when running on Windows 7 or Windows 10. I can create databases, save data to ...
0
votes
0answers
30 views

SSMS not showing database compatibility mode [closed]

when I run the following query to identify databases with cross database ownership on: select name,is_Db_chaining_on,suser_sname(owner_sid) as [owner], compatibility_level from sys.databases where ...
2
votes
1answer
49 views

How do I copy the structure and contents of some tables from one database to another?

How do I copy the structure and contents of the tables below in SQL Server Management Studio from database SNO_TEST to SNO_TMP (on the same server)? The names of the tables are ADMIN_ErrorLog, ...
1
vote
1answer
89 views

Why do LocalTemp table showing with lengthy underscore under Temporary Tables of tempdb in SSMS 2017 Express Edition? [duplicate]

In my Microsoft SQL Server 2017 Express Edition, I have created a local temp table using below create statement, create table #localtemptable (tempid int,tempname varchar(20) ) After creating #table,...
1
vote
0answers
25 views

Batching a query from a linked Oracle database in MS SQL

Working to compare and older Oracle database with a newer updated version to check that all documents have migrated correctly. 1=1 and 2=2. The database is very large ~25,000,000 rows. So I want to be ...
0
votes
1answer
43 views

How to remove the red squiggly line from IntelliSense for the newly created table or procedure without restarting the SSMS [duplicate]

A newly created table or procedure will always have the red squiggly underline until the SQL Server Management Studio is restarted. Is there a way to get rid of it without re-start the SSMS? Or it's a ...
0
votes
0answers
11 views

Give advise on a field/relationship of different table

Sorry if the title is vague. I'm creating a database using "MS SQL Server Management Studio" and accessing it via forms & reports using "MS Access". Currently, confused on BatchID field. I have ...
0
votes
2answers
54 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
0answers
21 views

SP times out when run via IIS but executes in 1 second when run in SSMS [duplicate]

I have a problem where a particular stored procedure takes about 1 second to execute when I call it manually from the SQL Server Management Studio, but when it is called by ASP.NET via IIS (this is ...
0
votes
1answer
24 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 ...
0
votes
2answers
20 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
55 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 ...
0
votes
0answers
41 views

Microsoft SQL Server Management Studio is busy doing internal operations

I have SQL Server 2016 Standard Edition SP1 and RAM, CPU all are normal when I got this message. Backups are running fine. The database size is 2 TB and I want to expand the database from SSMS, but ...
1
vote
1answer
69 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
42 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
22 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 ...
0
votes
0answers
98 views

SQL Server stored procedure not working when being executed from code

I have a stored procedure in SQL Server 2016 that runs fine when it is run in SSMS, when this command is used: exec UPDATEUser @user_id = 2, @first_name = N'john', @...
1
vote
2answers
43 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
42 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
61 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
58 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
20 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
0answers
69 views

Can't restore a backup using SSMS 2017

I am trying to restore the adventureworks sample database. In SSMS 2017 I right click on Database, selecte "Restore Database" then the "Device" option and then then option "ADD". I selected ...
0
votes
1answer
63 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 [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
62 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
29 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
160 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
99 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
33 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
66 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
39 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
60 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
56 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
51 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
225 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
44 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
62 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
2k 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
425 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
95 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
66 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
55 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
27 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
42 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
0answers
17 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....