You moved the database to another instance and created a new login for this database instead of moving the login from the old instance to the new instance. I recommend that you read my article “How To Move Logins To Another Instance(sp_help_revlogin)”. You may receive this error when you want to authorize the login that you created for the database… Leer más »
In SQL Server, you should use JOBS to run a stored procedure based on schedule. Open SQL Server Management Studio. Expand SQL Serve Agent. Right-click on jobs and select a new job. Provide a name for the job and description. Click on the steps option> click new. Write the name of the step. Select the type of… Leer más »
-1 I am working on one of requirement the raw data is in following format Requirement – Startdate should be the date when status changed to 1 and enddate should be the 1st date after the record status changed from 1 to any other number. Customer Status Date A123 0 7/2/2021 A123 0 7/15/2021 A123 0… Leer más »
To comment out lines of code in SQL Server Management Studio (SSMS) Query Window, select lines of code you want to comment out and hit the keyboard shortcut ‘CTRL+K’ followed by ‘CTRL+C’.
A veces cuando tenemos una red de computadores en la que conviven sistemas GNU/Linux y Microsoft Windows, podemos presenciar una que otra actitud excluyente de la «ventanita» hacía el pingüino. Por ejemplo, si tenemos un servidor Samba compartiendo recursos en una red Microsoft Windows, puede que al intentar acceder a una carpeta compartida desde el Windows 10, éste nos niegue el acceso… Leer más »
https://www.mssqltips.com/sqlservertip/5970/restore-sql-server-database-backup-to-an-aws-rds-instance-of-sql-server/
https://docs.microsoft.com/en-us/troubleshoot/windows-client/shell-experience/windows-logon-process-failed-spawn-user-app
Go to the Disk Manager with the disks ready. Right-click on one of the disks and click on New Mirrored Volume 1 to launch the wizard. Click Next 1 . Select the second disk 1 and click on Add 2 . Added discs, click Next 1 . Choose the letter for the reader 1 then… Leer más »
This guide will help you with configuring software RAID-1 on Windows Server 2019 Step 1: Open menu start and type diskmgmt. It will open the Disk Management window. Step 2: Preparing GPT Partition Table for mirror on Disk 2 Please run command prompt with administrator privileges and type diskpart and press enter: DISKPART>List disk As you can… Leer más »
Modificar la MTU de una tarjeta de red en un servidor Windows Server 2016 / 2019 vía comandos de Powershell. Primero corremos Windows PowerShell como administrador Con el siguiente comando podemos ver el estado de los interfaces: Revisamos el valor de Idx y pasamos el siguiente comando para modificar la MTU de las interfaces 6… Leer más »