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
1
vote
1 answer

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 up and down). When I open a new query window…
splattne
  • 28,508
  • 20
  • 98
  • 148
1
vote
2 answers

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 on my local machine my username and password for…
BrianFinkel
  • 121
  • 1
  • 5
1
vote
0 answers

How to create an SSIS package with a Script Component

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS. I want to take data from a Source database elaborate them and put in a Destination database. In the…
CiccioMiami
  • 209
  • 1
  • 3
  • 14
1
vote
1 answer

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 warning: "This program has known compatibility…
mmcglynn
  • 355
  • 2
  • 4
  • 14
1
vote
2 answers

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 load. I'm using Windows 7 Professional SP1 32 bits.…
Yaz
  • 11
  • 1
  • 2
1
vote
2 answers

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 app. The customer should not be able to access the…
Atomic Star
  • 111
  • 1
  • 1
  • 3
1
vote
5 answers

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 query is nearly impossible because it takes nearly 2…
Sergei
  • 131
  • 1
  • 7
1
vote
2 answers

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. At this point the database disappeared from SSMS. …
Doug
  • 11
  • 1
  • 2
1
vote
2 answers

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 in object explorer. I right clicked on the folder…
Lewray
  • 143
  • 1
  • 1
  • 6
1
vote
3 answers

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 started, and I enabled the named pipe, TCP/IP…
Derek
  • 191
  • 1
  • 7
1
vote
2 answers

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 minimal possible installation (it is mostly for…
Artyom
  • 754
  • 2
  • 7
  • 16
1
vote
1 answer

How do I see processes from all users in SSMS2008?

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?
CodeRedick
  • 277
  • 1
  • 4
  • 7
1
vote
2 answers

How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2008R2?

I'm having difficulties to setup a daily backup schedule in SSMS 2008 R2 Developer Edition. This is exactly what I'm trying to achieve: My SSMS connect to my DB (remotely), which located at some hosting service. I'm looking for some script (or other…
Matan Eldan
  • 113
  • 5
1
vote
1 answer

Hourglass won't go away in SQL Server 2008 R2 Management Studio

... after I add a column to a table. I've just started using 2008 R2 Management Studio, but I have a few years experience with 2005 Management Studio. Also, I am connecting to a 2005 instance of a database on a remote server. right-click on a…
JohnB
  • 497
  • 2
  • 6
  • 12
1
vote
1 answer

"Classic" activity monitor in SQL Server Management Studio 2008?

Right now I'm using SQL Server Management Studio 2005 to manage all my SQL servers (2000, 2005, 2008). I'd love to be able to take advantage of all the cool new features in SSMS 2008, the only thing holding me back is the new DMV-based activity…
BradC
  • 2,220
  • 4
  • 27
  • 36
1 2 3
…
12 13