script for all dependencies

Hi All,
Is there any script to get all the dependencies on all the tables or all the
Stored Procedures in a database? I need to check the dependencies are still
there after I upgrade a database.
Thanks
Julia
Try this script. The output from this is the sql code you can run.
select 'sp_depends ' + '''' + name + '''' + char(13) + 'GO' from sysobjects
where type = 'U' and name not like 'dt%'
The output will look something like this:
sp_depends 'Orders'
GO
sp_depends 'Products'
GO
sp_depends 'Order Details'
GO
sp_depends 'CustomerCustomerDemo'
GO
sp_depends 'CustomerDemographics'
GO
sp_depends 'Region'
GO
sp_depends 'Territories'
GO
sp_depends 'EmployeeTerritories'
GO
sp_depends 'Employees'
GO
sp_depends 'Categories'
GO
"Julia" wrote:

> Hi All,
> Is there any script to get all the dependencies on all the tables or all the
> Stored Procedures in a database? I need to check the dependencies are still
> there after I upgrade a database.
> Thanks
> Julia

script for all dependencies

Hi All,
Is there any script to get all the dependencies on all the tables or all the
Stored Procedures in a database? I need to check the dependencies are still
there after I upgrade a database.
Thanks
JuliaTry this script. The output from this is the sql code you can run.
select 'sp_depends ' + '''' + name + '''' + char(13) + 'GO' from sysobjects
where type = 'U' and name not like 'dt%'
The output will look something like this:
sp_depends 'Orders'
GO
sp_depends 'Products'
GO
sp_depends 'Order Details'
GO
sp_depends 'CustomerCustomerDemo'
GO
sp_depends 'CustomerDemographics'
GO
sp_depends 'Region'
GO
sp_depends 'Territories'
GO
sp_depends 'EmployeeTerritories'
GO
sp_depends 'Employees'
GO
sp_depends 'Categories'
GO
"Julia" wrote:
> Hi All,
> Is there any script to get all the dependencies on all the tables or all the
> Stored Procedures in a database? I need to check the dependencies are still
> there after I upgrade a database.
> Thanks
> Julia

script for all dependencies

Hi All,
Is there any script to get all the dependencies on all the tables or all the
Stored Procedures in a database? I need to check the dependencies are still
there after I upgrade a database.
Thanks
JuliaTry this script. The output from this is the sql code you can run.
select 'sp_depends ' + '''' + name + '''' + char(13) + 'GO' from sysobjects
where type = 'U' and name not like 'dt%'
The output will look something like this:
sp_depends 'Orders'
GO
sp_depends 'Products'
GO
sp_depends 'Order Details'
GO
sp_depends 'CustomerCustomerDemo'
GO
sp_depends 'CustomerDemographics'
GO
sp_depends 'Region'
GO
sp_depends 'Territories'
GO
sp_depends 'EmployeeTerritories'
GO
sp_depends 'Employees'
GO
sp_depends 'Categories'
GO
"Julia" wrote:

> Hi All,
> Is there any script to get all the dependencies on all the tables or all t
he
> Stored Procedures in a database? I need to check the dependencies are sti
ll
> there after I upgrade a database.
> Thanks
> Julia