Hi,

Try This PROCEDURE

-- Created By : VEERESH V NASHI (DBA)

-- Created ON : 04-02-2006

-- Purpose : To List Dependant and Reference Objects For a Given Relation

----------------

ALTER PROCEDURE dbo.prc_UTL_Dependent_Reference (@Table_Name...

hi,

what about master database ? if having so many roles, users created . I feel to take a back up of master database and restore on the new one..

I have done that using stored procedures and linked  servers. and soon i will be coming up with GUI. I will let you know once I Finished that. Now i...

Actually , if possible take last transaction back up from the production server.

apply all transaction logs to the standby server in order with norecovery and apply last transaction backup to...

While setting up logshipping there is an option wether to terminate all user connected while doing restore. Select this option if u want to terminate terminate users while doing restore.else...

I would have done this way.

If implemented simple recovery model, ( with full and differential )

Take a full back and restore at destination and  and

Implement differential backup for every...

Check out here for details.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp

You can implement if you are using windows authentication, on the domain side you can specify password size,aginging etc. You need to have windows User to SQL

I think you have to use rank clause in your query for more help see books on line for the keyword 'RANK'

and also like this ?

SELECT dbid,db_name(dbid),Count(*)

FROM   master..sysprocesses

WHERE  spid > 50

group by dbid

WHERE IS THIS @PeopleId Coming from , are u passing it as an argument to the procedure or declared inside the

procedure . If it is declare inside the procedure...

Can you give me the table structure or just check every column datatype and values returned by your WSH variables .

You can better implement this with a stored procedure.

may be             ...

I think your procedure is incomplete, when you are entering all the values inside the procedyure in where condition, then why do you want to create a dynamic query and...

I am not finding any such information regarding identity of column either syscomments or in sysobjects,

suppose If i create a table :

create table mytable ( mycolumn1 int identity(100,1), myname varchar(100)

)...

I have done like this .

From the development database once everything is tetsed and certified. I will generate script for the database and run it on the other testing...