Skip to main content

New answers tagged

0 votes

SQL Server Management Studio "Key cannot be null" error when giving a specific user permissions on Stored Procedures

The problem was that the stored procedures had Writes written into them, and the user was a Read Only account. This error doesn't really point to that, but make sure the user has permissions to ...
LYNITS's user avatar
  • 1
1 vote
Accepted

.DTSX package is there a way to wrap a workflow into a transaction

You can read about SSIS transactions here. Configure a package to use a single transaction In this option, the package itself initiates a single transaction. You configure the package to initiate ...
David Browne - Microsoft's user avatar
1 vote

import extended properties of sql server database from xls file

The TSQL script way of adding an Extended property is via sp_addextendedproperty Slightly altered example from the documentation: USE AdventureWorks2022; GO EXEC sp_addextendedproperty @name = N'...
Zikato's user avatar
  • 5,102
0 votes

Connection string for a successful SSMS connection

SSMS (SQL Server Management Studio) does not directly reveal the exact connection string it uses in its UI. However, you can recreate the connection string by first following these steps to ensure ...
Severalnines's user avatar
0 votes

Management Studio all buttons disabled

Select and highlight your Query Then RightClick and select [ Execute ] It runs your query, and brings the Execute button back to life.
TaoRich's user avatar
  • 101
1 vote
Accepted

Microsoft SQL Server Import Export Wizard on Remote SQL Server

The code executes on the machine where you run the wizard. So, no, the GUI will not allow, by itself, a "remote execution". There are other ways to go about this. Being on the same server, I ...
Tibor Karaszi's user avatar
2 votes

How to modify filepath of a database file that is inside a file group

Both options are incorrect. For the first option newfilepath do not exists. Use FILENAME instead From Move User Databases (Microsoft Learn | SQL) ALTER DATABASE mydatabase_name MODIFY FILE ( ...
SergeyA's user avatar
  • 831
-1 votes

Enable Toolbox window in SQL Server Management Studio

You may also use Win+V to see your last 20 entries in the clipboard for a comfortable Library of your latest code. Just paste it by clicking on the desired snipped.
Walter Küchenberg's user avatar

Top 50 recent answers are included