I'm trying to write a script that will completely empty a SQL Server database. This is what I have so …
sql-server sql-server-2008 ssms sp-msforeachtableI am trying to write this query to find all tables with specific column with some specific value. This is …
sql-server sql-server-2008 stored-procedures sql-server-2005 sp-msforeachtableBy using this statement in SQL Server: EXEC sp_msforeachtable 'DROP TABLE ?' I know it's possible to delete all …
sql sql-server-2008 sp-msforeachtableWhen I try to rebuild an index on a table: ALTER INDEX ALL ON [dbo].[Allocations] REBUILD that works fine. …
sql-server sql-server-2008-r2 reindex sp-msforeachtableIt seems that some scripts generated by Enterprise Manager* (or not, it doesn't matter) created check constraints WITH NOCHECK. Now …
sql-server sql-server-2000 check-constraints database-integrity sp-msforeachtableI know that sp_msforeachtable allows to perform queries on all tables. I have 100 tables and I want to perform …
sql sql-server sp-msforeachtable