Stack Overflow
Stack Overflow

Questions tagged [management-studio-express]

Microsoft SQL Server Management Studio Express is the freely downloadable version of Microsoft SQL Server Management Studio, a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

81 questions
47
votes
5 answers

SQL Server Management Studio - adding foreign key confusing?

I always find it confusing to add foreign keys to primary table in Management Studio. Lets say I have a Table1 { ID int, -- Primary Key Table2ID int, -- Refers to Table2's ID } Table2 { ID int, -- Primary Key SomeData…
tvr
  • 4,455
  • 9
  • 24
  • 29
19
votes
1 answer

How to see in which column data truncation has happened

Inserting data into a Microsoft SQL Server database using Java, I got an SQL truncation exception. But the exception doesn't show which column had the problem value. Is there any way to find the error details, for instance from SQL Server Management…
Rajasekhar
  • 894
  • 5
  • 13
  • 25
18
votes
2 answers

In SQL Server Management Studio 2014, the New Trigger menu option is disabled

I want to add a new trigger to my table. As seen in the picture, New Trigger button is not active. new index, new column, new contraints, new statics is active. I do not understand what is the problem.
pak
  • 230
  • 1
  • 2
  • 11
15
votes
5 answers

SQL Server Management Studio: Reconnect query tab after database restore/lost connection

I have several long queries in SQL Server Management Studio. If my connection is lost/broken (e. g. after Restore of the database), how can I reconnect my SQL query tab to the database? My context menu for the connection only contains deactivated…
Mate
  • 241
  • 1
  • 2
  • 11
7
votes
2 answers

SQL Server could not find stored procedure 'show'

I can't use the most basic procedure, show, as it throws an error: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'show'. I used: SHOW DATABASES Please help me find answers to this issue.
Ashot Bagdasaryan
  • 71
  • 1
  • 1
  • 2
6
votes
3 answers

sql network interfaces error 26 - error locating server/instance specified

Okay so a lot of people have posted a similar question, however I don't seem to be able to find a solution to my problem in any of them. So this is my situation. Yesterday I was working with my SQL Server Express through SQL Server Management…
Michael Tot Korsgaard
  • 3,892
  • 11
  • 53
  • 89
5
votes
1 answer

CREATE DATABASE ends up cloning an old database

I have run into something quite odd, i haven't had this issue before, or maybe i'm missing something here. In SQL Server Management Studio 2012 i am trying to run a Query to create a new database but it ends up cloning an old database, the code i'm…
ArturoAP
  • 432
  • 2
  • 13
3
votes
2 answers

IDENTITY_INSERT SQL script

Situation I have a SQL script that I need to push some basic data to my database. Therefore I use the following script (and others). I want to provide manually an primary key for the rows I manually create. Problem If I execute the script it will…
Timon Post
  • 2,779
  • 1
  • 17
  • 32
3
votes
2 answers

How to show filter databases in management studio object explorer

My database is hosted in a shared hosting. I connect my database remotely in Management Studio Express. Whenever i try to connect to sqlserver instance it shows all the databases that are hosted in that server instance. This annoying to find out…
manas
  • 6,119
  • 10
  • 45
  • 56
2
votes
1 answer

Right click to query temporal tables not working

I have SQL Server Management Studio 2016 loaded with Microsoft's test database (WideWorldImporters) but for some reason, any table that is a temporal table does not give me the option of right clicking and selecting the last 1000 rows as all other…
Chris Hawkes
  • 11,923
  • 6
  • 58
  • 68
2
votes
2 answers

Insert new colum with previous rows information

I have this table: Id |Name |ParentId 1 |John |Null 2 |Oscar |1 3 |Peter |2 4 |Abbey |3 5 |Adrian |4 6 |Barbara |5 and i want to…
Luís Tiago
  • 113
  • 2
  • 10
2
votes
1 answer

Change SQL Server 2008 R2 Management Studio theme to dark

I change the color theme of Visual Studio to dark. It's very cool, especially for my eyes. I also very often use Microsoft SQL Server Management Studio. The problem is when I change from Visual Studio to SQL Server Management Studio it's a pain for…
miguelbgouveia
  • 2,963
  • 6
  • 29
  • 48
2
votes
2 answers

Clone an existing database to a new database

I'm struggling to find a suitable solution to this. I have a fairly large SQL Server 2008 Express database containing 60+ tables (many with key constraints) and a whole bunch of data. I need to essentially copy all of these tables and the data and…
Dan
  • 5,836
  • 22
  • 86
  • 140
1
vote
4 answers

SQL Server 2008 R2 Express with advanced services installation does not have all options

I don't know how else to ask this, and I think the title could be changed. I've been downloading different SQL Server Express versions, and I can't seem to find the one that has the Management Studio Express, the fulltext search, and the Reporting…
pqsk
  • 2,124
  • 3
  • 23
  • 28
1
vote
2 answers

Apply local DB changes to Azure SQL Database

I have a backup file that came from Server A and I copied that .bak files into my local and setup that DB into my Sql Server Management Studio. Now After setting it up I deployed it in Azure Sql Database. But now there were change in the Data in…
MadzQuestioning
  • 3,341
  • 8
  • 45
  • 76
1
2 3 4 5 6