Technical Article

Recreate dependencies in database

This procedure refresh all views of current database in good order to recreate correct dependencies lost after updating views.This procedure just call sp_refreshview and uses temporary tableExecution of this procedure prevent errors in DTS Import/Export wyzard : Copy objects and data between SQL Server databasesexec refresh_all_views_in_order -- in current database and all dependencies are ok […]

2003-02-13

540 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Returning To An Employer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Returning To An Employer

SQL Server Collation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Collation

Replace calendar table multiplier column with date logic

By Chrissy321

Hello All, It's been a while. See the DDL/DML. I have a multiplier field...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers