Hi

Check this

http://vyaskn.tripod.com/code/generate_inserts.txt

regards

VT

HI

here is the script i used to findout the orphans

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER  PROC dbo.ShowOrphanUsers

AS

BEGIN

 CREATE TABLE #Results

 (

  [Database Name] sysname COLLATE Latin1_General_CI_AS,

  [Orphaned User] sysname COLLATE Latin1_General_CI_AS

&nbsp

Your application might not be closing the connection properly. run sp_who2 'active'  or from Enterprise manager, Managment/Current Activity and click on Process Info which shows you all the connections to the...

well i am not looking for sp_settriggerorder. I have read an artical log back, don't remember where. I think the sp is called sp_triggersequence, but not sure....

This is what I would  like to know...actualy this was an interview question I had

1.        If a stored procedure is taking a table data type, how...

Yes.. otherwise I will not be able to connect to the database right...

Well I know that.. see the attached screen shots.. 

See the location of SQL 2000, 2005 master database file location

Thanks for that.... unfortunately the problem is when the application  tries to execute the sp, it will fail by saying object not found. i don't want to use dbo...