The mssql-ssms tag has no wiki summary.
0
votes
1answer
7 views
SSMS doesn't show all installed Instances
I've installed two named instances (SQLEXPRESS & MSSQLSERVER) but in SMSS, it only shows SQLEXPRESS when I try to connect.
How can I connect to MSSQLSERVER from SMSS.
Note. SQLEXPRESS was ...
0
votes
0answers
8 views
Is there an SQL Server Service Broker wizard or gui?
Using SQL Server Management Studio i try to create a "New Service Broker Application". What i get is a wall of T-SQL (that doesn't run).
i'd rather not have to spend time pouring over MSDN trying to ...
0
votes
1answer
40 views
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 ...
0
votes
1answer
19 views
Export SSMS database connections to a new version
I just installed SSMS 2012 and realized it didn't copy my database list (the one that appears on the 'Connect to Server' dialog).
I have a ton of entries there, is there any way I can export them ...
0
votes
0answers
34 views
SQL Server Management Studio Express 2008 is unresponsive
I use SQL Server Management Studio Express 2008 to manage SQL Server Express 2008. It (Management Studio) was working until recently, but now on opening it just hangs indefinitely, with all the panes ...
0
votes
1answer
115 views
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 ...
0
votes
1answer
31 views
SQL Server 2008 Management Studio Express: won't recognize local instance
I’m having a lot of trouble getting Management Studio Express 2008 to recognize my local instance of SQL Server 2008 (SQLEXPRESS).
Background: I’ve installed SQL Server 2008 x64 a few times today; I ...
0
votes
0answers
24 views
Will intellisense work if I use SQL Server Management Studio for Denali on older versions of SQL Server?
Will intellisense work if I use SQL Server Management Studio for Denali on older versions of SQL Server?
There are issues when you use 2008R2 SSMS on 2008 and earlier versions, where ...
1
vote
1answer
68 views
Remote connection to SQL Server 2008 in LAN
I try many ways, but still doesn't work.
MSSQLSERVER is running.
SQL Agent is running.
SQL Browser is running.
TCP/IP is enabled (something else inside it must I change?)
Named Pipes is enabled
...
2
votes
2answers
126 views
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 ...
0
votes
1answer
40 views
SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio
We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark ...
0
votes
1answer
31 views
Option do not show schema names in SQL Server Management Studio
I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you.
This works in ...
0
votes
1answer
58 views
how to Allow remote SQL connections from specific IP
i use ms sql 2005 server . guide me: how to Allow remote SQL connections from specific IP.
Thank all
2
votes
2answers
80 views
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 ...
1
vote
1answer
85 views
Removed SQLServerAgent account What should I do ?
I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be ...
0
votes
2answers
490 views
SQL Server 2008 Express: How do you remove a Database Engine instance?
I tried upgrading SQL Server Express 2008 to SP1, but the Setup was very far from clear. I ended up with 2 database engines.
I now want to install Management Studio Express, but it apparently means I ...
0
votes
1answer
104 views
SQL Server query result transfer time over VPN (WAN)
I have a mysterious phenomenon on a remote SQL Server 2005 which I manage and query using SQL Server Management Studio. I connect to the server through a VPN tunnel (provided by an ISP, about 8 MBit/s ...
0
votes
2answers
127 views
Can't connect to SQL Server in different domain using SSMS and Windows 7 Crendential Manager
I need to connect to a SQL Server 2008 instance in another Windows domain to manage it. We only use Windows Authentication.
In Windows XP, I could use the "Manage Network Passwords" feature to store ...
0
votes
2answers
44 views
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 ...
0
votes
1answer
128 views
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 ...
0
votes
1answer
47 views
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 ...
0
votes
1answer
117 views
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.
...
0
votes
1answer
40 views
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 ...
0
votes
0answers
94 views
how to add users to sqlserver 2008 managment studio
hello i am trying to install DotNetNuke CMS and i have created a database in my microsoft sql server managment studio 2008 which i have installed after installing microsoft visual studio 2010 , i have ...
0
votes
1answer
124 views
Trouble installing SQL Server Management Studio Express
Using VirtualBox I am running 64 bit versions of ...
Windows Server 2008 R2
SQL Server 2008 R2 Express
SharePoint Foundation
I want to install SQL Server Management Studio Express, but I get this ...
3
votes
1answer
76 views
SSMS: Where does SQL Server store its server names?
I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio:
Where ...
0
votes
1answer
63 views
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 ...
0
votes
2answers
99 views
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 ...
0
votes
1answer
428 views
Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio
I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
186 views
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 ...
1
vote
2answers
68 views
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 ...
0
votes
1answer
26 views
Adding a “RecordID” column to an existing table
A table has been created, but I realize I need a new column - RecordID (this column automatically assigns numerical value to each row of record) What would I have to do in SQL management studio to ...
0
votes
2answers
187 views
Set a login with username/password for SQL Server 2008 Express
I would like to set a password and username for connecting to a server with SQL Management Studio 2008.
I set up SQL Server 2008 Express on a customer's computer to host a DB used by an Access 2007 ...
1
vote
3answers
258 views
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 ...
0
votes
1answer
516 views
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 ...
0
votes
1answer
167 views
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 ...
1
vote
4answers
844 views
SQL Management Studio is painfully slow on 32-bit Windows 7
I've been having issues running anything in SQL Management Studio on Win 7. Basically, doing anything through the Management Studio interfaces completely freezes it up for a few minutes. Running a ...
1
vote
1answer
143 views
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 ...
1
vote
2answers
197 views
Database not visible in SQL Server Management Studio
A colleague was overwriting a test database with a production database by doing a restore in SSMS (SQL Server 2005). He realized he had set the restore path incorrectly and canceled the operation. ...
0
votes
1answer
105 views
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, ...
0
votes
0answers
166 views
SSMS 2008 IDE response is VERY slow
While coding in SSMS 2008, IDE response is very slow.
For example a) Intellisense either stops suggesting or takes too much time to suggest values (hangs for 5 secs everytime) and on selecting ...
0
votes
1answer
50 views
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?
0
votes
2answers
432 views
How do I update a table's schema with a new custom schema I have created?
I am using SQL Server 2008 Express and Sql Server Management Studio 2008.
I am trying to associate a database table with a new schema.
I have created a new Schema by navigating to Security->Schemas ...
0
votes
1answer
49 views
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 ...
1
vote
3answers
275 views
Sql Server management studio 2005 cant connect to localhost using windows authentication
I am trying to localhost using windows authentication with SQL Server management studio and I am getting a message that "Login failed for user..." (Error 18456).
I made sure that all the services are ...
0
votes
2answers
750 views
How to Add user to Sql Server Express 2008 without Management Studio
I had installed SQL Server 2008 R2 "SQL Server Database Engine" in virtual machine
and I want to connect to it over odbc from other computer (Linux).
I hadn't installed management studio as I wanted ...
0
votes
2answers
47 views
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 ...
0
votes
2answers
219 views
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 ...
2
votes
3answers
167 views
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
...
2
votes
1answer
69 views
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?
...
