Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
1
vote
0
answers
356
views
How to set up SQL User that can only do one thing (run stored procedure) and nothing else?
I would like to allow any user within a certain group of our domain access to login to one of our databases and run a specific Stored Procedure. This is the only action these users should be able to ...
1
vote
0
answers
24
views
Re-use An Import-Mapping of a CSV into SQL Azure DB using SSMS
In https://stackoverflow.com/questions/12503430/import-csv-into-sql-azure-database-using-ssms/35876305#35876305 one solution was to save the import dtsx so as to reuse. However, I cannot find how to "...
1
vote
0
answers
31
views
SSMS 2014 reporting service configuration ,Reporting Services – SharePoint integrated mode option is not working
I uninstalled SSMS 2014 due to some reason and when i went reinstalling it i am facing an issue that Reporting Services – SharePoint is not highlighted in feature selection and Reporting Services – ...
1
vote
0
answers
47
views
open SQL Server Management Studio from another machine
I have SQL Management studio installed on my VM and I use VDI to access VM. the only reason i login into VM to access the SSMS. Is there is any way i can open the SSMS from VDI without login in to VM? ...
1
vote
0
answers
810
views
Can't connect to database in SSMS 2017
I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all.
OS: Windows 10 Home
TITLE: Connect to Server
...
1
vote
1
answer
173
views
SSMS 2016 fails to save settings
By default, SQL Server 2016 is configured to store data and logs in
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA
and backups in
C:\Program Files\Microsoft SQL Server\MSSQL13....
1
vote
0
answers
957
views
Can't associate SSMS 2016 to .sql Files
I recently installed SSMS 2016 on my windows 7 machine. When I view a directory of .sql files, I notice that they all have a text file icon image for them and the file type is simply "SQL File". ...
1
vote
0
answers
152
views
SSMS2012 Help going to Chrome rather than MSIE
Running Win7 Ent 64bit
From within SSMS 2012 SP2, when I hit F1 (or Help, View Help), I am taken to Google Chrome rather than MSIE11. By every indication I can find, MSIE11 is my default browser, not ...
1
vote
0
answers
782
views
SSMS and SSDT requires administrator
I connect to a client's Server (Server 2012R2) via RDP.
I always get the UAC prompt when I start the SQL tools, managemant studio (SSMS) and data tools (SSDT). If I press cancel in the UAC dialog the ...
1
vote
0
answers
620
views
Changing font color in SSMS for different database elements?
I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
1
vote
1
answer
1k
views
Can't open SSMS - stating I don't have permissions
Whenever I try and run SSMS I get the following error.
'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. '
The dialog box ...
1
vote
1
answer
89
views
Is there any way to Start SSMS connected to registered server
Is there any way to start SQL Server Management Studio to connect to a registered server?
I have managed to get it to start from the command line connecting to the desired DB with the use of the -S -...
1
vote
1
answer
61
views
Default text for SQL scripts
In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text?
I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
1
vote
1
answer
1k
views
SQL server replication, subscription to remote server : issue while choosing the publisher
I am trying to create a subscription to a remote server having SQL 2008 R2
the client PC is connected through VPN to the server and can discover it successfully.
I can even connect to the database ...
1
vote
1
answer
246
views
Reassign F11 in SSMS
Reassign function keys in ssms? Anyone know how?
When I'm stepping through code I keep hitting F11 in SSMS on accident. Then have to cancel too many dialog boxes. I want to change F10-F12 to just run ...