Can't let developers run create table in production, much less REBOOT THE SERVER! I would be in there with a big whip and a loudspeaker.

Can't let developers run create table in production, much less REBOOT THE SERVER! I would be in there with a big whip and a loudspeaker.

OK, thanks.

in other words, it's exactly the same thing as creating one in GUI, just for the those of us who like typing?

thanks

thanks allen

is agent running as domain account or as local system account? sounds like the account is not valid. make sure the account exists, and has rights, then restart agent within...

Mike, thanks for the answer. When you say "I'd never want TempDB to fill up", you're talking about tempdb log? Or data? Or both?

I think when the log fills up,...

Thanx, makes sense with the staging tables. I actually smack the developers down for using large one-transactional dts to load data, 'cause it fills up the log. So staging tables...

Thank you

thanks.

my dtsrun utility was simply corrupt. I just ran it on a different server fine, with no problem. The dll entry point was the problem on this machine

didn't work.

I even tried:

master..xp_cmdshell 'DTSRUN /S "MyServer" /E /N "test_dtsrun"'

with same results.

no, but I'd break it up into several dts packages, and call them from a job.

So, what's the verdict on sp_changearticle?

Is it possible to use it to remove the article without reinitializing the whole subscribtion?