Open SSMS (If you don’t know what is SSMS, you shouldn’t be doing this…) Paste and execute this query, modifying it to your needs USE master GO ALTER DATABASE TempDB MODIFY FILE (NAME = tempdev, FILENAME = ‘d:\data\tempdb.mdf’) GO ALTER DATABASE TempDB MODIFY FILE (NAME = templog, FILENAME = ‘e:\logs\templog.ldf’) GO Restart the MS SQLSERVER ..

Read more

  Very simple! Log on to your MySQL instance, and select the DB you table is in; mysql> use mydatabase; Create the new table with the same structure as your source; mysql> CREATE TABLE mytable_new LIKE mytable; Then copy all the content from your original table into your new one; mysql> INSERT into mytable_new SELECT ..

Read more

Before you create any Export or Import; review/modify the max values for Transport, Receive and Send PS C:\Set-TransportConfig -MaxSendSize 100MB -MaxReceiveSize 100MB PS C:\Get-ReceiveConnector | Set-ReceiveConnector -MaxMessageSize 100MB PS C:\Get-SendConnector | Set-SendConnector -MaxMessageSize 100MB To create an export request: PS C:\New-MailboxExportRequest -Mailbox UserName -FilePath “\\server\folder\username.pst” ** You need to grant read/write permission to the group ..

Read more

This script will delte everyting in the “Script” folder, sub-folder, and the “-recurse” option will prevent the prompting of confirmation. The “-exclude” option alllows you to exclude files and folders. Remove-Item c:\scripts\* -recurse -exclude *.wav Alternative; $Path = ‘\\servername\folder’ Get-ChildItem -Path $Path -Recurse | Remove-Item -Force -Recurse More on the Remove-Item Powershell cmdlet can be ..

Read more

Make sure to run all listed commands from the database you are fixing, not from Master. List the orphaned users in the database EXEC sp_change_users_login ‘Report’ To assign/repair with an existing login: EXEC sp_change_users_login ‘Auto_Fix’, ‘user’ To create a new login and password for this user, use this instead: EXEC sp_change_users_login ‘Auto_Fix’, ‘user’, ‘login’, ..

Read more

1- Click Start, click Run, type cmd.exe, and then press ENTER. 2- Enter this command and then press ENTER: set devmgr_show_nonpresent_devices=1 3- Open Device Manager; Start DEVMGMT.MSC Click View, and then click Show Hidden Devices. Expand the Network Adapters tree. Right-click the dimmed network adapter, and then click ..

Read more