Its immediate.Log Reader will tranfer the commands to subscriber immediately.

First try to analyze the problem and then take the action accordingly. Try to run the profiler and check whats happenning. Check CPU and Memory utilizations. Try to provide more...

Looks like its login issue. Try this,http://support.microsoft.com/kb/918992/. This will help you to transfer logins and passwords between servers.

Try to create the objects using dbo i.e, dbo.objectname

Regards,

VRR

Is the databse is set to Auto grow? Doe sthe drive has enough space to grow the datafile?

Where did you find this error. Try to paste SQL server error log error

Post the errors...

Whats the service pack you have on your server?

Two shared folder are not required.

One shared folder preferably on Secondary server which stores the tlog backup files and another folder(Copyfolder) on secondary server to copy the backup files....

Post the tables structures and relationships between the tables.

You can write a script by getting the column names of the table using

select column_name from INFORMATION_SCHEMA.COLUMNS where table_name='table1'

Insert the column_name into temp table and write while to...

Here is your modified code:

declare @strdatabase nvarchar(50)

declare @strfolder nvarchar(500)

set @strdatabase = N'labmanager'

set @strfolder = N'E:\'

declare @tToday datetime

set @tToday = getdate()

declare @strbackupname nvarchar (100)

SET @strbackupname = @strdatabase + N''

+ str(datepart(year,@tToday),4,0)

+ replace(str(datepart(month,@tToday),2,0),N'',N'0')

+...

Do you want to pass all 10 items as 10 parameters to SP? Are the number of items will be 10 every time you call an SP from your application?

Thanks all. Created required script.

Thanks Greg. I thought scripting is possible. I will go ahead your suggestion