Generate SQL Script on objects and its Dependencies - Started >>4/23/2005 10:49:24 AM
==============================================================
 
Creating Folder c:\sqlserverdeploy\scripts\2005_04_23_10_49_24_Build_1556
 
Scripting Primary Dependencies for Stargate.Northwind.dbo.Employees >> 4/23/2005 10:49:24 AM
===============================================================================
 
SQL Statement =select user_name(uid)+'.'+object_name(id) as primaryObject, user_name(uid)+'.'+name as Objectname ,type from sysobjects  where id=object_id('dbo.Employees')   union  select user_name(uid)+'.'+object_name(parent_obj) as primaryObject, user_name(uid)+'.'+name as Objectname ,type from sysobjects  where  type not in ('K','F','D','C') and parent_obj=object_id('dbo.Employees')  union  select user_name(uid)+'.'+object_name(parent_obj) as primaryobject ,user_name(uid)+'.'+object_name(id) as Objectname, TYPE  from sysobjects where type not in ('K','F','D','C') and id in (select id from sysdepends where depid=object_id('dbo.Employees'))  UNION  select user_name(OBJECTPROPERTY ( object_id('dbo.Employees'), 'ownerid') ) +'.'+object_name(id) as primaryObject, name as Objectname ,case indid when 1  then 'CLUS' else 'NON' end from sysindexes where name not like '%_WA_Sys_%'  and indid not in (0,255) and id =object_id('dbo.Employees') and name not in (select name from sysobjects where parent_obj=object_id('dbo.Employees') and type ='K') 
 
Creating Folder c:\sqlserverdeploy\scripts\2005_04_23_10_49_24_Build_1556\dbo.Employees

ScriptX Stargate,sa,********,Northwind,,dbo.Employee Sales by Country,P,c:\sqlserverdeploy\scripts\2005_04_23_10_49_24_Build_1556\Stargate.Northwind.dbo.Employees\Stargate.Northwind.dbo.Employee Sales by Country.P
.
.
.
.

Checking Cross database dependencies
====================================
 
SQL Statement =select name from master.dbo.sysdatabases where name not in ('tempdb','pubs','northwind')  and status & 32 != 32 and status & 64 != 64   and status & 128 != 128 and status & 256 != 256   and status & 512 != 512 and status & 1024 != 1024   and status & 4096 != 4096 and status & 32768 !=32768 and name <> 'Northwind'  order by  name
 
Checking Cross database dependencies for master
 
SQL Statement on master=select user_name(uid)+'.'+object_name(a.id) as primaryObject, user_name(uid)+'.'+b.name as Objectname ,b.type from syscomments a join sysobjects b on a.id=b.id and (text like '% Northwind.dbo.Employees%' or text like '% Northwind..Employees%') and type <>'S'
 
Checking Cross database dependencies for model
 
SQL Statement on model=select user_name(uid)+'.'+object_name(a.id) as primaryObject, user_name(uid)+'.'+b.name as Objectname ,b.type from syscomments a join sysobjects b on a.id=b.id and (text like '% Northwind.dbo.Employees%' or text like '% Northwind..Employees%') and type <>'S'
 
Checking Cross database dependencies for msdb

Generate SQL Script on objects and its Dependencies - Completed >>4/23/2005 10:49:53 AM
===============================================================================
Completed generating scripts for objects and its dependencies. Please check c:\sqlserverdeploy\scripts\SQLServerDeploy_2005_04_23_10_49_24_Build_1556.log file for details