i've tried just inserting a record in a table and its also doing it. every is being fired off in the trigger if you do the updates inside the website...

yeah, i got the execute permission error.  so what i did was i added the user to the list of users that can access the master database and granted the...

hi phil,

why did i didnt think of that.  that's a good idea.  i'll create one that uses that logic. i

although, 'm still interested to hear some idea on how to implement...

got it.  answer is shown in the link below:

http://www.sqldts.com/default.aspx?234

my sql statement is below and after typing them and pressing on the parameters button, i am getting an error: syntax error or acces violation.  then i can't get access to the parameters...

dont worry, its a warm standby. =)

yup, that's the very first step in my log shipping, the restoration of last night's full backup.

i was testing it at first and i can't...

yeah...i can't browse the data but i did not install the SP3.  will try that one.

thanks.

ann

i'm using a standard edition of ms sql.  the terminate users option for log shipping works only if you're using the enterprise edition.

thanks for the t-sql code that shows me...

yeah. i think you need to run backup first before you can do a shrink.  i used the following code for our daily backup/shrink/etc:

BACKUP LOG SERVICECENTERMAPPED WITH TRUNCATE_ONLY

DBCC SHRINKDATABASE (N'ServiceCentermapped',...

here's what i did.

in dts i created an access connection that points to a file in another server.

then i created an sql connection that points to another server.

connect the 2...

hi sushila,

yup, ur right in the sense that i need the list of RESTORED files.  ur sql statement looks about just right and i ran it from the analyzer and...

thanks ford.  i'll try that one and see what happens on monday.

bummer, we're shrinking the log file after the full backup.  that must be the one thats screws up the log shipping.......just thinking out loud here......

does that mean the very first step in my log shipping should be the restore of last nights's full backup then continue with the usual stuff on log-shipping (backup tran...

i'm doing a log shipping every 5 minutes and it runs fine the whole day. its set to run from 6AM to 6PM.  but the next day it fails to...