The mssql-ssms tag has no wiki summary.
0
votes
1answer
91 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
20 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
18 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
52 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
67 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
19 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
18 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
0answers
65 views
Database Diagrams no longer work in SQL Server Managment Studio 2008 R2 SP1
When I go to open or create a new Database digram on a new or existing database I get the error.
The specified module could not be found.
(Diagram Surface)
I have searched endlessly on Google ...
0
votes
1answer
31 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
47 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
74 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
141 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
84 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
79 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
38 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
105 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
37 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
84 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
38 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
77 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
94 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
63 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
37 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
77 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
287 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
144 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
52 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
23 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
155 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
178 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
364 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
138 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
736 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
119 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
177 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
82 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
142 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
45 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
308 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
44 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
226 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
698 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
45 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
191 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
152 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
56 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?
...
0
votes
2answers
85 views
Migration From SQL Server 2008 Express to SQL Server Web
I have SQL Server Management Studio (for SQL Server Express R2) on my pc, and I'd like to export a few databases for use by a website that's running on a server with SQL Server Web. However, when I ...
0
votes
1answer
23 views
Cannot delete SQL Server project file?
I have a .ssmssqlproj file in a Sharepoint folder, but I cannot delete it. It says that some application may currently use it. That is not true, because I don't have SSMS open. How to delete this SQL ...
0
votes
1answer
300 views
How to change schedule of backup jobs using SQL Management Studio
I have an SQL Server 2005 on our lab network, I installed MS SQL Management studio on separate computer to connect to the SQL Server to schedule a backup job of a few database. It worked fine for the ...
0
votes
2answers
1k views
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 ...
