You can create "Database Maintenance Plans" through Enterprise Manager to back up your transaction logs.  It's a simple GUI way to do it if you're not familiar with the code,...

We're happy with Idera's Diagnostic Manager. I have a few quibbles, but I probably would with others too.  You can get free demos from all of them, so it's probably best...

Sorry to be picky, but Asterix is the much beloved character in the French comic books "Asterix & Obelix".  You can get English versions.   I think you meant asterisk. 

A few glitches I encountered (as best I can recall)

1. When referencing the remote server, don't use the DNS or "common name" of the remote server. For example, within our...

Follow on question ....    Once the icon shows there's a problem, how do you find the erroneous flag that remains and set it back ??   I had a problem a...

You just want a new index at the subscriber ?   I did this without a problem to facilitate users who were running a lot of queries ordering by date. I...

In the example you give, you are renaming the table to 'dbo.dropME', where 'DBO.' is part of the actual table name, not an owner prefix.

Try     EXEC SP_RENAME 'RenameME', 'dropME'      

Thanks .. That sounds right ...........  unless I mistakenly select "reinitialize", then I think it will re-snapshot all the tables.

That will still create snapshots for the other tables, right ?  So I need to do it in off hours to prevent locks on those tables, even though they won't...

Scott, Yes, that's the scenario she's encountering .....  I guess we'll just have to remember to delete the lines if we edit them that way.

We're on SQL2000, SP4

A developer pointed this out when I asked why there were so many blank lines at the beginning of her SP.

Here's my SP in round 1 as seen through EM     (maybe I'm missing something)

....................................

CREATE       PROC TESTTEST

AS

SELECT 'TEST'   

.....................................

Then I edit it through object browser in QA, and add a blank space...

Sorry ... I don't quite follow.

Just be sure that everyone understands that with SIMPLE recovery, you can ONLY restore a previous full backup. You will be unable to restore to a specific point in time between...

What if their backups are done with a Maint Plan through Ent Mgr ??   I don't see where you get the truncate\no_truncate option there ?   Perhaps they'd need to do a...