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
2
votes
2 answers

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express?

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express? Is that a must for me to install MSSQL 2008 Express?
Billy Cheung
  • 131
  • 2
  • 5
1
vote
1 answer

Local Computer drives are not visible when creating backup through wizard

When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are drives on the remote server and I can't get access…
Muhammad Musavi
  • 111
  • 4
1
vote
1 answer

Why do I get different memory numbers using TSQL versus the GUI?

I'm preparing to bump up our max server memory value after a RAM upgrade on our server. I'm testing the commands out on a test SQL Server and I'm not sure why I'm seeing different results with T-SQL versus the GUI. I changed the memory on the test…
cspell
  • 195
  • 1
  • 2
  • 6
1
vote
2 answers

Copying a SQL database under a new name to same server

I am trying to create a copy of a SQL Server 2008 database under a new name on the same server. I have physical access to the machine. I have tried to create a full backup and then restore that backup under a new name and I get an error from SSMS…
Earlz
  • 1,019
  • 5
  • 13
  • 29
1
vote
1 answer

Restore incorrect syntax near 'dbname'

I'm trying to restore a db to a new location, using the following in SQL Server Management Studio for Server2012: RESTORE [newdb-name] FROM DISK = '..\backupfile.bak' WITH MOVE 'olddb-name.mdf' to '...\newdb-name.mdf', MOVE 'olddb-name_log.ldf' to…
whybull
  • 13
  • 3
1
vote
1 answer

Connecting local SSMS to Sql Server High Availability running on virtual machines in Azure

We are currently running a High Availabilty SQL Server using two VMs in Azure with a Load Balancer. We would like to be able to connect SSMS running locally on our machines to that SQL Server and are running into some issues that I hope are easily…
Snarfblatt
  • 193
  • 4
1
vote
3 answers

attach / detach mssql 2008 sql server manager

An external consult wrote a guide on how to copy a database. Step two was detach the database using Sql Server Manager. After the detach the database was not visible in the SQL Server Manager... Not much to do but write a mail to the service…
Tillebeck
  • 511
  • 1
  • 4
  • 19
1
vote
5 answers

Merge mulitple databases into single database with multiple schemas in SQL Server 2008

I have five smallish databases all within a single SQL Server 2008 instance. The databases are related (by business entity but not by data) so I'd like to merge them into a single database and give each its own schema within that…
Michael Itzoe
  • 215
  • 2
  • 5
  • 9
1
vote
1 answer

SQL Server 2012 constant CPU load

I'm trying to diagnose an abnormal CPU usage of the sqlservr.exe process from a SQL Server 2012 Express installation. The installation is running in a VM with Windows Server 2012 R2, 8-core Xeon E5 and 8GB of RAM. The CPU load (from both…
tsmr
  • 11
  • 2
1
vote
0 answers

Unable to remotely connect to SSIS catalog

I have an SSIS installation on which I can not connect through our Citrix hosted Sql Server Management studio. I can connect to it when running SSMS locally. But if I try to connect remotely, with the Citrix hosted SSMS, I receive the following…
Reaces
  • 5,597
  • 4
  • 38
  • 46
1
vote
4 answers

Trouble connecting to a remote instance of SQL Server 2008 (Developer Ed)

I just installed a named instance of SQL Server 2008 Developer Edition on our Windows 2008 server. I've been working all morning trying to enable remote connections but have been unsuccessful. Here are some details: SQL Server service is running…
Kevin Babcock
  • 243
  • 1
  • 4
  • 12
1
vote
0 answers

Azure DB Backup Using SQL Server Management Studio

I've read a number of articles here, but, really haven't come across a solution. I'm using SSMS 2016 to manually back up a Azure DB on a regular basis. I do this through the Generate Scripts option. I have not attempted to restore from this data…
toddward
  • 43
  • 5
1
vote
1 answer

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see the other databases in SSMS as they contain other…
lethalMango
  • 127
  • 4
1
vote
1 answer

SQL SSMS Window Dissappear

When I open SSMS, I choose windows authentication, but the window just goes away; it doesn't say I'm not allowed. I've accessed these db servers before, the exact same way, and it has worked. Now, the window just goes away. According to Task…
JosephDoggie
  • 229
  • 2
  • 4
  • 14
1
vote
1 answer

Viewing a large field in a query in SQL management studio with ZOOM?

Can anyone help? I am using SQL management studio (sql server 2008) to run queries and some of the fields that come back are varchar(max) for example and it has a lot of information - Is there a zoom feature to open the window and show me the…
user11655
  • 197
  • 1
  • 1
  • 5
1 2 3
…
12 13