I go into EM, make all the changes, choose "Save change script" to capture all the commands, then exit without saving the actual changes.

Or sometimes I do save the actual...

The job itself is enabled, but how about the schedule entry ? Right click the job >> Properties >> Schedules >> Edit ......... Is the enabled...

I did this recently .......

I just used Enterprise Manager to generate a SQL script for all SPs, but put them all to one file big on your C drive, then...

Use SIMPLE if going back to the last FULL backup is good enough (usually used in test or light usage environments).

Use FULL if you want the security of...

Similarly to others here, I back up to another drive, deleting the previous day's backup. After the backup, the network backup copies my backup to tape. I also backup...

You should be able to add it through Enterprise Manager ...... That's how I do it.

Running it from a desktop PC ?? Regularly, or just once ?? If regularly, why not schedule it to run as a scheduled job...

I get those memory messages every now & then (different #s each time) .... I think it has to do with my PC, not the server

I've installed SP3a on several servers ..... No issues that I'm aware of.

Why can't you change the database to bulk-logged or Simple recovery, change type to bigint, then change back to full recovery ?

I did this with good results when I needed to change the length of a field in a replicated table.

-- Specifically: Drop a table from a publication so it can...

I needed to drop an article from replication so I could change the length of a field. Here's what I did ..... seemed to work for me. I guess...

Here's what I just tried, and it seemed to work. There may be some "gotcha's" to this that I'm not aware of.

1) I just scripted out the CREATE...

I'm in the same boat.

I need to modify the length of a field in a replicated table. After dropping the subscription, the table's check box is visible, but won't...

Was an AS/400 programmer analyst at a few different places.

Before that:

R & D at Cannondale Bikes

Boring job at a thermometer company

Tool & Die at Pratt & Whitney

Night job making snow...