replace {TABLE} with the target table name replace {DATE} with the date field.

Save the commands in a .SQL file, ex: ClearTables.sql, say in your C:\temp folder. Contents of C:\Temp\ClearTables.sql Then use sqlcmd to execute it as follows. Since you said the database is remote, use the following syntax (after updating for yourRead More…

ObjectiveTo move the SQL database .mdf and .ldf files to another drive on the server. EnvironmentPrimary Product OS : Windows 2012 ServerPrimary Product Module : Microsoft SQL 2012 Procedure Launch Microsoft’s SQL Server ManagementRead More…

If you are able to connect to your SQL server using Window Authentication mode, but encountered error when connect using SQL Server Authentication mode, Most probably, you need to turn on ServerRead More…