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 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
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
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
Getting foreign key constraint error when trying to repopulate a table…
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).
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
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
Error: Could not write lines to file FileListAbsolute.txt. Access to the path is denied. Possible Cause: Have you checked in the “obj” and “bin” folders? To resolve this issue: Delete the “obj” and “bin” folder in source control.(usually those are not checked in) Delete the “obj” and “bin” folders on your hard disk.(they will be... » read more
Error: Data-driven subscription cannot be created because the report or shared dataset has user profile dependencies and cannot be run unattended. Fix: When we tried to setup data driven subscriptions we kept getting error: report or shared dataset has user profile dependencies and cannot be run unattended. SSRS data driven subscription do not work if... » read more