New answers tagged

2 votes
Accepted

Does SSMS support stored procedure parameter name completion?

I don't think you can. SSMS Intellisense is pretty basic, so many people use 3rd party solutions to get around that. But you can open the Object Explorer and find the Procedure in the Database\...
  • 2,350
2 votes

Can I install SQL Server Management Studio offline without internet access and create databases locally on my pc?

SQL Server Management Studio (SSMS) is not a Relational DataBase Management System (RDBMS), it is only the tool to access an existing RDBMS. You have to have an RDBMS installed in order to be able to ...
  • 15.5k
1 vote
Accepted

Microsoft SQL Server 2019 Developer Edition suddenly throwing Internal Connection Fatal Errors

Encountered the same issue but it is gone since I uninstalled windows update KB5011048
  • 126
6 votes
Accepted

How to get the columns of table in one row?

It's surprisingly difficult to do what you want completely generically in T-SQL, but this works for the example: DECLARE @Query nvarchar(max), @ExtraRow nvarchar(max); SET @Query = N'SELECT *...
  • 73.8k
1 vote

Does tail log backup option during restore (UI) truncate the tlog? And is there any way (UI option) to prevent truncation?

No, that option in the GUI doesn't truncate the log. See script at the end for proof. The GUI is a bit strange in the sense that it adds two options to the BACKUP command when you do that selection. ...
1 vote

Does tail log backup option during restore (UI) truncate the tlog? And is there any way (UI option) to prevent truncation?

Yes, any transaction log backup, which a "tail" one still is, truncates the transaction log up to the beginning of the active portion of the transaction log and discards the information in ...
  • 463
1 vote

How to grant permissions for a user to view but not execute a SQL Server stored procedure?

After doing a screen share with the user, it was evident that the code below indeed works to grant permissions for a user to view but not execute a stored procedure. It was a case of receiving ...
  • 499
1 vote

How to grant permissions for a user to view but not execute a SQL Server stored procedure?

i suppose you have to deny select to him DENY SELECT ON OBJECT::schema.MyProc TO SomeUser; GO
  • 3,715

Top 50 recent answers are included