I have a 120 Gb production databse that I backup and restore onto other server for our internal usage, ad-hoc reports...
I am reading about transaction log shipping option, and I was wondering how that exactly works.
I backup to disk at 8:00 PM, Backup to SDLT tape at 4:00 AM, and backup...
I am trying to set up replication between two servers on a single table but it keeps failing on the same place.
I am setting up replication on "AGENCY" table.
Message is:
"Could not find stored procedure 'sp_MSupd_agency'."
Is this stored procedure supposed to be created in "distribution"...
For the last two weeks or so I can’t get any of the jobs to log the log history.
Job executes all right, SQL server log shows that the job finished, but when in Enterprise Manager you right-click to view the job history, that does not work ?!? It does not show that there is any job history for...
Hello all,
Got this code that is supposed to send an email directly from the stored procedure.
It would be really neat to be able to do that ,but allthough it doesn't error out, it does not send the email at all.
My understanding is that if you have the Outlook set up on the PC that you are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.