|
- 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
- How can I fix Login failed for user sa error in SQL Server?
8 I can access my databases through SQL Server Management Studio (SSMS) by using my Windows account no problem I have two issues though: I want to enable sa and then try to log in using sa and the password I get this error: I enabled the SQL Server authentication: I tried to create a new user, but that user cannot connect either: How can I
- How to connect to a local SQL Server instance by IP Address in SQL . . .
I have the SQL Server instance up and running on my machine, but can't figure out the correct IP + Port to use for my connection string's Server property As a starting point, I'm trying to at least manually connect to my server instance with SQL Server Management Studio (via the IP address) but I can't seem to figure it out
- Could not find the Server Agent in SSMS
In SSMS connect to the server you want to trace on Go to your SQL Server Agent and expand it so you can see the Jobs folder Right-click the Jobs folder and select New Job I cannot not find SQL Server Agent Where can I make this SQL Server Agent visible? I have given the current user all the access permission
- SQL Server Management Studio (SSMS) is way too slow in its GUI
Try setting the RAM manually in MS SQL Server Management Studio -> Right Click the SQL Server in Object Explorer -> Properties -> Memory I set my min memory to 1000 MB and the max to 2000 MB and saw an immediate improvement (The max by default was set to something silly like 2147483647 MB Isn't that over 2 million Gig!!!!!)
- sql server - How to add the Debug button to SSMS v18? - Database . . .
The Debug button is present on this version of SSMS: But it is not present on version 18, preview 4: I have tried in several ways to add the Debug button to my SSMS but not successful Is there a
- sql server - Changing sa password - Database Administrators Stack Exchange
29 I'm trying to change the password of the sa account using SQL Server Management Studio 2012 I've followed the steps below but the password is still the same Login into the SQL Server Management Studio, Select Database Engine, \SBSmonitoring, Windows Authentication Go to Object Explorer--Security folder--Logins folder
- 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
|
|
|