Tagged Questions
2
votes
0answers
163 views
How to do automated archiving for a SQL Server database based on interpretation of database metadata?
I am looking for a solution giving me automated archiving of SQL Server databases based on a smart interpretation of table relationships that is able to archive records from related tables minimizing ...
3
votes
2answers
2k views
How to check that stored procedure is valid
As we know, it is possible to compile and to have so stored procedures:
CREATE PROC dbo.MyProc1
AS
SELECT * FROM Not_Exists_Or_Removed_Table
or
CREATE PROC dbo.MyProc2
AS
SELECT
Id
...
