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

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ColdFusion Background: I have a development…
Denoteone
  • 151
  • 3
5
votes
1 answer

Is there a way of setting up a shortcut to a database for MS SQL Server Management Studio

I'd like to have a list of my database servers (I am a developer), I currently have a list of RDP files for different machines I connect to. Is there a similar feature in SQL Server Management Studio that would help me go directly to where I need…
Phil Hannent
  • 665
  • 2
  • 10
  • 21
4
votes
8 answers

SQLServer - need to access an ACT! database for data migration

I'm looking for a way to access data in an ACT! database for a data migration to a custom application. The ACT! software uses SQLServer 2005. The data conversion script and new application will be written on a Linux system using Python and…
JeffG
  • 41
  • 1
  • 2
  • 4
4
votes
2 answers

Weird bug when copying from sql server management studio to excel in windows 7

I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel. The result: two specific records are put together on one row in Excel. With two specific I mean that I first got 26000+…
Ernst
  • 41
  • 1
  • 2
4
votes
5 answers

Results copied from SSMS splitting across columns when pasted into Excel

SSMS 2008 -> Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to columns' wizard with 'spaces' and 'brackets' as…
adolf garlic
  • 171
  • 1
  • 1
  • 8
4
votes
3 answers

Hide database from other users in SQL Server 2008

I have created a database in SQL Server 2008 and it shows in server object explorer to all users that can login to SQL. I want to hide it from those users, I want it to be viewable by me only. How can I do that? Any help, suggestions? Many thanks
John
4
votes
2 answers

export proper csv from SqlServer management studio query result

in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any commas in the data itself, which often leads to a…
Gabe Moothart
  • 153
  • 1
  • 1
  • 5
4
votes
2 answers

Installing .NET 1.1 over later versions: Safe?

I have a server that is running all versions of .NET Framework, from 2.0 up to 4.0. An application I need to deploy won't run correctly on later versions, and was originally compiled for 1.1. Is it safe to install version 1.1 on the machine…
Cyberherbalist
  • 337
  • 1
  • 4
  • 14
3
votes
1 answer

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' on Azure SQL with Active Directory Admin via SSMS

When I attempt to connect to an Azure SQL Server via SQL Server Management Studio using the "Active Directory - Universal with MFA support" method with an account that is configured as the Active Directory Admin, the following error message is…
Fabian Schmied
  • 171
  • 1
  • 6
3
votes
1 answer

Access Denied issue, SQL Server LocalDB on Windows Server 2008 R2 SP1

Running SQL Server LocalDB 2012 and 2014 on Windows Server 2008 R2 SP1 VM I have some bizarre issues which don't happen when running on Windows 7 or Windows 10. I can create databases, save data to them, but then after a few minutes the database…
Sugrue
  • 173
  • 1
  • 9
3
votes
0 answers

Restoring database from SSMS UI freezes SSMS

I am using SSMS 17.3. I try to restore a database from the UI, click on 'Device' radio button and click on the ... to select a file, SSMS freezes. I have to kill it. I have to restore databases using SQL. Any ideas why it freezes?
Tony_Henrich
  • 954
  • 3
  • 12
  • 23
3
votes
1 answer

Cannot connect to SQL Server Integration Services from SQL Server Management Studio: "Class Not Registered"

On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016. I am able to connect to my SQL Server (as a…
Michael Plautz
  • 173
  • 1
  • 1
  • 7
3
votes
2 answers

SQL Server Management Studio not scripting all objects

i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the options being selected including all tables the…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
3
votes
2 answers

How to install Microsoft SQL Server 2008 Management Studio Express

I have Microsoft SQL Server 2008 Express Edition already installed, and now I want to install SQL Server 2008 Management Studio Express. I've tried with the only two options that look feasible: [...] Add features to an existing installation Launch…
Jose Carlos
3
votes
1 answer

How do I permanently add additional connection parameters in SQL Server Management Studio

In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See http://technet.microsoft.com/en-us/library/cc645898.aspx. I need to…
Greg
  • 153
  • 1
  • 7
1
2
3
…
12 13