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
1
vote
1 answer

ms sql powershell

I want to execute a powershell script within microsoft management studio. But I get an error. Look below for more details: EXEC master..xp_cmdshell '%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy unrestricted -command…
Ezra P.
  • 91
  • 1
  • 1
  • 12
1
vote
2 answers

PHP connect to SQL server with a windows account

I am trying to connect to a SQL server database with a windows account. In sql managment studio, I can open the database with this account but not with my php application. This user is not a sql user, but he have the right on the SQL database. I…
Etienne
  • 408
  • 2
  • 9
  • 28
1
vote
1 answer

In Management studio how to import csv into existing table and making datatypes match

I have an already set up table in management studio where all of the datatypes are varchar(50) while a few are varchar(80), I want the ability to delete all the rows in the table and import new data(csv) in using the import wizard, but for some…
bdanger
  • 63
  • 1
  • 7
1
vote
0 answers

SQL server Management Studio: Search produces "Search invalid " result always

Ok so I was looking for an option using which i could locate a particular Table or Proc in Object explorer if i know the name just to avoid the whole scrolling thingy in the object explorer pane (some thing like a 'ctrl+ [ + S' shortcut of Visual…
Saruchi
  • 346
  • 2
  • 13
1
vote
1 answer

Does SQL Azure support REPLACE T-SQL function with cyrillic characters?

I am trying command like USE [aaa] GO SELECT [Id] ,REPLACE([BlaBlaField], 'xyz','') FROM [dbo].[aaa] GO through SQL Management Studio on SQL EXPRESS and SQL Azure Web Edition DB. In SQL Express it works, but on Azure it does not. I…
Ognyan Dimitrov
  • 6,026
  • 1
  • 48
  • 70
1
vote
1 answer

instance servername sql server 2012

Hello I have installed management studio 2005(x64) alse I have microsoft sql server 2012 in my pc. But cant connect server due to dont know server name. (if sql server 2008 express were in my pc, default servername would be "./sqlexpress") How can I…
user3004070
0
votes
2 answers

Using workbench to connect to SQL server on management studio

I have been trying to connect to the server on Microsoft SQL Management Studio using Workbench via an IP. But I cannot seem to connect whatsoever, is workbench even supported with Database engine servers. I am connecting with the root username,…
Governor
  • 300
  • 1
  • 10
0
votes
0 answers

sql management studio diagram does not open

Hi I want to open the diagram I created in sql, but when I click to open it, sql management studio closes without any error.
İlhan Enes Daniş
  • 1
0
votes
2 answers

You cannot insert the value NULL into the column 'sdept', the table 'XSGL.dbo.student'; the column does not allow Null values. INSERT failed

There are my problems on SQL Server. I have a Database named XSGL to management the students' information. First, I create a view named IS_Student on table student. CREATE VIEW IS_Student AS SELECT sno, sname, ssex, sage FROM student WHERE sdept =…
guapi
  • 123
  • 7
0
votes
0 answers

Microsoft SQL Server Management Studio Select Database Syntax Error

I'm trying to type out some code to return the name of the current database. Literally every place I've seen says that you can type out SELECT DATABASE() to return that information, but when I try to do it in SSMS I get a syntax error for the…
Splatterfest233
  • 3
  • 4
0
votes
1 answer

SSMS Export to CSV or copy paste break comment column

I have simple table with 8-10 columns and one of the columns is a comment column with can have about 500 characters of text with line breaks also. The problem is that when I export data using SSMS without the Comment column it exports to CSV or even…
Learning
  • 19,469
  • 39
  • 180
  • 373
0
votes
1 answer

How to allow remote connection in MS SQL server management studio, on a port different then 1433?

I was having credentials for this remote MS SQL database for quite a long time. The port for connection was 1433 and I was connected via "Microsoft SQL Server Management Studio". After some time, my client changed the credentials and gave me the new…
delux
  • 1,694
  • 10
  • 33
  • 64
0
votes
0 answers

Slow INSERT - MS SQL - execution time of every step

I've got an INSERT in stored procedure: INSERT INTO t1 SELECT TOP 3 x FROM t2 WHERE NOT EXISTS (SELECT 1 FROM t3 inner join t4 on t4.z = t3.z) My question is: Is it possible, to get execution time of every step in this insert? I'm using SQL SERVER…
Hawex
  • 133
  • 13
0
votes
2 answers

SQL 2005 Moving from Godaddy SQL Server to a company owned server

What is the best way to go about moving a database from a Godaddy SQL 2005 account to a local SQL 2005 server? I have access to the DB through Server Management Studio Express and also through the Godaddy SQL explorer. However, I have no idea where…
Dexter
  • 795
  • 2
  • 13
  • 27
0
votes
1 answer

What SQL Server 2017 Edition has the agent?

Right now I have the express version and I need some automated work done and thus, I need the agent in my SSMS, my question is: Which edition has the agent? On the website I've seen... Enterprise, standard - per core, standard - server +…
user4283143
1 2
3
4 5 6