New answers tagged ssms
Install the 2010 Color Theme Editor in VS 2010. Find the files somehwere in “C:\Users\xxxxx\AppData\Local\Microsoft\VisualStudio\xx.x\Extensions\” .. for me, it was in “\shvn3avp.com” for the current version of the plugin. Copy those files to a new folder: “C:\Program Files (x86)\Microsoft SQL Server\xxx\Tools\Binn\ManagementStudio\Extensions\VSTheme” ...
The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc. If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them ...
In SSMS, right-click on the database and go to "Reports", "Standard Reports", "Disk Usage by Table". It will tell you the total size, the data size, the index size, and the unused size for each table (as well as the row count).
It's been answered on Stack Overflow: SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = ...
Ok. I discovered that the source of this problem is a Server upgrade where the server name was changed and thus the outbound SQL instance name changed.The maintenance plans are stored in the msdb system database and this is where they may be edited. So after some online search, I found this SP (which I have modified): USE msdb go BEGIN TRY DECLARE ...
You could try shutting down all instances of SSMS and deleting the file SqlStudio.bin, which works for clearing out things like the MRU list for server connections. Just note that this will also wipe out other preferences, so you may want to export certain settings (like if you've customized fonts and colors, startup options, etc). Also, why is SSMS RTM? ...
It is not possible to share a local temporary table between connections. Local temporary tables are scoped to a single session, but global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server. Global temporary tables have ...
Uninstall the Visual Studio 2010 Shell, this was done by downloading the installer. Once downloaded, run the installer and remove the VS2010 Shell component. Once done, run the SQL 2014 Management Studio installer or do a repair on your existing installation, this will itself reinstall the VS2010 Shell components. Then it opened for me.
I would say you need to use file URIs: For example: You can use UNC paths in a file uri if you convert the \ to / like this:
Normally when you want to restore a database from a different server, you're looking to create a device backup to a network drive, and restore from that. The way the restore from database interface works is by querying the msdb database for recent backups, to see what you can restore. Accordingly you should be using a device backup: If the backup is ...
You can use this link to download latest SSMS separately. At the time of writing, this is SQL Server Management Studio July 2015 preview.
Are you a member of db_owner? See this: To use Database Diagram Designer, it must first be set up by a member of the db_owner role to control access to diagrams (https://msdn.microsoft.com/en-us/library/ms189279%28v=SQL.100%29.aspx)
One more very simple solution: use notepad++. Inside there is very good plugin called Poor man's sql formatter. The drawback is that you have to paste SQL inside the notepad++. But it is free. There is also a web page, but I did not try it.
Top 50 recent answers are included