August 9, 2022 at 8:47 am
Hi,
I need to check for invalid views in my DB (including ambiguous columns)
does anyone can recommend how to do that ?
I saw some code from 2009 , but when i execute it (Job) it's taking ages ...
August 9, 2022 at 9:51 am
Have you tried checking for build warnings in SSDT?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 9, 2022 at 9:53 am
check sp_refreshview
EXEC sp_refreshview '[View_SCHEMA].[ViewName]'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 9, 2022 at 11:44 am
i have a cursor that execute all my views in sp_refreshview
and then my output is the views that cant run .
now, my new challenge is how to run it in a procedure or ssis ?
when i just execute the code by my self , it takes few minutes ...while im trying to execute it with ssis or job or proc
it takes really long time
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply