---
title: "Desurvey Stored Procedure SQL Script"
canonical: "https://servicedesk.maxgeo.com/space/MAXGEO/1065222145/Desurvey%20Stored%20Procedure%20SQL%20Script"
format: markdown
---
First make sure you set up a Desurvey Package in the Desurveying Module in DataShed.

![image](media://fdae9614-bf81-4b0b-9bea-6b1b52783d38)

To desurvey the entire database use this script (this can take a long time):  


```sql
EXEC [dbo].[usp_DataDesurvey] @PackageName = 'Test'
```

If you want to only desurvey certain Datasets (eg DataSet1 and Dataset2) use this script:

```sql
DECLARE @DataSetFilters AS DataSetFilters
INSERT INTO @DataSetFilters(DataSet,Filter1)
VALUES ('DataSet1', NULL), ('DataSet2', NULL)
EXEC [dbo].[usp_DataDesurvey] @PackageName = 'Test', @DataSetFilters = @DataSetFilters
```