SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

learn more… | top users | synonyms (2)

0
votes
0answers
25 views

SQL Server Windows authentication: VMs versus others

This really seems like a weird one to me. I have two VMs of interest, one is running Win2k8 R2 x64 and the other is running Windows 7 X64. The server is hosting SQL Server 2k8 while the latter has SQL ...
0
votes
0answers
20 views

SSMS 2012 UDF Colours [migrated]

I want to know if its possible to change the colour of a User Defined Function in SSMS 2012. It Currently looks like this: So the function blends in with all the other fields, whereas the built in ...
2
votes
1answer
60 views

How to script a table? [duplicate]

When I right-click a table in Object Explorer and click "Script Table" I can get SSMS to script my table. Can I do that with T-SQL code? I'm after the "CREATE TABLE xx" code that SSMS generates, so ...
2
votes
1answer
29 views

Querying MySQL and SQL Server from same IDE

I am currently working with MySQL and SQL Server. For querying MySQL I use MySQL Workbench, for SQL Server I use SQL Server Management Studio. I am mixing up shortcuts all the time. For instance, ...
1
vote
1answer
36 views

SSMS down arrow on last line

I apologize if this is not the correct place to ask this but something is bugging me. I could have swore that at a previous job I could be on the last line of code in SSMS and hit the down arrow and ...
3
votes
1answer
118 views

Get IO stats request sql like activity monitor

Is it possible to get the same value as in the activity monitor (SSMS) for the "Database IO" as a result of a SQL request? click to enlarge
-1
votes
1answer
28 views

Trying to add permission to a Role is failing

I am trying to add a role into Create and Restore permissions and After researching online, it sounds like it should be as easy as using the GRANT statement. So far so good. However, my simple grant ...
0
votes
1answer
21 views

Setting Key Constraints using a Diagram

I been using SSMS for diagramming my databases and I got used to create the key constraints with this tool. Now I started thinking, while going through related chapter of a book, "...maybe this is not ...
6
votes
1answer
78 views

SSMS Registered Servers with ReadOnly Application Intent

We are working on SQL Server 2014 POC testing with AlwaysOn and one of the user asked about saving the configuration of SSMS with ReadOnly Intent using the registered servers in Local server group. ...
1
vote
1answer
19 views

Formatting SQL Source Code in SSMS [closed]

There are several source code formatters for SQL in SSMS. I have tried a couple and found that are not configurable in terms of what formatting they do (e.g. indenting). Does anyone know of one ...
0
votes
1answer
23 views

Differential Backup since a date

Hi is it possible to do a differential backup in ssms 2014, so that it gets all changes since a specified date?
1
vote
1answer
77 views

SSMS Database Node Refresh causes Restore to Fail

I have confirmed via testing that clicking on the refresh icon (one or more times) for the database node of a SQL Server instance being observed in SQL Server Management Studio (SSMS 2012) causes my ...
0
votes
1answer
20 views

SQL queries failing, Memory not releasing

I have a SQL Server 2008 R2 with 8GB of ram and SQL Server is limited to 6GB. It seems to not be releasing the memory its used, and at some point future queries begin to fail. This is a mirrored ...
0
votes
0answers
49 views

can not login to SQL Management studio using “SQL Server Authentication”

i am able to login to sql management studio 2008 r2 using "windows authentication", but if i chnage the Authentication type to be "Sql server Authentication" instead of "windows authentication", i ...
0
votes
0answers
15 views

Debugging value of varchar set to empty string crashes SSMS?

DECLARE @test varchar(1) = ''; SELECT @test When debugging, hovering over @test displays a little {...} token, and clicking the magnifying glass to open the text visualizer causes an application ...
2
votes
1answer
30 views

Linking SQL Server tables to a PostgreSQL Server

I have a SQL Server 2005 instance and also a PostgreSQL 9.3 running on the same network, I would like to know if its possible to somehow create or have 'views' on a database within the PostgreSQL ...
1
vote
1answer
27 views

Registered Server window does not show Database Engine or Local Server Groups

I am running SQL Server Management Studio 2012 on a Windows 7 machine. After a failed attempt to import my registred servers from SSMS 2008, the icons for Database Engine and Local Server Groups are ...
0
votes
1answer
31 views

