Category Archives: SQL Server

SQL: backup / restore DB status

A nice script I found to use when you are backing up /  restoring a SQL database and you want to see the progress.

 

SQL: getting column information

To retrieve a list of column information for a table using T-SQL, use the following method:

thanks to the original poster.

SQL: maintenance plan delete after server rename

In a previous post I spoke about changing your database server name. If you created a maintenance plan, you might notice that the plan will fail. This is because the connection of your maintenance plan could be changed. You can delete the maintenance plan by executing the following T-SQL (just change the Maintenance plan name:‚Ķ Read More »