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

483 reads

Blogs

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

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

Read the latest Blogs

Forums

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

C?p nh?p d? li?u dánh giá sàn icmarkets chu?n xác nh?t

By sanicmarkets

Ic markets là sàn th? nào dây ? gi?y phép và các th? t?c...

Mumbai to Lakshadweep cruise

By omane

- Explore beautiful cruise destinations like Goa, Lakshadweep, Colombo, Maldives & many more by...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers