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

SQL Server Remote Query TCP Error

We are in the process of moving to a new hosting provider and after setting up a very simple database in SQL Server 2005, I noticed that if I wait more than 10 seconds or so between running queries remotely using management studio, I get the…
Adam
  • 113
  • 3
0
votes
1 answer

Automatic deletion of backups and transaction logs leaves broken backup points

TLDR: default log shipping job and maintenance plan are deleting old files from disk but backups are still displayed in SSMS making it very slow to display "Restore" window. How to delete old .trn/.bak correctly? (Azure virtual machine, Windows…
PTwr
  • 123
  • 5
0
votes
1 answer

Requirements to set up "Run as different user" for SQL Server 2016

Our organization has two types of accounts for server administrators. Both are individual user accounts in Active Directory tied to a given employee. However, they only give system (server and database) access using our admin-{user id} account. …
JustBeingHelpful
  • 1,964
  • 7
  • 37
  • 53
0
votes
1 answer

How to run maintenance plan task on success of two other tasks

I need to run the maintenance plan task on success of two other tasks and only after those tasks have completed. At the moment task2 starts straight away after one of the other two completes and it's not waiting for them both to finish. enter image…
attention
  • 1
0
votes
1 answer

Interpreting a Deadlock Log / XDL file

I've generated the following XML + XDL:
SB2055
  • 33
  • 5
0
votes
1 answer

How to Set (and get as well) Minimum server Memory and Maximum server Memory of a SQL Server Instance using T-SQL Query

I want to set Minimum and Maximum server Memory for a SQL Server using T-SQL. I am able to do it using SSMS->Object Explorer->Server Properties but don't know how to do it using T-SQL commands. Along with this, also can anyone help me out with how…
Jitendra
  • 1
0
votes
1 answer

Are there ramifications of running SQL Server 2008 Developer and SQL Server 2008 Express side-by-side?

I'm running SQL Server 2008 Developer and after reading https://stackoverflow.com/questions/293281/why-wont-visual-studio-2008-create-mdf-files-with-sql-server-2008-developer-ins I want to install SQL Server 2008 Express along side it. I know from…
Matthew
  • 529
  • 2
  • 6
  • 14
0
votes
1 answer

How can I export a database to Azure in SQL Server Mgmt Studio 2008?

I'm trying to export a database to Azure using the most recent version of SSMS 2008, and I'm having trouble because I don't have the options listed under "Tasks" that the tutorials I've found indicate that I should select. This is what I'm supposed…
666adminpal
  • 1
0
votes
1 answer

Can a sql job using a DTS package access data from the wrong column? (turned out to be bad join condition)

We are seeing a Sql job / DTS package fail because it is fed non-numeric character data into an int conversion routine. The data looks like with very high probability that it comes from another column in our tables, where its non-numeric format is…
JosephDoggie
  • 229
  • 2
  • 4
  • 14
0
votes
1 answer

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other instance as well... What I am trying to do is have 2…
DangeRuss
  • 217
  • 4
  • 10
0
votes
1 answer

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system user privileges in report manager. I am also part of…
mamontyonok
  • 1
  • 1
0
votes
0 answers

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, then SQL Server respond I have invalid credential. -…
elty123
  • 101
  • 2
0
votes
2 answers

Looking for SSMS 2008 Express Only

I downloaded SQL Server 2008 Express from here..... But it still did not install the SQL Server Management Studio that I need to connect to my databases.....see image below....looking for this. Where can I find the express SSMS that will work on…
Etienne
  • 273
  • 5
  • 16
0
votes
2 answers

SQL Management Studio on Windows 7 64Bit

We're scratching our heads a bit here. We have SQL Server 2000 on our internal systems and I have a new machine. My old windows XP machine had Mgmt Studio (full version). I have tried to run the SQL 2000 installation disks, but they are not 64 bit…
Matt Facer
  • 111
  • 1
  • 4
0
votes
0 answers

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the Object Browser for one database, he can't view them…
CJM
  • 730
  • 3
  • 12
  • 28
1 2 3
…
12 13