Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssms]

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

192 questions
1
vote
1 answer

Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the schedule just added... what am I missing? (I'm using the…
Ariel
  • 423
  • 5
  • 15
1
vote
1 answer

Can you make a SQL Server Maintenance Subplan run after a previous subplan completes

I have a maintenance plan to do backups and cleanup of old data. It has three subplans, each with their own schedule. Can I set the schedule of subtask 2 to be "after subtask 1 is complete"?
Adam J.R. Erickson
  • 147
  • 2
  • 6
1
vote
1 answer

Fresh Install of SQL Server 2008 doesn't install managment studio. Help!

Ok I am running Windows 7, 64 bit. I cleaned of SQL server 2005 completely off my system leaving only SQL Compact Edition. I went here http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=en and…
PICyourBrain
  • 133
  • 6
1
vote
5 answers

Some rows giving "String or binary data would be truncated" error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. Error Source: .Net SqlClient Data Provider. Error Message:…
Feckmore
  • 145
  • 2
  • 3
  • 7
1
vote
0 answers

Haproxy blocking more TCP requests than expected

In short HAproxy is blocking my TCP requests while I expect not to be and found nothing in logs. Here the interesting part of my haproxy file : global log /dev/log local0 debug log /dev/log local1 debug chroot…
Arnaud F.
  • 133
  • 7
1
vote
1 answer

SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can…
Nick
1
vote
1 answer

SSMS via SSH tunnel

I'm trying to use SSMS to connect via a SSH tunnel (using Putty) to a SQL Server default instance running on an AWS server. I can establish the tunnel and access data in the DB using SQLCMD from a PowerShell window on my workstation. However, I…
tessex
  • 11
  • 3
1
vote
1 answer

SQL Server 2008 Management Studio missing

I installed a named instance of SQL Server 2008 on the computer where there have been already some instances installed (they were installed without SQL Server Management Studio). During this last full installation I included all options, including…
rem
  • 213
  • 1
  • 3
  • 9
0
votes
2 answers

How to allow remote connection to SQL Server instance only to specific public IP Address (white-list) & restrict access to all other IP's

How do I allow remote connection to SQL Server instance only to specific public IP Address (white-list)? For example, login from SSMS to SQL Server instance hosted on Windows dedicated server allowing access only from specific public IP. Also, the…
Anirudh Shankar
  • 1
  • 1
0
votes
1 answer

SSMS Designer Removing Square Brackets

I am designing a view that accesses tables in a linked server. Every time I paste this query into the SQL pane, Intellisense removes the square brackets, and then complains that there's more than 3 prefixes. I've tried turning Intellisense off, but…
Izzy
  • 8,224
  • 2
  • 31
  • 35
0
votes
1 answer

changed the name of the computer - SQL server

i changed the computer name, and entered this commands in SQL server management studio (ssms) sp_dropserver ; sp_addserver , local; i press this query select * from sys.servers this is the result is this okay? the…
Hans
  • 1
  • 1
0
votes
1 answer

SQL SSMS on development - clear ldf files

Working on building a big SQL Server database, I noticed my C drive is running out of space when running heavy SQL queries. The following folder size is over 150GB, log.ldf files reach over 50GB. C:\Program Files\Microsoft SQL…
r.tom
  • 1
  • 1
0
votes
1 answer

Need to add a login to a database for SSMS (Sql server) 2008 r2

I need to add a login to a database for SSMS (Sql server) 2008 r2 There is an answer to a very similar question here: How to add users to SQL Server 2008 Management…
JosephDoggie
  • 229
  • 2
  • 4
  • 14
0
votes
1 answer

How to install SSMS on a client workstation using Azure Automation DSC?

I found the following post - https://blogs.msdn.microsoft.com/troy_aults_blog/2017/01/13/automating-installation-of-ssms-with-dsc/ Great, all I need to know now is the Product Id of SSMS-Setup-ENU.exe, right? But how, on Earth, am I supposed to do…
mark
  • 725
  • 3
  • 15
  • 32
0
votes
1 answer

SQL 17.5 SSMS Install Fails

On a Windows 10 computer, the SQL 17.5 SSMS installation fails. From the logs, it appears that the error is in the VSTA 2015 installation. Running that (vsta_setup.exe) directly fails with the following error in the log file (named…
Glen Little
  • 455
  • 3
  • 7
  • 17
1 2 3
…
12 13