I just ran the following on a replicated table in Northwind and it failed:

ALTER TABLE categories

ALTER COLUMN categoryname nvarchar(15) null

Server: Msg 4929, Level 16, State 1, Line 1

Cannot alter...

Not much to work with. Can you do a log backup manually, either through EM or QA? Might want to stop/start the agent, I find that fixes a lot of...

Odds are the vendor will never know the difference. The little bit of work required to make the change is well worth it.

Andy

Is that all you're getting in the history? Plenty of disk space?

Andy

Never tried it. Be interesting to see! I'd agree that a DTS job is a fairly large undertaking and should be a last resort. You could set up transactional replication...

I dont see a way to do it using native functionality in either ADO or ADOX. Querying the system table makes sense to me.

Andy

I dont think scripts have become a dirty word. I think we have confusion sometimes where the line blurs. After all, it's entirely possibly to do everything in TSQL if...

Hey Bill,

Think this is a record for slowest reply, sorry for the delay. Did some quick testing and found that if I do the following it works:

...

I believe that once you enabled AWE you are stuck with a static memory allocation. This is not a bad thing in my opinion. You also left out that with...

Try doing 'select * from sysmessages'. I think you may find that trapping all of them is overkill though.

Andy

You can use sp_tables in Query Analyzer. If you need it from a true command line you can use OSQL to run it.

Andy

Disconnecting how? Time out? Error message?

Andy

Im sorry if the article didnt provide you with all the info you needed. The dll needs to be registered on the server using regsvr32. The location doesn't matter but...

Robert, I guess it would depend on what you were trying to do. Conceivably you could do it in a DTS package to create a table that matched your import...

Glad to help. May want to wait a bit, see if others come up with better/different solutions!

Andy