The plot thickens. I can delete columns on tables that have been created in other databases. Also, the column will delete when deleting through Visual InterDev. Go figure. Thanks for...

I tried to generate it, but I get an error 0. I get that all the tables on my development server. I'll see if I can get them off...

That the SQL I am trying to use. Tried sq brackets & double quotes. Still get Incorrect syntax error near "name of column".

Ohhh. The table was created in Enterprise Mgr, so all defaults. The columns were datatype int, allow nulls & database char (10), allow nulls. Everything else was...

Thanks for your help. That's kinda what I was afraid of. I'll just keep a mental note to restart if the SQL server is taken down. Hopefully SP2 is...

Pardon my ignorance, but what ddl?

Does anybody have other thoughts on this one. The auto restart works fine if the server itself is rebooted. But if SQLServer is stopped & restarted, the SQLServerAgent...

Sounds like you are as overloaded as the rest of us. Any luck on the code? I haven't tried the trace yet. Both servers are sql 2000, just...

Steve, any luck w/ the code I sent you?

I would appreciate your assistance in decoding after all. How do I get this to you? Thanks.

Thanks. I'll give that a shot. I know VB fairly decently and I have access to programmers. Thanks. I'll let you know how that works!

That is already checked as well, both under the properties for the SQL Agent and SQL Server.

I saved it as a DTS package. However the only "step" that appears when looking the design of the package is "copy SQL Server objects". What do I check...

Tried setting up the service as described, but it is still not working. Will research why it's delaying maybe I'll find more information that way. Thanks.

This is not a replication situation. We have 2 different databases, one is an intranet and the other is accessible to our clients. Clients can log service tickets and then...