What is the most efficient way to concat strings in declared table

I have this code: DECLARE @MyTableAS TABLE ( [Month] INT, Salary INT ); INSERT INTO @MyTable VALUES (1,2000), (1,3100); SELECT [Month], Salary FROM @MyTable; Output: I want to concat the ...
1
vote
3answers
76 views

Excluding particular words from a string on a WHERE clause

I have a table that stores invoices and I'm trying to get stats out of it, unfortunately the table is poorly build and some crucial information is all mixed up on a nvarchar field, information such as ...
0
votes
1answer
54 views

SSMS: Limit a login to be able to view and work only with some databases, but not able to make any changes on the server level

On a shared cloud we would like to work with one instance of MS SQL Server. Different clients have various databases. They can be owner of their databases and with DENY VIEW ANY DATABASE TO PUBLIC in ...
0
votes
1answer
48 views

How to query a server linked via ODBC

I've looked at multiple other questions about querying linked servers, but nothing has worked for my setup. Notes: I'm not using localdb at all. I just wanted to use SQLSMS for a remote cache ...
-1
votes
2answers
44 views

Cannot connect in SSMS with Windows Authentication

I found and added the server name through <Browse for more...> -> Network Servers so it exists and is correct. What seems weird is that the Password field is empty and I cannot modify ...
1
vote
1answer
42 views

SSMS returns results immediately; ADO takes longer

I am running a query that returns ~250k results. It is basically SELECT * FROM my_schema.my_view (and the view is somewhat complex, and all table references in it are two-part) I am not passing any ...
5
votes
1answer
480 views

What is this upside-down silver key icon

I inherited a SQL Server 2005 3rd party server and database to look into to be able to generate reports and dashboards on. On one table, I found a new icon: a blue-silver upside-down key, alongside ...
1
vote
1answer
68 views

Can I import a specific vssettings file when launching SSMS?

