by George Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
If there is a break in the restore process then we can follow the steps below to try solve the problem. First, Open SSMS and execute the following command to look at database Status. SELECT NAME, STATE_DESC FROM SYS.DATABASES As soon as you confirm that database is in... by George Grammatikos | Jun 27, 2017 | IT, IT-Troubleshooting
To access a VM from a Remote Server you must follow the next steps : 1. Download psexec 2. Run CMD with Administrative privileges 3. Execute the following command : psexec \\ 10.x.x.x cmd -u “USERNAME” -p “PASSWORD” 4. If successfully... by George Grammatikos | May 17, 2017 | SQL Server, Troubleshooting
Heap table are the tables which they don’t have any clustered index. : — List all heap tables SELECT SCH.name + ‘.’ + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id INNER JOIN sys.indexes...
