How about this field in syssubscriptions table:

" ......... i could delete the transaction logs everynight after the backup since I have a new, full backup of the databases, correct? ......."

Correct ... unless you think you might have...

Idera's Diagnostic Manager is another one ... Not terribly expensive. One of their performance features is called "worst performing", and will give you a list of all the SQL SPs,...

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...