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 ...

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 ...

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, ...

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 ...

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.
...

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 ...

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, ...

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 ...

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 ...

We have new versions of .net applications deployed every week for testing given in form of new build files. Can any one suggest how I can maintain many versions of the builds without having to keep ...

My understanding is that, in a MS SQL Server Management Studio window, after doing a "begin transaction" and then making some changes like add data to a table , you can only query that table and those ...

I want to export a varbinary column to a file system. I can use BCP command to export data from a varbinary column, which requires username and password being sent along with BCP command. I can use ...

I recently installed SQL Server 2012. Due to some issue, the databases services did not install successfully, but Management Studio did, which was OK to start with, as I usually access remote servers.
...

I was attempting to remove a column from a table within SQL Server 2012 for one of our developers. As a precaution, before dropping the column, we rename them to make sure that everything continues ...

I have SQL Server 2008 R2 64bit installed with SQL Server Management Studio (SSMS). I've been using SSMS for log time but recently when I try to open SSMS, I get the above error. I've tried all the ...

I have a data warehouse with a lot of views built in with the SSMS view designer.
Viewing the syntax, the FROM clauses are unintelligible to me because the ON statements do not follow straight after ...

I'm working with some tables/columns that were renamed at some point, but the names of the primary/foreign keys are still based on the previous names.
In SSMS is there any (preferably automatic) way ...