ssms Questions
3
Solved
Is there a way to get the 'Script Table as' > 'CREATE To' option for tables in SQL Server Management Studio to preserve the collation types set for each column?
I know it's possible to specify col...
Teaspoon asked 23/8, 2013 at 8:51
7
Solved
I have a database in SQL Server with a lot of tables and wish to export all tables in csv format. From a very similar question asked previously - Export from SQL Server 2012 to .CSV through Managem...
Astonishment asked 11/6, 2015 at 21:8
11
I have followed the official Microsoft documentation and I have installed SQL Server Docker image
As result I have a SQL Server image running on Docker at the IP address 172.17.0.2
I also can ...
Wellrounded asked 17/5, 2020 at 21:45
9
Solved
I have many .sql files with lots of empty lines, for example,
WITH
cteTotalSales (SalesPersonID, NetSales)
AS
(
SELECT SalesPersonID, ROUND(SUM(SubTotal), 2)
FROM Sales.SalesOrderHeader
...
Ordway asked 30/4, 2010 at 5:51
4
Solved
Aside from context menu -> "Edit Top 200 Rows" from Object Explorer, is there a quick way to open a table in Edit mode where I can just quickly modify the value of a cell?
I need to be able to pa...
Intisar asked 8/10, 2009 at 3:28
1
Solved
I am trying to connect to from SSMS/VS 2022 to a database hosted on Azure. When trying to login via either application, the authentication option "Azure Active Directory - Universal with MFA&q...
Abran asked 4/1 at 13:55
4
I couldn't see the results in grid pane, so I did the following:
Tools > Options > Query Results > Results to Grid
> uncheck the "Discard results after execution" check box
But st...
Modeling asked 11/8, 2018 at 14:46
21
I installed Microsoft SQL Server 2008.
When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server name. I have tried a lot of names,...
Damle asked 18/4, 2013 at 16:18
5
Solved
SSIS Catalog Package error - Version of FlatFile destination not compatible with version of DataFlow
Getting error
"The version of flat file destination is not compatible with this version of the dataflow"
when trying to execute a SSIS package from the catalog, the package executes well from v...
Devoir asked 7/4, 2020 at 15:17
9
Solved
I'm trying to debug the source of a SQL timeout in a web application that I maintain. I have the source code of the C# code behind, so I know exactly what code is running. I have debugged the appli...
Willams asked 11/2, 2010 at 22:7
3
Solved
I am trying to use Ctrl K + Ctrl D (format document) in SQL Server Management Studio. It gives the message
The key combination (key, key) is bound to command(command) which is not currently ava...
Winterfeed asked 20/12, 2011 at 21:2
11
Solved
I use SQL Server 2012 and I have some databases on it. The problem is I suddenly get an error saying,
object reference not set to an instance of an object
I get this error when:
Going to wr...
Rubefaction asked 29/8, 2014 at 19:19
6
I'm trying to use the STRING_SPLIT function in Microsoft SQL Server 2019. The function works, if I only put in two arguments, but since I want to extract a specific element from the string, I would...
Ucayali asked 26/1, 2022 at 11:30
12
I've recently used our company's spare laptop (that has a general user set up) while mine was being repaired. I've checked the "Remember password" option in SQL Server Management Studio when loggin...
Resist asked 8/12, 2008 at 14:14
20
Solved
I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half of the tables which have been created.
For example whils...
Homocyclic asked 1/9, 2009 at 13:36
6
I thought this would be pretty straightforward, but I have about 80 databases in the server I am looking at, each database has 5-500 tables.
I am wondering how i can search for a TABLE NAME across...
Chayachayote asked 22/3, 2018 at 14:5
15
I want to edit some row values once I get a query output in the result grid.
Its true that we can right click the table and say open table to get an editable table output, but what I want is editab...
Sargasso asked 28/12, 2010 at 3:33
8
I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a "bak" file. I do this by overwriting an existing database. In the "Options" page, there is a check-box ...
Suffer asked 26/9, 2013 at 13:33
3
Solved
This happens intermittently and seems to be related to accidentally hitting a key.
Any ideas what causes this?
Foley asked 4/8, 2009 at 13:43
6
Solved
Here’s the simplest repro case possible.
Create a brand new database. (I'm using SQL 2005.)
Create a login, a SQL user, and a table in the new database (see sample code below).
Launch SSMS and op...
Toby asked 4/1, 2010 at 22:35
8
I am trying to "Edit top 200 rows" in SQL Server Express edition, but it's returning with the blank file as shown here:
Showing blank file with disable tools
I have installed this SQL Ser...
Mascarenas asked 29/11, 2022 at 11:38
4
Solved
I created and executed a dtsx with SSMS corresponding wizard:
This was to import a flat file in an existing table.
At the end I saved the "package" as a .dtsx file
Now I need to modify the colu...
Ternopol asked 22/1, 2019 at 11:25
9
Solved
I'm trying to add a table to my newly created database through SQL Server Management Studio.
However I get the error:
the backend version is not supported to design database diagrams or tables
...
Tussis asked 5/8, 2014 at 19:8
3
Solved
Recently I've found out, that there's an option to include most commonly used queries to be executed by clicking a button on SSMS toolbar.
You can do that by following these steps:
Right mouse c...
3
Solved
I have just upgraded to SSMS 2018 and have noticed that the results text seems much smaller and is hard to read from further away.
I have tried changing the font size however it only changed the ...
Seagoing asked 6/6, 2019 at 8:56
© 2022 - 2024 — McMap. All rights reserved.