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

553 reads

Blogs

Daily Coping 7 Dec 2022

By

Today’s coping tip is to stop for a minute when you walk outside and...

Encryption and Data Protection Regulation

By

One of the reasons you may be considering encryption is due to the relevant...

Types of data consulting engagements and what you can expect from them

By

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Read the latest Blogs

Forums

Blocking

By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

record loading

By Bruin

I have a table from a Linked Server that I'm pulling data and would...

Either/ Or Query

By dec_obrien

Hi, I have a table containing some columns and some simple data. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers