During management of SQL server database many times we need to get list all triggers in SQL Server database with table name and table's schema . Following query can be used to get the desired result.

Export list of tables from list of databases using bcp from sql server database. This powershell is created for exporting data from sql server and creating csv files using Microsoft BCP utility.

Any table they reference cannot be dropped without first dropping all of the stored procedures that reference it. Unfortunately normal stored procedures don’t support this option in SQL Server 2014.

Contribute to graceseo/SQL_Server_procedures development by creating an account on GitHub.

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work.

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...