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
0 answers

SQL Server: DB Mail Not getting triggered after certain Size

I am sending csv file from SQL Server using below query. EXEC @RtnCode = sp_send_dbmail @profile_name = 'Mail', @query_result_separator=@Separateur, @recipients = 'xxx@xxx.com;', @subject = @mailSubject, @query = @STMT, …
Erma
  • 337
  • 1
  • 6
  • 14
0
votes
0 answers

SQL Server doesn't Connect to any server except local machine

I am getting "A network-related or instance-specific error .... " when I try to connect to any external SQL server. I can connect to local server only external servers gives the error. I am using SQL server 2017 and SSMS 14. I have read the topic…
Ibrahim
  • 41
  • 1
  • 8
0
votes
0 answers

Unable to install SQL Server 2014 Express Management Tools because of Microsoft Visual Studio 2010 Shell?

I could not install SQL Server 2014 Express Management Tools and its Management Studio and when I checked Summary log file I encountered with this text which I could not understand: Detailed results: Feature: Management Tools - Complete Status:…
Leo Sam
  • 83
  • 1
  • 12
0
votes
0 answers

How to parse MSsql string

Help please I need to get from this string SELECT value FROM STRING_SPLIT('<166>%ASA-6-302013: Built outbound TCP connection 322558458 for ethKASSY:192.168.1.13/10001 (10.21.8.13/10001) to ethASK_EXT_TSSM:10.43.8.24/5508 (192.168.1.10/30475) ', '…
koly86
  • 165
  • 2
  • 11
0
votes
1 answer

How to send an e-mail from database if some condition is met?

I am beginner. We have: database, schema, tablename Table contain columns: Number, State, ExportTime, ImportTime I need to create a procedure which will send an email from the database (MSSQL) to my mailbox if the amount of the records is bigger…
youneverknow
  • 1
  • 1
  • 1
0
votes
2 answers

how do i update column (selmanufacturers_id) from the query

SELECT 'S. J. & G. FAZUL ELLAHIE (PVT) LTD.' AS CompanyName, 'E - 46, S.I.T.E., KARACHI - 75700' AS CompanyAddress, 'admin' login_user, 'crm.sjg.local' selhost, 'admin' sellogin, 'sr_salereport' seltoprint, 'SALES REPORT'…
Sikandar Sahab
  • 638
  • 3
  • 10
  • 27
0
votes
0 answers

Can't connect to tbe server in Microsoft SQL Management Studio

When i try to connect to the server in Microsoft Management Studio 2014 i get this error. The error that is being shown:- I have followed many articles in order to eradicate my problem but i am unable to resolve it. Whenever i browse for more…
Zakharhabib
  • 25
  • 8
0
votes
0 answers

How to refer to specific column within datagrid

I am currently creating a system within visual studio connecting to SQL database Management System. I am trying to write an if statement which takes the value that is in the specific column and if its equal to 'y' then I follow with an update…
G.McGonigal
  • 1
0
votes
2 answers

Is there any cross server sql request utility like linqpad?

Is there any cross server sql request utility like linqpad?(at least pseudo cross server) or is there any way i can make cross server requests using management studio?
Grigoryants Artem
  • 1,401
  • 2
  • 15
  • 32
0
votes
3 answers

Join 4 different tables with one table

I have a table 1 where I need to join with other 4 tables. Can I write the same query using subqueries? Because if I am using below query it is taking long time (more than 40 mins) for running. Is there any other way for this? select T1.ID as IID,…
user6140121
0
votes
2 answers

Sql - store date in YYMM / YY-MM format without conversion

I am trying to store my date in the format 'YYMM' / 'YY-MM' as date type without conversion, as I only need the year and month. Solutions I've searched online are mostly by conversion like Cast etc. Was wondering if it is possible to configure it…
lalalaa
  • 21
  • 1
  • 4
0
votes
1 answer

Show executed query in Microsoft SQL Server 2016

In MySQL Workbench, after editing a column, table, or whatever, it will show the query for that action. I could not find a similar feature in SQL Server 2016. I just want to view the SQL for the action I perform, such as editing a column. Is it…
Charles
  • 151
  • 2
  • 13
0
votes
1 answer

Parse SQL script as 2005 in 2012?

In SQL Server 2012 Management Studio, is there a way to to parse my SQL as SQL Server 2005 syntax? My development PC has SQL Server 2012 Express but the production server uses 2005. I have to hook into a 2005 development server to run my tests…
Mitkins
  • 4,031
  • 3
  • 40
  • 77
0
votes
1 answer

I can't see the "Modify" option on the Stored Proedures, Microsoft SQL Server Management Studio

Since I updated my Microsoft SQL Server Management Studio last week I can't see the option "Modify" my Stored Proecedures. When I click the right mouse key on the stored procedure I just can see: Stored Procedure... Script Stored Procedure…
Joan Nadal Brotat
  • 122
  • 1
  • 11
0
votes
1 answer

How do I make a vb.net project in visual studio that uses a sql server database, but make that database available offline when users are off site?

I have a program that helps salesmen design and price products. The pricing information for the program is held on the server in a SQL database and accessed with a dataset as normal. My program will therefore run if the user is connected to the…
Jolrath
  • 1
  • 1
1 2 3
4
5 6