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
0
votes
1 answer

Generate Tables from ER Diagram Microsoft SQL Server Management Studio

I have developed an ER diagram using Microsoft SQL Server management studio. Is there any way to generate tables from that ER diagram? (Forward Engineering) In MySQL this thing can be done using MySQL Workbench. But my DBMS is Microsoft SQL Server.
JayNaz
  • 343
  • 1
  • 5
  • 24
0
votes
1 answer

Remove foreign key and reference tables in SQL Server

I have four tables Store, Employee, Customer, Address. I have linked the first three tables to Address. Now I want to remove this FK and reference these tables to the Address. How can I do it? Table structure: Store: StoreID(PK),…
DhavalR
  • 1,409
  • 3
  • 29
  • 57
0
votes
2 answers

How to calculate the sum of an attribute after an inner join?

I'm looking to get the sum of the 'Price_amount' attribute result set. The answer is 100+150=250 but how do I get this to display as a result set? This is my query so far: SELECT * FROM tBoard INNER JOIN tPrice ON tBoard.PriceBand_ID =…
Jez Clarke
  • 41
  • 2
0
votes
0 answers

assign a Stored procedure to run as a scheduled task

So...Im running Microsoft SQL server management studio...ive created a stored procedure [ResetOrganisationPaymentPackage] which resets a users account. Tried and tested works fine. Now I would like to set this stored procedure to run as a schedule…
John
  • 3,965
  • 21
  • 77
  • 163
0
votes
1 answer

SQL Server 2014 Computed Column Specification Calculated Field Formula Error

Using the below column names in the formula field of computed column specification category (using Management Studio). [[App_1]+[App_2]+[App_3]+[App_4]] I'm getting this error: 'MyDatabase' table Error validating the formula for column…
Sixthsense
  • 1,927
  • 2
  • 16
  • 38
0
votes
0 answers

How to connect mysqlp express 2005 to my website?

Is it possible that I can connect SQL Server Management Studio Express to my website? Please help me or provide me a link me to any article detailing the process.
newbie
  • 59
  • 7
0
votes
1 answer

MSSQL 2014 Format function is not recognized

I'm using MicrosoftSQL Server 2014 and Management Studio version 12.0.4100.1 and trying to use Format function to do the following: Format([money spent], 'C', 'en-us') as 'You Spent' When executing that statement I get the following error: 'format'…
gene
  • 2,098
  • 7
  • 40
  • 98
0
votes
1 answer

SQL Server Management Studio - Failed to start debugger (Error 229)

I put a breakpoint somewhere in a stored procedure in SQL Server Management Studio and then press start debugger. I end up getting Error 229 error (failed to start debugger) It appears to be a problem with permission, and I tried to ask the DB…
Edgar Navasardyan
  • 4,261
  • 8
  • 58
  • 121
0
votes
0 answers

Can't paste some characters in SQL Server management studio

I try to copy the column value from query results into the SQL Server Management Studio Query window. The column value displays a value like this: Caserí-o La Dehesilla However, the - character is not a regular hyphen character it seems, because…
Adam
  • 6,041
  • 36
  • 120
  • 208
0
votes
1 answer

Adventureworks - Finding all the store names in the database

so I'm learning SQL using the sample database Adventureworks and we've been given a couple of questions and with the correct number of rows so we will know if our queries are correct or not. I'm having trouble finding all the store names in the…
Jordan Daniel
  • 31
0
votes
0 answers

Access denied option when i am trying to create table in design mode in sql management studio

I am getting the "Access denied" error when i am trying to create a table in design mode in SQL management studio. I tried all the options given into "property" menu of the database, but i was unable to find the appropriate solution for giving the…
Aakash Maurya
  • 128
  • 2
  • 16
0
votes
0 answers

Will SQL Server 2012 Express Management Studio work well with SQL Server 2012 Standard Edition?

Can I use SQL Server 2012 Express by installing Management Studio of Standard Edition 2012? I installed SQL Server 2012 Standard edition, now I have setup of Express 2012 Management Studio. If I will download management studio once more for standard…
Nab
  • 61
  • 2
  • 10
0
votes
1 answer

MS SQL SERVER 2005 express - Can't find import/export wizard

I have installed ms sql 2005 express i have installed the management studio, i tried(all components already installed) to install the ms sql 2005 express toolkit. I've searched for the .exe and for the option inside the management studio, and i…
user3751397
  • 1
  • 1
0
votes
1 answer

How to connect a database in SQL Server Management Studio to a Windows Form Application in Visual Studio?

I created a dummy database that I filled with some values. I did this in Management Studio. In parallel, I am creating a Windows Form Application where I will have buttons that will perform queries on the database I created in Management…
Ralph
  • 2,959
  • 9
  • 26
  • 49
0
votes
3 answers

How REALLY do a silent installation of MS SQL 2008 R2 Express RTM - Management Studio

I try to make a silent installation of the MS SQL 2008 R2 Management Studio Express with NSIS but I have no succeed so far. In theory, the installer will do a silent install if I pass the /QUIET /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SSMS…
NoNameProvided
  • 8,608
  • 9
  • 40
  • 68
1 2 3 4
5
6