-Kyle
Add an Execute SQL task that queries @.@.VERSION prior to the query that uses the sys.*. Then you can use precedence constraints based on the version value to determine whether the tasks execute.
Code Snippet
SELECT @.@.VERSION
Add an Execute SQL task that queries @.@.VERSION prior to the query that uses the sys.*. Then you can use precedence constraints based on the version value to determine whether the tasks execute.
Code Snippet
SELECT @.@.VERSION
sql,database integrity,Cross database integrity
No comments:
Post a Comment