In the interest of disambiguating between when I am connecting to non-production and production, I utilize vssettings for a specific theme in Management Studio (fire-and-brimstone style when in prod, ...
0
votes
3answers
128 views

SSMS 2014 working with SQL Server 2005 instances

Is there any major complication that one could run into while using the latest (developer) version of SSMS with older SQL Server 2005 instances? Any way one could affect the data by using this ...
1
vote
0answers
30 views

How do I change the default “File Name” value in SQL Server's Generate Scripts wizard?

I'm on SQL Server 2012. The "Generate and Publish Scripts" wizard seems to remember the first path I gave it in the Set Scripting Options → Save to File → File Name box, but will under no ...
-3
votes
1answer
103 views

Unable to attach mdf file on SQL Server 2014

I have SQL Server 2014 on my Windows 8.1 Pro machine. However, I couldn't find any sample database for 2014 version and hence I am trying to attach AdventureWorks2012_Data.mdf file by right clicking ...
2
votes
2answers
38 views

How do I add keyboard shortcuts in SSMS 2012 to run a specific query?

How do I add keyboard shortcuts in SSMS 2012 to select all the data from table? In SSMS 2008 we could assign a shortcut in the following way: ...
1
vote
0answers
54 views

SQL Server Management Studio with Multi subnet HADR cluster

We are starting to deploy Multi-Subnet HADR AlwaysOn clusters for our environment. Using MultiSubnetFailover=True in application connection strings works. However, SSMS connections require manual ...
1
vote
1answer
1k views

SSMS 2014 “Deploy Database” feature has old SQL Azure settings

I'm attempting to test-deploy an existing SQL Server 2005 database into SQL Azure using the "Deploy Database to Windows Azure SQL Database" task in SQL Server Management Studio 2014. When the ...
1
vote
1answer
59 views

Unable to ping/connect to azure sql server from sql server management studio

I created a database in azure and assigned a new server to it. I entered my ip address in the firewall and tried to connect to the server in Sql Server Management Studio but no success. I tried to ...
1
vote
1answer
49 views

my azure sql database is not connecting with SSMS 2014

The firewall contain my IP in valid list but I am still getting error in connection. I tried the command C:\Users\MianAsbat>SQLCMD -U username -P password -S and got the following response. I ...
0
votes
1answer
58 views

SQL Server Express 2014 Installation directory

I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked to select the installation folder of SQL Server. ...
0
votes
1answer
57 views

How do I configure SQL Server Management Studio Intelisense to ignore case

The way we have our db configured, case does not matter, but in the query editor intelisense is using case much to my frustration. I like that autocomplete feature of intelisense but I have had to ...
5
votes
2answers
177 views

How do I get SSMS to use the relative path of the current script with :r in sqlcmd mode like SSDT does?

If I have foo.sql and bar.sql in the same folder, foo.sql can reference bar.sql when run from SSDT in sqlcmd mode with :r ".\bar.sql". However, SSMS won't find it. Procmon shows SSMS is looking in ...
0
votes
1answer
80 views

SQL Server 2014 and SQL Server 2014 Management Studio

I successfully installed SQL Server 2014, but when I look for SQL Server Management Studio it was not on the CD. I have just downloaded SQL Server 2014 Management Studio separately and would like to ...
-1
votes
1answer
224 views

use variable as column name in where clause in sql

I want to use a variable as column name in my SQL query. Problem: I can not use dynamic SQL as the SQL query that I have is inside of a user defined inline table function. What are other possible ...
0
votes
0answers
34 views

Can I implement Intellisense into my stored procedure with custom constants?

I created a stored proc to do some cleanup on some orphaned temp tables by issuing a DROP. However, I want to vary the time threshold so I have a stored procedure that accepts a time unit (e.g. hours, ...
0
votes
0answers
12 views

View all tables referenced by foreign keys in SSMS [duplicate]

I have a database with a lot of tables, the tables have a lot of foreign keys. Is there an easy way to view the other tables being referenced by the foreign key in a given table? I tried "view ...
0
votes
1answer
27 views

Update statement with a function

I'm just curious. I was trying to optimize an update statement with a function Ex update circle set area = fnGetArea(radius) where ...<bunch of conditions> This update went 5-10mins and when ...
0
votes
1answer
124 views

Export SQL Agent jobs with steps and scripts

I recently saw some kind of export of SQL jobs configured under SQL Server Agent that I would like to achieve as well. Unfortunately I don't have any trace to author of that report to ask him\her ...
0
votes
2answers
64 views

Quickly clone a database in SQL Server Management Studio

For testing purposes, I often have to clone databases (onto the same server). Currently I do this by creating a backup and restoring it as a new database. I would love to have such a functionality ...
0
votes
0answers
65 views

SSMS IntelliSense doesn't work on particular database

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center, so far I found one database (database A) doesn't have IntelliSense working, e.g. typing: SELECT ...
-1
votes
2answers
61 views

SQL Server Temp Database Monitor Tools [closed]

Please suggest best tool to monitor temp db activity to find the objects which have excessive temp db usage.
0
votes
1answer
52 views

Update a set of SQL statements

dbo.MatchFirstName(@FirstName) and dbo.MatchLastName(@LastName) are table Value Functions(TVFs). Problem: In my Update statement i.e Update #Temp after Insert, I want only those rows to be ...
1
vote
2answers
34 views

SSMS (2012) limit # of characters on editor window line

Is there a way to enforce a hard limit on the number of characters allowed on a line in the SSMS editor window? I have searched, but am unable to find an option to set this. I'd like to force the ...
1
vote
0answers
63 views

SSMS login fail to Linked Server

i have one server with SQL server 2012 standard on cloud environment and one linked server with sql express on remote location connected with VPN , im using transactional replication every time when ...
0
votes
1answer
46 views

SSMS 2008 R2 no longer connects to database [closed]

Before Christmas I had no problem connecting SSMS 2008 R2 to a specific remote database. Since Christmas, I get this error when I try to connect: TITLE: Connect to Server Cannot connect to ...
0
votes
2answers
198 views

Can't restore database?

Im trying to restore, let's say, db1. But some of my colleagues are using db2. We're in the same sql server. Why can't I restore my db1.bak even if Im the only one who's using it...? I tried "Take ...