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

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 without occurring a license on the Database Engine…
abatishchev
  • 541
  • 1
  • 9
  • 31
3
votes
1 answer

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an x64 version of SSMS to no avail. I've tried…
Landon
  • 31
  • 2
3
votes
3 answers

Can I change a live SQL Database from Autogrow safely?

I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA. The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to growth unrestricted by 10%. I have lots of disk…
aSkywalker
  • 555
  • 3
  • 9
  • 15
3
votes
2 answers

SQL Management Studio - Restore from device problem

When specifying the Backup location by trying to click the Add button the dialog hangs and does not recover. This happens on all of our SQL 2000/2005/2008 environments. Could it be due to them running on virtual servers?
andrew
3
votes
1 answer

What permissions does SSMS Intellisense rely on?

We have a server on which SQL Server 2008 is running. When we connect to it with SSMS with some logins (from SSMS 2008), Intellisense is available. For others it isn't. The logins in question connect to the same database, and nothing else is changed…
MartW
  • 1,305
  • 10
  • 15
3
votes
1 answer

Why does SQL Server Management Studio generate two renames in a change script?

I have just created a change script using SSMS 2008 Express, for renaming two columns in a table. However, the change script contains four renames, using an intermediate temp name. Why is this? EXECUTE sp_rename…
ProfK
  • 493
  • 5
  • 9
  • 28
3
votes
1 answer

unable to connect to sql server analysis services on windows vista

I just installed sql server 2008 developer edition on my windows vista machine. The installation was successful. Reporting service is working fine. But I am not getting any option to connect to "Analysis Services" in sql management studio. The only…
user46277
  • 133
  • 1
  • 1
  • 4
3
votes
2 answers

How to connect to SQL Server via SQL Server Management Studio 2008?

I can't seem to get this to work. I have an IP address for a SQL Server. I have a login and password. How can I connect to it and work with it?
eski
3
votes
3 answers

SQL Server 2005: Copy SQL Server Agent Job?

I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an option for jobs, I'm looking for suggestions on…
Chris_K
  • 3,444
  • 6
  • 43
  • 45
2
votes
1 answer

Why can't I restore encrypted backup through front end?

I'm just starting to experiment with encrypting backups, I think I now understand it and have got the process working, but something strange is happening with restoring. On Server A (SQL 2014 Standard) I have created a new master key and certificate…
userSteve
  • 1,573
  • 4
  • 23
  • 33
2
votes
0 answers

Importing BACPAC via SSMS to Azure SQL Server fails with AzureAD user

Recently, trying to import a BACPAC to an Azure SQL Server using SSMS (SQL Server Management Studio) has been failing with the following error: Failed to connect to server ___.database.windows.net. (Microsoft.SqlServer.Smo) Login failed for user…
FrankieA
  • 141
  • 5
2
votes
0 answers

SSMS context menu on temporal (system-versioned) table doesn't show table actions

After enabling Temporal on my table, SSMS groups it with history table and context menu on my table doesn't show table actions, like "Select Top 1000 Rows", "Edit Top 200 Rows", etc. Is there some fix or workaround to this behavior? Update: looks…
JuozasU
  • 21
  • 2
2
votes
2 answers

SQL Server Managment Studio 2016 fails to open; multiple errors

Installing this was nothing short of a headache. I had countless issues. In order to install this (16.5.1), I had to uninstall C++ redistributable 14.0.24210, and install version 14.0.23026 in order to get the SSMS install complete. After…
user391293
  • 21
  • 1
  • 2
2
votes
3 answers

Is it destructive to use SQL Server Management Studio to modify properties on an MSSQL 2000 database?

We have a few databases that are stuck in legacy mode at SQL Server 2000. I commonly use SQL Server Management Studio from SQL Server 2005 to query the data in these dbs from my desktop, but have been logging in to the server to use the SQL Server…
cori
  • 381
  • 1
  • 8
  • 16
2
votes
4 answers

Sql Management Studio 2014 wont connect to clustered instance

I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to non-clustered 2000, 2005 and 2014 instances without…
Dib
  • 71
  • 7
1 2
3
…
12 13