Javascript Keycode
KeyCode KeyCode Value 13 Return or Enter key on keyboard
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
Drop and Recreate Foreign Key Constraint
Getting foreign key constraint error when trying to repopulate a table…
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