|
- Is there a way to see the code that creates a view in SQL server . . .
I want to see the underlying code for how a view is created in SQL server management studio Is there a way to do this? I want to see any date filters, etc, applied to this view in hard code
- SSMS error - Database Administrators Stack Exchange
I believe this happens when your SSL certificate for the SQL Server machine is not setup properly You should be able to workaround it by checking off the "Trust server connection" property for the SSMS connection (This only affects your specific connection with SSMS ) Whoever manages the SSL certs should ultimately fix whatever the root issue is, which these Microsoft docs might help with
- sql server - IntelliSense not working but it is enabled - Database . . .
This problem is really proving to be a tricky one (and quite annoying) In SQL Server Management Studio 2008, up until a few days ago my IntelliSense was working great Then all of a sudden it st
- SQL Server Management Studio 2012 separated toolbars
In SQL Server Management Studio 2012, is there a way to get the toolbars separated, so there is space between them? I can do this with 2008 R2 by just dragging the toolbar handle But in 2012, I ca
- sql server - Formatting T-SQL in SSMS 2012 - Database Administrators . . .
Nothing that indicates there is any knowledge of the actual language, so it wouldn't know where to insert line breaks or add additional indents or assist with parentheses etc If you want language-specific formatting to make existing T-SQL code more readable, you won't get much from SSMS, and you'll need to seek other options
- ssms - Remote Desktop SQL Server Management Studio Dialog boxes Font . . .
1 When I connect from my local machine to a remote server through Remote Desktop Connection And then try to use SQL Server Management Studio, the Dialog boxes in the application for example Connection dialog screen shown on launch, Server Properties etc are very small, so small that the text on these dialog boxes is not readable at all
- sql server - Management Studio System. OutOfMemoryException - Database . . .
Even if you installed 64 bit SQL Server, the SQL Server Management Studio executable is a 32 bit application This is likely caused by the size of the result set that you are returning to Management Studio
- SQL Server error Missing family sequence number 2
RESTORE Get into SQL Server Management Studio (SSMS), connect to the server, and expand Databases Right-click on the original database, and choose Tasks -> Backup A dialog window will open On the first page of the dialog: Make sure the database you want to back up is selected as the Source database Make sure the Backup Type is "Full"
|
|
|