i tried to run this EXEC master..sp_help_revlogin from the source but still the output is only one..

/* sp_help_revlogin script

** Generated Sep 24 2012 1:11PM on JHOLS\SQL2000 */

...

thanks for the reply but still i got only one output still the administrator when i run this sp_help_revlogin

do i need to add sql user one by one using the sp_help_revlogin? because when i run this script its generate a script like this EXEC master..sp_grantlogin 'BUILTIN\Administrators' then run...

thanks sir collen it works, but again when i check my status on the view snapshot agent status and the error message give is:

Access to the path 'C:\Program Files\Microsoft...

hi collen thanks for the info. actually i created an alias on the cloud sqlserver as my subscriber, here's what i have done to create on the sqlserver config. manager..on...

thanks for the reply actually the subscriber was in the cloud so i need that server to be added to my server publication..any idea

thanks

thanks lowell i'll give it a try..

this is my stored proc;

ALTER proc [dbo].[spu_Send_Email_Notification]

@From varchar(max),

@To varchar(max),

@cc varchar(max),

@Subject varchar(max),

@Body varchar(max)

as

EXEC msdb.dbo.sp_Send_dbmail

@profile_name ='myclick',

@from_address =@From,

@recipients =@To,

@copy_recipients=@CC,

...

thanks gila i already found it..

where in the sqlserver 2008 can i find a properties/features for snapshotting the a new article?

thanks gila but the problem is if we have an additional tables and the replication is already set then we have to reinitialize again the replication to capture the ...

we only have 1 simple requirements, we only need to replicate the main db in real time to second db without any manual copying for the mdf and ldf..thanks

read my recent post then suggest if you have an option of what trying to ask.

oh i'm sorry for the upper case i've written not my intention or any negative approach, anyway just to think if there is a tool in sql2008 to replicate mdf...

thank you guys for the opinion.