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

Various logins feature of sql management studio 2008

In SQL management studio, you can open a New Query by right clicking on the Server Group itself rather than a registered server. When you do so, at the bottom right, you can see the user as and the database as . In this…
Rashmi Pandit
  • 194
  • 2
  • 12
0
votes
1 answer

Importing registered servers from sql mgmt studio 2005 to 2008

I have just got SQL Server Mgmt Studio 2008 installed on my machine. Previously I was working with SQL Server Mgmt Studio 2005. I had stored a number of databases under Registered Servers in 2005. I am able to export these to a .regsrvr file from…
Rashmi Pandit
  • 194
  • 2
  • 12
0
votes
1 answer

SQL Server Managment Studio: "Tasks->Generate Scripts" and "Script Database As"

I'm developing an application that connects to a SQL database which I am managing with SQL Management Studio. With each version of my app that I save in source control I want to also save a copy of the database schema that worked with that version.…
aireq
  • 101
0
votes
1 answer

SSMS 2008 not remembering connection login credentials

When connecting to a server on SQL Server Management Studio 2008, I'm entering the Server Name, and using SQL Server Authentication, entering Login & Password, and ticking Remember password. However, next time I open SSMS, the server name has been…
Curtis
  • 109
  • 1
  • 8
0
votes
1 answer

Management studio bug

This is on SQL 2008 R2 x64 I have installed management studio on all the computers at work, but for no apparent reason my management studio does not work on one of them. I've uninstalled it and reinstalled it twice now. Symptoms: Management studio…
Azshlanar
  • 49
  • 1
  • 7
0
votes
2 answers

Backup SqlServer to a FTP-folder

Is it possible to let SQL Server 2008 make a backup to a FTP-folder. I know it's possible to specify as the backup target in SSMS an UNC-path. But is there also the possibility to specify an FTP-Folder (inclusive user name an pwd)? If yes, what is…
HCL
  • 137
  • 5
0
votes
1 answer

Unable to restore database using Microsoft SQL Server Management Studio Express

I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express. It gives following error message: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is…
meetpd
  • 115
  • 4
0
votes
1 answer

SSMS 2008 - Can't Add Maintenance Plans

Trying to save a new Maintenance Plan using SSMS 2008 and receiving error: Apply to target server failed for Job 'DB Backup.createDBBackup' The connection has been verified. Is [dbo].[sp_add_maintenance_plan] suppose to be found under: Databases >…
Alex
  • 103
  • 1
  • 4
0
votes
1 answer

SQL Server Management Studio Agent Jobs List View

I've recently moved from using SQL 2000 Enterprise Manager to SQL 2008 R2 Management Studio. I am administering the SQL Agent Jobs of a remote SQL 2000 Server and need to find the Next Run details of several of the Jobs. In Enterprise Manager when…
Shevek
  • 199
  • 1
  • 9
0
votes
1 answer

Supertype question from a mega noob

I've tried a couple database creation tools (MS SQL Server, MySQL Workbench, etc.) and I cannot figure out how to create a super-type relation (complete, disjoint). Below is an example of how it looks in crow's foot notation. Even a link to a…
Eric Fossum
  • 225
  • 3
  • 11
0
votes
1 answer

No Reporting Server connect option in SQL Server Management Studio 2008 Express

I'm trying to connect to our SSRS reporting server, but in my local SSMS, the Connect drop-down on Object Explorer only lists Database Engine and SQL Server Compact. I only installed SSMS this week, so do I need any additional installs or what?
ProfK
  • 493
  • 5
  • 9
  • 28
0
votes
1 answer

Hotkeys missing on new SQL Server Management Studio install

I've just replaced SSMS Express 2005 with 2008, and my favourite hotkeys, like CTRL+N for a new query window, and CTRL+O to open a file in a query window, are missing. How can I restore them?
ProfK
  • 493
  • 5
  • 9
  • 28
0
votes
1 answer

Dialogs appear on wrong monitor with SQL Server Management Studio 2008

I am running SSMS 2008 on Windows 7 with a dual monitor setup (one large, one small). SSMS is running on the secondary monitor, but everytime a dialog is opened, the dialog is placed on the primary monitor instead. I've tried moving the dialog over,…
David
  • 1,293
  • 9
  • 10
0
votes
2 answers

How to remotely administer SQL Server 2005?

I have administrative RDP access to a server (call it ServerA) that has access to a SQL Server 2005 service (on ServerB). I do not have RDP access to ServerB, but would like to be able to use SQL Management Studio to browse the SQL Server…
Gabe
  • 133
  • 6
0
votes
2 answers

Only show databases to user in which he has db_owner rights

I have an SQL Server with several users and databases. The permissions are imho simple: user1 is db_owner of user1_db1 user2 is db_owner of user2_db1 user3 is db_owner of user3_db1 user3 is db_owner of user3_db2 If a user logs in to the server…
Remy
  • 1
  • 1
  • 1
1 2 3
…
12 13