Author

Download SSIS Packages From Server

Extract ISPAC file SSMS -> Integration Services Catalogs -> SSISDB -> MyProject01 -> right click and click on “Export” XXXX.ispac file will be generated. Rename the .ISPAC file to .ZIP, after that you can to extract all files from that zipfile. Sources: http://microsoft-ssis.blogspot.com/2016/04/get-packages-from-ssis-catalog.html

SQL Server Agent – Operators Multiple Email

When a job fails, you have set to have it alert an operator. For the operator setting, you can add multiple email address to the “E-mail name” field separated by semicolon. E-mail name: Edit via script… Note: There is a 100 character limit. It is set in the sysoperators table. DO NOT try to ALTER... » read more

Add a User to Local Administrator Group

Add user to local administrator group via computer management Step 1: Press Win +X to open Computer Management Step 2: In the console tree, click Groups.Computer Management\System Tools\Local Users and Groups\Groups Step 3: Right-click the group to which you want to add a member, click Add to Group, and then click Add. Step 4: In the Select Users (Computers, or Groups) dialog box, do the following: To add a... » read more

Allow Access to Use Remote Desktop Connection

Note: You can also add the user to the local Administrators group. This will give them remote desktop access. Allow Access to Use Remote Desktop Connection Before Remote Desktop can be used, permission has to be granted to the specific accounts that you would like to Allow to connect to your computer remotely.  This is typically... » read more

ANSI_WARNINGS Error

Error: Getting the following error when running a stored procedure… SELECT INTO failed because the following SET options have incorrect settings: ‘ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML Fix: Sources: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/95752aba-2c39-4aca-be2b-a2ee9e3d70da/select-into-failed-because-the-following-set-options-have-incorrect-settings-ansiwarnings?forum=sqldataaccess https://docs.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver15

UNION vs UNION ALL

UNION The UNION command combines the result set of two or more SELECT statements (only distinct values). UNION ALL The UNION ALL command combines the result set of two or more SELECT statements (allows duplicate values).

Visual Studio Team Explorer with Git Integration

Commit Options Add a console application to the solution using Solution Explorer. Write some code and you will see there are three options to commit… Commit All (only to local repo), Commit All and Push (local as well as remote repo) Commit All and Sync (to remote and also fetches changes from remote if any).... » read more

Update Stored Procedure in Entity Framework

Go to Model browser. MyStoreProc is the name of the stored procedure (as an example). MyStoreProc will appear in 3 places. 1st place- Under Complex Types -> as MyStoreProc_result 2nd Place- Under Function Imports -> as MyStoreProc 3rd Place – Under Stored Procedures/Functions -> as MyStoreProc Delete all three from model. Save the edmx (by... » read more