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
5 answers

Error when trying to view properties in Management Studio

I am having trouble with sql manager after install SQL 2005 SP3, Can any shed any light on this one. Thanks TITLE: Microsoft SQL Server Management Studio Cannot show requested dialog. ADDITIONAL INFORMATION: Cannot show requested dialog.…
optician
  • 533
  • 8
  • 19
2
votes
1 answer

Missing menu items for Azure SQL tables within SQL Server Management Studio?

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table values etc ) is identical to the best of my…
DeepSpace101
  • 698
  • 5
  • 12
  • 25
2
votes
2 answers

SSMS import large table

I'm trying to move several tables of data between 2 MSSQL 2008 databases, I have generated data insert scripts for one table which is quite large (around 3.5M rows) The script is around 3GB. When I try and open the script with SSMS I get the…
undefined
  • 127
  • 5
2
votes
1 answer

Unable to save view: "There is already an object named 'Quotes' in the database." - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It only happens on some Views. Others save instantly. …
David
  • 439
  • 1
  • 5
  • 17
2
votes
2 answers

MSSQL 2008 is claiming the firewall is blocking ports even from local machine

I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message. The windows firewall on this machine is currently blocking remote debugging. Remote debugging requires that the debugging…
Mercurybullet
  • 121
  • 1
  • 3
2
votes
2 answers

Any known SQL Server 2008 Management Studio memory leak issues?

I'm not sure whether this question belongs here or to StackOverflow. I'm attempting here, since my question is in regards of memory leaks and management stuff more than programming. I have a SQL script which I attempt to run and everytime the server…
Will Marcouiller
  • 256
  • 2
  • 5
  • 16
2
votes
2 answers

Backup MS SQL 2000 db from SQL Management Studio 2005 on another server?

The situation: I have an instance of MS SQL 2000 running on one server. On another server I've installed SQL Management Studio Express 2005. I can access the SQL 2000 server from Management Studio. I try to run a backup of a database, but when I try…
Mikael Grönfelt
  • 677
  • 3
  • 7
  • 14
2
votes
2 answers

How To Backup A Maintenance Plan

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored (or imported) in case the changes made cause any…
Onion-Knight
  • 153
  • 6
2
votes
3 answers

sql server management console doesn't work with multi-byte characters

I'm trying to work out how to use SQL server management studio properly with multi-byte unicode characters. even something as simple as: select N'动漫' just returns square boxes in the result pane. I know the underlying database is set up correctly…
Andy
  • 499
  • 1
  • 5
  • 10
2
votes
4 answers

Is allowing remote Sql Server Management Studio safe?

I administer a website that runs on IIS on one box, and SQL Server 2008 Workgroup on another box. typically I remote into the DB box and run SSMS to work on the db, but I would like to be able to access the db directly with SSMS on my local box. …
dave thieben
  • 123
  • 5
2
votes
1 answer

Add shortcut SQL management studio 2008 to select top 1000 order by PK desc

when I right click a table I can select select top 1000 rows and edit top 200 rows I'd like to add an option select bottom 1000 rows I am pretty sure that I've seen it somewhere online how to do this. But I can't remember where... already found…
JP Hellemons
  • 267
  • 6
  • 16
2
votes
3 answers

How can you schedule a database backup on SQL Server 2005?

Not really familiar with MS SQL Server, but I did figure out how to manually backup a database locally: In SQL Server 2005 ( SP2 ) using MS SQL Server Management Studio : I navigate to Server->Databases->System Databases->master Right click on…
mozzer
  • 45
  • 7
2
votes
5 answers

SQL Server 2008 (SSMS) : Find next run date for a job

I would like to know if there is a way to get the next time a job is supposed to be running in SQL Server 2008, using a T-SQL query or even in SSMS if possible, without having to consult all the schedules for all the jobs. Thank you
MaxiWheat
  • 237
  • 5
  • 12
2
votes
3 answers

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not load file or assembly 'msddsp, Version=9.0.0.0, …
alex
  • 1,720
  • 15
  • 43
  • 63
2
votes
2 answers

Change Windows Authentication user for Sql Server Management Studio

We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this one particular computer, the person said they had…
Asmor
  • 141
  • 1
  • 2
  • 5
1 2 3
…
12 13